MicrosoftHi Everyone
My File shows "Calculate" mode even though the calculation is set to automatic and there is no such macro to stop the calculation.
Just found that I have used INDIRECT(CELL("address")) function in the following Dyanmic Array Functions, which is causing this behavior.
=SORT(UNIQUE(FILTER(TableA[PartyA],ISNUMBER(SEARCH(INDIRECT(CELL("address")),TableB[PartyB])),"not found")),,1,TRUE)
I deleted all such functions, but kept all the macros and named ranges which use Cell() functions and then "Calculate" disappeared.
Then entered =INDIRECT(CELL("address")) in one of the cells and entered some random values in some random cells. "Calculate" did not appear.
Which means that =INDIRECT(CELL("address")) itself is also not causing this behaviour.
Now I am confused why using the INDIRECT(CELL("address")) in Dynamic Array Functions is causing such an issue ?
Regards
Kanwaljit
