Forum Discussion
Slow Processing
I have a 4G spreadsheet that when I click on several of the tabs, everything is fine. The issue is that there are 2 tabs that when selected, the processing wheel spins, in some cases for minutes, be...
Hi BassR2K2 ,
Is it an *.XLSM file? If it's just two sheets that are causing the problems, it might be that there is some VBA code that gets executed when you activate those sheets.
If yes, you can have a look in the VBA code. Hit Ctrl-F11 to start the VBA editor, then double-click on the respective sheet object on the left side. Then check, if there is some code on the right side:
If there is something with "Worksheet_Activate", then you probably found your root cause.