Solved

Excel 2007 - Pivot Table Cash issue

Posted on 2014-02-21
1
396 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
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

Suggested Solutions

Title # Comments Views Activity
onenote 2016 sync 40 235
Sharepoint to FTP? 3 67
How to check if column "Assigned To" group was changed in SharePoint 2010? 18 55
iPhone excel activation issues 11 89
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

786 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