Kemidan2014
Board Regular
- Joined
- Apr 4, 2022
- Messages
- 229
- Office Version
- 365
- Platform
- Windows
So as I have been working on an excel "database" that's used to log and keep track of customer complaints after I had added a sheet to it that has 440 formulas I noticed the spreadsheet takes about 30seconds to a minute to open.
I feel like the formulas are what's bogging it down because as the macro is running and adding new data from a separate master file its recalculating
Does Application.Calculation := xlmanual apply to the WHOLE workbook or only to active sheets? I experimented with adding this into my macro that I have set up for when workbook is opened but I saw no discernable effect.
I activated the COMs Addin Inquire to run workbook analysis but it wasn't what I was expecting it to be so I am not sure how to decipher the information it has
I already have
Application.Screenupdating=false
Application.Calculation:=xlmanual
Are there any other suggestions or things I should look for that I should review to try and improve efficiency of this opening macro?
I feel like the formulas are what's bogging it down because as the macro is running and adding new data from a separate master file its recalculating
Does Application.Calculation := xlmanual apply to the WHOLE workbook or only to active sheets? I experimented with adding this into my macro that I have set up for when workbook is opened but I saw no discernable effect.
I activated the COMs Addin Inquire to run workbook analysis but it wasn't what I was expecting it to be so I am not sure how to decipher the information it has
I already have
Application.Screenupdating=false
Application.Calculation:=xlmanual
Are there any other suggestions or things I should look for that I should review to try and improve efficiency of this opening macro?