View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] staeri@gmail.com is offline
external usenet poster
 
Posts: 35
Default Slow saving when adding VBA forms

I have a Excel 2003 workbook (0,6 Mb) with 9 simple sheets and 4 hidden
sheets. I also have VBA forms with code. Saving this file takes 10
seconds which is way too long.

If I create a new workbook and copy the sheets into the new workbook
the time for saving is ok. As soon as I also copy the VBA forms the
saving time increases to 10 seconds.

I run this workbook on a Pentium 2.0 Ghz processor with 1 Gb RAM, Excel
2003 and Windows XP. A friend of mine has tested the same workbook on a
computer with Windows 98 SE, Office 2000 and the time for saving is
less than 1 second.

How can this be possible? Is there any solution? Has anyone else
experienced this?

Regards,

SE