LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Size of file grows

I have a workbook where I transfer data from several pages to what I call the
Sorting Sheet, perform various sorts and than transfer the data to other
woeksheets. Before saving the file the Sorting Sheet is cleared. The
process runs on a macro. However, everytime I run the macro the file size
increases about .02MB, not a lot but after many operations the size gets to
be a problem. Deleting the worksheet and installing a new one brings the
file size down to the original but I've been unable to add that process into
my macro. Any suggestions?
--
Robert K
 
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
file size grows so big zy1972 Excel Discussion (Misc queries) 1 August 13th 08 02:36 PM
File Size With Macros Has Increased From Its Origina Size Fred Excel Discussion (Misc queries) 1 April 26th 08 12:24 AM
Check box gets weird size when cell height grows Rene Excel Discussion (Misc queries) 1 March 20th 08 02:44 PM
Shared Workbook inexplicably grows in size Bob Excel Discussion (Misc queries) 0 August 18th 06 01:29 PM
Temp file grows(no-end)when Excel97 attempts to save to net-2003Se t.staudle Excel Discussion (Misc queries) 0 November 8th 05 08:37 PM


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