LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 100
Default A .XLSM file suddenly quadrupled in size

Greetings! The main workbook for my Excel Macro program is normally about 250
KB in size, and is opened by an Auto_Open macro. It is a macro enabled
workbook containing mostly text strings. But suddenly and without apparent
explanation it increased in size to 700 KB and then a day later to 1295 KB. I
tried to open the 1295 KB file in Excel and after about 20 minutes Excel was
still trying to open the file. So I opened the 700 KB file (took about 6
minutes!) and carefully looked at the data it contained. I did not see any
unexpected or extraneous data. But navigation through the cells was extremely
sluggish. I used an antivirus program and then an anti-spyware program to
scan the 1295 KB file, but neither program found any problems. I should
mention that my computer is running Windows Vista with Service Pack One.
There is 1 GB of RAM and plenty of hard disk space. Excel is the 2007 Home
and Student edition. Any ideas or suggestions will be greatly appreciated. I
can email this 1295 KB file to anyone who is interested in seeing it.
--
May you have a most blessed day!

Sincerely,

Michael Fitzpatrick
 
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
How to open XLSM file in IE9 Manuelauch Excel Discussion (Misc queries) 0 November 9th 09 04:55 PM
Excel File Suddenly Grew 7X in Size - Very Slow Now [email protected] Excel Programming 6 February 9th 09 03:53 PM
what is xlsm' file Donna Excel Discussion (Misc queries) 2 January 9th 09 02:43 PM
excel 2003 file converted to .xlsm file when save to network drive Chris Excel Discussion (Misc queries) 3 January 23rd 08 02:56 PM
Why did my Excel file suddenly balloon in size? Dave Excel Discussion (Misc queries) 6 January 3rd 06 03:20 PM


All times are GMT +1. The time now is 06:07 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"