Fix Excel Slicers That Cannot Be Edited on Mac
Question details
The user needs to edit and use slicers in a Windows-created Excel pivot table on a Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A workbook created in Excel for Windows contains a pivot table and slicers linked to an external data source, although the data is also in the file.
- Observed behavior
- The slicers can be removed, but their options cannot be selected. Excel reports that the pivot table uses an external data source unsupported by the Mac version.
In Excel for Mac, check Help > Check for Updates and install any available updates. Also identify the pivot table's source or connection; data appearing in the workbook does not necessarily mean the pivot table uses it as a local source.
Edit the Pivot Table and Slicers in Excel for Windows
Use a supported Windows version of Excel when the existing report depends on a data source that Excel for Mac cannot edit.
Open the workbook in Excel for Windows, where the pivot table's data source and connection are supported.
Select Data > Queries & Connections to inspect the workbook's connections and confirm that the required source is available.
Select the pivot table or slicer and make the needed changes. If the data source is available, use Data > Refresh All to update the report.
Choose File > Save, then reopen the workbook on your Mac to check which report features are available there.

Rebuild the Pivot Table from a Compatible Worksheet Source
Use this approach when the source data is available in a worksheet and the report can be recreated without the unsupported connection.
Work with Spreadsheet Reports in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move everyday workbook tasks between office suites. It does not fix Excel for Mac's unsupported data connections, so check advanced pivot table and slicer compatibility before relying on an existing report.

Frequently Asked Questions
Why can I remove a slicer but not select its options on my Mac?
The slicer may be linked to a pivot table that uses a connection or data source unsupported by your Excel for Mac version. Try editing it in a supported version of Excel for Windows or rebuilding the report from a compatible worksheet source.
Why does Excel say the source is external when the data is in the workbook?
The pivot table may still use a connection or data model rather than the visible worksheet range directly. In Excel for Windows, check Data > Queries & Connections to inspect the workbook's connections.
Will updating Excel for Mac fix the slicers?
An update may add improvements, but it does not guarantee support for the report's particular source. Choose Help > Check for Updates, install available updates, and test the slicers again.
Can I recreate the slicers without the original connection?
If the necessary data is available in a compatible worksheet range, select it and choose Insert > PivotTable. Rebuild the fields, then select the new pivot table and choose Insert > Slicer.
Should I call a phone number posted in a forum reply about this issue?
Be cautious of unsolicited requests to call support, an advisor, or an MVP; they may be phishing attempts. Instead, use the official support options available through Excel or Microsoft's website.




