How to Fix Excel Pivot Table Refresh Errors on Mac
Question details
Users are unable to refresh Pivot Tables connected to external data sources on Mac, resulting in a data retrieval error.

- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Attempting to update a Pivot Table that pulls information from an external database or query.
- Observed behavior
- Excel displays a 'Problems obtaining data' error message and aborts the Pivot Table refresh process.
Ensure your MacBook Air is actively connected to the network hosting the external database and that your login credentials are up to date.
Review and Update Queries & Connections
Verify your external data connection settings and repair any invalid credentials or broken query links.
Data connections often break when a file is moved, passwords change, or when shifting from a Windows PC to a Mac environment.
Launch your workbook in Excel for Mac and click on the 'Data' tab located in the top ribbon.
Click on 'Queries & Connections' to open the sidebar that lists all active external data links in your workbook.
Right-click the problematic connection in the list and select 'Properties' to verify the source URL, credentials, and permissions.
Correct any outdated information, save your changes, and click 'Refresh All' to see if the Pivot Table updates successfully.

Discover a Seamless Spreadsheet Experience on Mac with WPS Office
Dealing with complex Excel driver issues on macOS can be frustrating. Switch to WPS Office for a lightweight, highly compatible, and completely free alternative to manage your spreadsheets and perform data analysis without the hassle.
- 1. Download WPS Office: Visit the official WPS website and download the macOS version.
- 2. Install the Software: Open the installer package and drag WPS Office to your Applications folder.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing Excel files to seamlessly continue your work.

Frequently Asked Questions
Why does Excel for Mac say 'Problems obtaining data' during a refresh?
This error occurs when the file path to the external data is broken, your network connection to the database has dropped, or the workbook is attempting to use a Windows-only data driver on your Mac.
Can I use Windows ODBC drivers in Excel for Mac?
No, macOS cannot run Windows ODBC drivers. If your Pivot Table connects to a SQL or external database, you will need to install specific Mac-compatible ODBC drivers provided by your database vendor.
How do I remove the external connection from a Pivot Table?
You can unlink it by copying the Pivot Table and pasting it as values. Alternatively, navigate to the 'PivotTable Analyze' tab, click 'Change Data Source', and point it to a local data range within the same workbook.




