Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Very slow to save file
I have a workbook with 203 tabs. The first three are different type summary
sheets for the other 200. Everything was fine until I ran a macro to change the tab names and another to update one of the summary pages to reflect the tab changes. I deleted the two macros and their modules and then did a save as with the updated file. Now it takes forever to save the new file. I found a macro to clear all codes and ran that...downloaded a cleaner and ran that, which says there are no codes to clean up, but still it takes 30 seconds or more to save the file. The old file was full of data entries and it saved in only a second or two, and the new file actually is smaller than the old file it replaced. Does anyone know what could be causing this? Please help me out if you can. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file slow to save | Excel Discussion (Misc queries) | |||
Slow Save | Excel Worksheet Functions | |||
Slow Save | Excel Discussion (Misc queries) | |||
Slow File|Save As | New Users to Excel | |||
excel slow save etc | Excel Worksheet Functions |