Forum Discussion
Large Workbook Calculations
I have a question about equations using a large amount of data in a workbook (containing over 100 spreadsheets). Basically I have wage data for over 100 different agencies (each with it's own spreads...
The best solution may be to consolidate the 100+ sheets into 1 central sheet where the analysis becomes much easier with formulas or a pivot.
With 100+ sheets and a summary, my guess is the INDIRECT is the biggest problem. If you're not able to consolidate the sheets, VSTACK is capable of consolidating the sheets but that may be pushing it (Dependent on the number of rows across those 100+ sheets).