| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
long time to close spreadsheet
I have a small (164kb) Excel spreadsheet with some macros. The file opens
fine, but when you close it, it takes over two minutes. It does not matter if you add anything, or if you just open and close it. I am using Excel 2002 (10.6841.6839)SP3, and am running Windows XP Pro SP2. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
long time to close spreadsheet
A couple of things:
a. Is there a macro that runs on close or before_save? b. Do you have Calculation set to Manual and to Recalculate before save? That would be in the options for Excel. Those two things could slow down the save portion. -- Rui "Don" wrote in message ... I have a small (164kb) Excel spreadsheet with some macros. The file opens fine, but when you close it, it takes over two minutes. It does not matter if you add anything, or if you just open and close it. I am using Excel 2002 (10.6841.6839)SP3, and am running Windows XP Pro SP2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete blank rows at one time in a long excel spreadsheet? | Excel Worksheet Functions | |||
| Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
| Long time to open spreadsheet (running Excel 2007) | Excel Discussion (Misc queries) | |||
| Run Macro when close spreadsheet | Excel Discussion (Misc queries) | |||
| BLANK EXCEL PAGE STILL EXIST AFTER I CLOSE OUT SPREADSHEET? | New Users to Excel | |||
Linear Mode
