I know i can manually turn off auto-calculation when i start Excel (via Tools --> Options --> Calculation --> manual).. BUT, what i need to figure out is how do i prevent auto-calculating when I double-click a ".xls" file from my file system and then Excel launches??
I have a large file that has many (thousands) of Vlookups and when i forget to open Excel and change the option first, i end up waiting.... and waiting....
Is there any way to use VB code to disable auto-calc when I launch Excel by double-clicking my file from the file system?
I have a large file that has many (thousands) of Vlookups and when i forget to open Excel and change the option first, i end up waiting.... and waiting....
Is there any way to use VB code to disable auto-calc when I launch Excel by double-clicking my file from the file system?