LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Donald Speirs
 
Posts: n/a
Default Macros making file saving extremely slow.

Hello,

I have an Excel spreadsheet with over one hundred small Macros embedded
within it. Although the spreadsheet is only a modest size (approx 1.5MB), it
takes an extremely long time to save (usually several minutes).

I suspect the Macros have increased the number of file addresses needed to
create the spreadsheet file, which is the reason for the increase in the save
time. Is there any way of addressing this problem short of deleting the
Macros?

many thanks,

Donald Speirs (Scotland).

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros disappear after a file is imported Brent E Excel Discussion (Misc queries) 1 December 18th 04 12:25 AM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 13th 04 11:51 PM
Opening and saving Excel 2003 file from Excel 97. Rodrigo Excel Discussion (Misc queries) 2 December 12th 04 02:17 PM
Getting a file and Saving a File carl0s66 Excel Discussion (Misc queries) 2 November 29th 04 09:59 PM
Error Message appearing when saving a file JaneC Excel Discussion (Misc queries) 0 November 25th 04 10:35 PM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"