Excel file size increasing over time

cocks17

New Member
Joined
Dec 20, 2010
Messages
36
Hi Guys<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p> </o:p>
I have a file which has several pivots from a data cube in it. The pivots have a fixed lookback period of 365 days of data. So my question is how does a file size constantly get bigger and bigger when the data is simply rotating round and there is only a fixed amount of cells of data? Is there some kind of history of changes in the file which is building up with refreshes?<o:p></o:p>

The problem is this is causing my file to open slowly and generally be quite slow.<o:p></o:p>
Thanks<o:p></o:p>
Paul<o:p></o:p>
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,108,910
Messages
5,525,587
Members
409,652
Latest member
strangelyangely

This Week's Hot Topics

Top