Cannot open Pivot Table from excel 2016

Question

I cannot open pivot table from excel 2016 with allert: 

"This PivotTable connects to an external data source that's not supported in this version of Excel"

Please help?

Answer 1

Sorry that’s my fault. I didn’t notice you had a Mac.

Here is a link to instructions on a “clean startup” for Macs to see if a background program is interfering with Office.

https://support.microsoft.com/en-us/help/239859...

If that doesn’t work, you’ll need to uninstall and reinstall.

Here are the instructions on how to uninstall for Mac:

https://support.office.com/en-us/article/uninst...

Here is the link to install the latest stable version:

https://support.office.com/en-us/article/Update...

Answer 2

is there any step for Macbook? thanks alot

Answer 3

Sorry about the link. Here is a working link. Please try the online repair.

https://support.office.com/en-us/article/repair...

Answer 4

Were you able to open it before? And in Excel 2016 or an older version? Has anything changed such as an update?

You could try doing an online repair of the installation.

The instructions to follow to do this are here:

https://support.office.com/en-us/article/Repair...

I can open normal excel, but this particular file I cant open (analytics data), received every week but cannot open the pivot. the repair installation link its not found...any other source?

I just updated my excel to 2016 and result the same...

Answer 5

Were you able to open it before? And in Excel 2016 or an older version? Has anything changed such as an update?

You could try doing an online repair of the installation.

The instructions to follow to do this are here:

https://support.office.com/en-us/article/Repair...