View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Faisal... Faisal... is offline
external usenet poster
 
Posts: 27
Default excel file size problems

It may be a problem with some blank cells in your spreadsheet. Try
deleting the unused rows after your data down to row 65500 and see
whether this reduces the size of your file.

Faisal...

On 5 Nov, 12:22, kim wrote:
I have an excel file that I've been working with for over a year -
developing Macros and running them to develop a product for my job on
a quarterly basis. My spreadsheet has grown by 10 times (1200kb to
12,000kb) over time, but I haven't added a lot of data. Can you help
me figure out the problem and fix it?

Thanks