• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • Last Modified:

Excel 2007 - Pivot Table Cash issue

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
CABRLU63
Asked:
CABRLU63
1 Solution
 
andrewssd3Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now