LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Must reduce file size

I have an excel app with a lot of vba and a lot of formulas. It has always
been around 10MB but after adding much more vba functionality (UserForms and
code mostly) it has grown by about 5MB. Many of the worksheets go past row
5000, even when I select all cells below row 200 for all columns and delete
(shift up & left). How can I reduce the file size? What components make up
file size other than data? Is there a way to evaluate these components?

Thanks
 
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
help to reduce size of my file Ben Excel Discussion (Misc queries) 2 March 28th 10 10:45 AM
how to set sheet size to reduce file size LJ Excel Discussion (Misc queries) 1 November 26th 06 02:35 AM
reduce the size of a file Jason M Excel Discussion (Misc queries) 3 October 31st 06 04:10 PM
Need to Reduce the file size Terry Davies Excel Discussion (Misc queries) 0 April 4th 06 02:13 PM
Reduce size file tempêtje Excel Discussion (Misc queries) 2 March 29th 05 12:19 PM


All times are GMT +1. The time now is 10:36 AM.

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

About Us

"It's about Microsoft Excel"