J
Jim
I'm going a little crazy with Excel today. I am attempting to write
a macro that will allow a user to open two additional spreadsheets
(*.slk files) generated by the same external utility. I have a very
complicated worksheet that analyzes the data from these worksheets.
As such I have made sure that the main workbook has calculate set to
MANUAL. When I open the first *.slk file and copy the needed data
and paste the data everything works fine (i.e. NO CALCULATIONS).
However,when I load the second file this *.slk file opens and
immediately performs a calculate which takes several minutes. Both
*.slk files are opened from the same function call. I also found that
when I switch the order that the calculations also reverse meaning
that the calulations are performed by the first file (formerly second)
opened. This leads me to believe that there is something file
specific not code related. Any ideas?
Thanks!
a macro that will allow a user to open two additional spreadsheets
(*.slk files) generated by the same external utility. I have a very
complicated worksheet that analyzes the data from these worksheets.
As such I have made sure that the main workbook has calculate set to
MANUAL. When I open the first *.slk file and copy the needed data
and paste the data everything works fine (i.e. NO CALCULATIONS).
However,when I load the second file this *.slk file opens and
immediately performs a calculate which takes several minutes. Both
*.slk files are opened from the same function call. I also found that
when I switch the order that the calculations also reverse meaning
that the calulations are performed by the first file (formerly second)
opened. This leads me to believe that there is something file
specific not code related. Any ideas?
Thanks!