Hi Guys<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
<o> </o>
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></o>
The problem is this is causing my file to open slowly and generally be quite slow.<o></o>
Thanks<o></o>
Paul<o></o>
fficeffice" /><o></o><o
> </o>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
></o>The problem is this is causing my file to open slowly and generally be quite slow.<o
></o>Thanks<o
></o>Paul<o
></o>
