Booged down due to calculations

[Hida Kisada]

Creating a file to display information that i am pulling from other reports i have downloaded into excel as a tab.

I pull this information primary through VLOOKUPS, SUBTOTAL, and SUMIFS formulas. That said, because of this. The updating of cells and tabs and the whole workbook is a timely process. I know i can cut this down by turning off calculations. However this doesn't help when the calculation is turned back on.

I am curious, if there is a way to turn off calculation. however turning it on for a single tab and not the workbook. or is there something else you know of that can help me here that i don't know of.

As these files - i make one for each month/period- are typically in the 40-65K KB range

 

[Joe4]

Welcome to the Board!

What you are describing (a ton of inter-related data) is really a relational database. While you may be able to use Excel for this, it is really not what it was designed for. So as your data gets really large, it can really bog down performance (as you are experiencing). Bottom line: you are probably using the wrong tool for the job!

A relational database program, like Microsoft Access or SQL, will work much better, as that is what these things are designed for.
If you are stuck using Excel, you may want to investigate using Power Query, which allows you to do database-type actions within Excel.
See: About Power Query in Excel - Microsoft Support.

There is also a whole forum here dedicated to those questions called Power Tools, that you can post Power Query questions in.