Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AUTO/MANUAL Calculate in Excel when opening *.slk files
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 were created by the saming utility (external to Excel) and both are opened from the same function call. I also found that when I switch the order that I open the files that calculation also reverse meaning that the calulations are performed by the first file (formerly second) opened and not the second file. This leads me to believe that there is something file specific not code related. Any ideas? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Calculate Keeps Resetting to Manual | Excel Worksheet Functions | |||
Why did auto calculate suddenly change to manual calcu... | Excel Discussion (Misc queries) | |||
Auto/Manual Calculation using *.slk files | New Users to Excel | |||
How do you make the auto calculate setting stay on manual permanently? | Excel Programming | |||
How to auto start a new Excel image or window when opening files | Setting up and Configuration of Excel |