my excel file gettting bigger and bigger

Posted by DaJiang on February 01, 2001 1:38 AM

Hi,

I use excel generate daily traffic report. Because of large amount of data imported from external text file, (from some 20 files into different spreadsheets) one of my excel file is about 4M. But I find the daily file is getting bigger and bigger even though the external data file size remains same.
I don't use any external links. But there are many internal links and several macros.

DaJiang

Posted by Dave Hawley on February 01, 2001 2:12 AM

Hi Dajiang

Here are some methods to reduce file size.

1. Save as "Microsoft Excel Workbook" as apposed to 97/95.

2. Open the VBE and Export all Modules and Forms to your hard drive (right click on them and select Export). Then delete all Modules and Forms in your Workbook. Now Import all Forms and Modules from your hard drive back in.

3.Right Click on any sheet name tab and select "Move or Copy". From the "To book" select "(new book)". Select the "Create a copy" box and click OK. Now save this new book as any name and go to File>Properties|General and see how much the new workbook has increased in size. Do the same for all sheets.

If a sheet causes an unreasonable increase in file size then it is probably corrupt. Try highlight all the data on the sheet and then copy it to a new sheet. If still no change then copy small areas at a time, save and check file size. This will narrow down any corrupt data, which will need re-doing.

I hope this helps. Good Luck

Dave

OzGrid Business Applications