Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • 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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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