My workbook size is small, around 5 mbs, but at times gets hung up spinning with 4 processors anytime i move to a new cell. I have a summary sheet that references around 20+ other sheets pulling data via Indirect(Address). I believe this formula is slowing my workbook down. Is there a replacement for quicker calculation.My formula is simple, looks like this =+IFERROR(INDIRECT(ADDRESS(L$1,L$2,1,1,$B12)),""). This formula is used around 40x per row, with about 40 columns. Any help would be appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Replacement for Indirect(Address)
- Thread starter brejohns
- Start date
Similar threads
- Solved
- Question
- Solved
