Hi every week I create a pivot table based on the on the number of weeks that have passed in the year to date so far e.g. this week is week 24, however, when I select the range for the pivot table I select all of the columns from the data table (A:AZ) and consequently with the new data being added every week my file is now over 10MB and growing every week.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
My question is. can I only selective the columns of data I want to use in my pivot table e.g. column A, D. S, X , Z rather than highlighting the data A:AZ.
<o></o>
As a work around to make the file smaller I have turned off the facility “Save Data with Table Layout” which does reduce the file size somewhat
<o></o>
Any help would be greatly appreciated.
<o></o>
<o></o>
Many Thanks in advance
<o></o>
<o></o>
Bob
<o></o>
Excel version 2003
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
My question is. can I only selective the columns of data I want to use in my pivot table e.g. column A, D. S, X , Z rather than highlighting the data A:AZ.
<o></o>
As a work around to make the file smaller I have turned off the facility “Save Data with Table Layout” which does reduce the file size somewhat
<o></o>
Any help would be greatly appreciated.
<o></o>
<o></o>
Many Thanks in advance
<o></o>
<o></o>
Bob
<o></o>
Excel version 2003