Forum Discussion
Solved
EXCEL LIMITATIONS
Can one workbook handle 52 Tabs with 2400 "Retrieval Formulas" (In Other Words Pulling Information from 300 excel files". That's a combination of 124,800 formulas in one work book.
Number of formulas is limited only by resources (memory, etc). 124800 formulas which get information from 300 files could have a lot of time if not hangs. Perhaps Power Query or like will be more optimal solution.
Number of formulas is limited only by resources (memory, etc). 124800 formulas which get information from 300 files could have a lot of time if not hangs. Perhaps Power Query or like will be more optimal solution.
- Thank you!
Time to learn something new.
Tim
