Forum Discussion
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.
6 Replies
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
Worksheet and workbook specifications and limits
Excel specifications and limits
Please see this link above for more information.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
It is not possible to answer your answer with yes or no, as there are limitations in sub and general areas.
Example: does your formula also include links? If yes, how many?
How big is the workbook? ... in MB.
Which version of Excel are you using?
Are the files on the hard drive, OneDrive, Sharepoint?
Concurrent requests via workbook? ... more than six?
That is why I have sent you this link, where you can look up for yourself where there might be a limitation in your work map, if at all.
Here is a link with further information about possible limitations.
Data Model specification and limits
Hope I was able to help you with this info.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
