The incredible growing file!

[noahcount]

Newbie here! Nice board..., shoulda been here years ago! I have a file that contains 4 queries and some financial statement type ranges that I publish to a website with VB. The processing time for the file/code has increased gradually over the year as well as the file size. Started @ 500k and grew to 5,000+k in 6 months. Excel 2000 and Win2000 pro. The only changes to the file have been from daily updates to the queries which only contain summary data. The file has slowed to the point of hanging the system. I copied the queries, code, and print ranges to a new file and it flies again. What gives?

 

[Anne Troy]

Is your data inserted each time? This could cause unnecessary leftover cells with *stuff* (formatting, etc.) being saved in them. To test, open and click on A1, hit Shift-Ctrl-End. Is more than your data selected? If so, delete.

Are you building up formats in your file? Always format by grouping as many columns, rows, cells as possible, then apply the desired format. If I format 10 cells individually, Excel saves 10 formats. If I format 10 cells at once, Excel saves 1 format.

Also, copying sheets to a new workbook (instead of copy/paste cells) sometimes gets rid of potential corruption, though I consider this less likely in your case.

Just some thoughts...