Excel Pivot tables

Hello,


I have a problem with pivot tables in Excel on my MacBook Air.

I can not refresh pivot tables and constantly receiving error message:

The operation connects to an external data source.

External data sources are used to import data into Excel, but connections to external data sources can be used by queries to access confidential information available to other users, or to perform other harmful actions. If you trust the source of this file, click OK.

 

Alert

Problems obtaining data.


How can I fix the problem?


Thanks in advance!

Posted on Jan 13, 2023 12:26 AM

Reply

Similar questions

2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Excel Pivot tables

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.