Hi I’m looking for VBA code to turn off the screen refreshing on key values in cube functions. I have a large Excel spreadsheet with many tabs and it takes 20 minutes for the system to refresh the information from our SQL Server database. I was thinking if I turn off the screen refreshing of the formulas to only be updated when I select the tab that might speed up the processing of the spreadsheet
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Cubevalues
- Thread starter shophoney
- Start date
XLfriend777
Well-known Member
- Joined
- Nov 15, 2013
- Messages
- 690
Hi shophoney - Have you tried:
Code:
Application.ScreenUpdating = False
Upvote
0
