Solved

Excel 2007 - Pivot Table Cash issue

Posted on 2014-02-21
1
402 Views
Last Modified: 2014-02-24
Hello,

I have Excel 2007 sheet with 20+ tabs, each tab has Pivot Table.
I have one tab with the source data. There is also some VBA code, mainly for modifications of sheets and automation (macros).
I copied entire workbook, renamed it and using it for different project.
Same number of pivots and one source data tab - just different data will be used.
I've noticed that my new .xlsm file is now 45 MB! Huge!
I know that this is cashing issue.
How to fix it?
Thanks!
0
Comment
Question by:CABRLU63
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 17

Accepted Solution

by:
andrewssd3 earned 500 total points
ID: 39879087
Go to Pivot Table Options (This is on the Pivot table Analyse tab on the ribbon on my Excel 2013 - can't remember exactly if it's the same on 2007), then on the Data tab, uncheck 'Save source data with file'. This should clear your cache.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question