Hida Kisada
New Member
- Joined
- Oct 18, 2023
- Messages
- 1
- Office Version
- 2011
- Platform
- Windows
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
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