Pivot Table Issues

Fix Excel Slicers That Cannot Be Edited on Mac

Nimra MalikNimra Malik Nov 13, 2026 869 views

Question details

The user needs to edit and use slicers in a Windows-created Excel pivot table on a Mac.

Fix Excel Slicers That Cannot Be Edited on 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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook in Windows

Open the workbook in Excel for Windows, where the pivot table's data source and connection are supported.

2
Check the connection

Select Data > Queries & Connections to inspect the workbook's connections and confirm that the required source is available.

3
Edit the report

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.

4
Save the workbook

Choose File > Save, then reopen the workbook on your Mac to check which report features are available there.

Edit the Pivot Table and Slicers in Excel for Windows
Mac limitations may remain: Saving the edited workbook in Windows does not guarantee that an unsupported connection or its slicers will become editable on Mac.
Free Microsoft Office alternative

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.

Open and edit common Microsoft Excel formats, including XLSXUse a familiar spreadsheet interface for everyday workbook tasksCreate pivot table summaries from suitable worksheet dataMove common spreadsheet work to a free, lightweight office suite
microsoft office alternative - wps office

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.