Size of Report Mysteriously Increasing Daily

  • Thread starter Thread starter penroma
  • Start date Start date
P

penroma

I have an Excel report that I add to daily. It has 9 tabs with graphs
on 7 of those tabs. I only display 21 days at a time, so each day I
delete the oldest day and add a new day. Therefore, the report should
stay abou the same size. However, it increases by at least 200 bytes a
day. On Jan 4, 2004 it was 2189KB, today it is 5899KB. For two of the
tabs, I copy the entire page from another report and paste it in.
Would this possibly cause it to increase everyday?
Thanks for your help!
 
This might help. If you delete entire rows or columns by just removin
the data Excel still behaves as if they exist. Try removing empt
rows/columns by selecting their headers and then deleting
 
Back
Top