Keeping the majority of that data (200 tabs) in a database and just the 3
aggregate pages in Excel might alleviate the slowness.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"dfmstes1" wrote:

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