Forum Discussion
EXCEL LIMITATIONS
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.
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)
Thanks, that makes more sense. I'm good with excel, wrote a ten year program to run the business, we are in our 6th year.
There is a folder called "TECHS TEMPLATES". In that folder are 300 excel files. Each file represents 10 years, 2026-2035. The old program ends in 2025.
There is a MASTER outside of that folder. The TEMPLATES are in a "Cloud" but they are downloaded to a Computer Folder where the MASTER is housed. I would like to have 52 TABS in the MASTER, one TAB for each week of a year. I was going to create 10 MASTERS, one for each year of the ten year cycle I'm creating. When the MASTER is opened I would like it to pull information from each of the 300 excel files. There are 124,800 links from those 300 files to the MASTER. I'm running Office Professional 2016.
What do you think?