Share via

Unlink pivot table cache

Anonymous
2018-12-24T05:25:00+00:00

Using Excel for Mac Version 16.2

How can I unlink the pivot table cache in separate pivot tables using the same source data?  There is an instruction for windows-based excel, but it doesn't work for zMac.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2018-12-24T07:36:13+00:00

Hi HarryForsythe1,

We are sorry, for now, the "PivotTable and PivotChart Wizard" is not available on Excel for Mac, so the methods provided in this instruction couldn't help you in your scenario. Given this situation, we would suggest you vote for Please bring back "PivotTable and PivotChart Wizard" to Excel on Mac in Excel UserVoice, which is the a specific platform for us to collect user's request. Your suggestion will help us improve our Products.

But per my research and test, you can unshare a data cache between PivotTable in Excel for Mac via VBA code. Please check the third method in the link below.

How do I “separate” Pivot Tables

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.​​

Meanwhile, I would like to mentioned that your Excel version is far behind the latest version. It is always recommended to keep your Office updated to have a better experience.

Your understanding is highly appreciated.

Regards,

Alex Chen

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest