File Format & Compatibility

Find and Remove Embedded Objects and Links in Excel for Mac

Aamir Naveed AkramAamir Naveed Akram Nov 14, 2026 868 views

Question details

Find and remove embedded objects or external links that may affect an Excel workbook and AutoSave.

Find and Remove Embedded Objects and Links in Excel for Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
A workbook contains objects or links that are not immediately visible, and the user wants to inspect and remove unwanted items.
Observed behavior
AutoSave may be unavailable, while embedded objects or external links are difficult to identify.
Before you start

Open the workbook in Excel for Mac and check each worksheet for objects or links. If AutoSave is unavailable, also check that the file is saved to OneDrive or SharePoint in a supported format such as .xlsx.

Solution 1Recommended

Find and Remove Objects in Excel for Mac

Use Go To Special and the Selection Pane to identify and remove unwanted objects on a worksheet.

1
Select the worksheet

Open the workbook and click the worksheet tab you want to inspect.

2
Find objects

Choose Edit > Find > Go To > Special, select Objects, and click OK. Excel selects objects on the current worksheet.

3
Inspect individual items

Open the Selection Pane from the Shape Format tab, if available, and select items by name. You can also press Tab to cycle through objects on the sheet.

4
Remove unwanted objects

Select an object you no longer need and press Delete. Repeat on other worksheet tabs, then save the workbook and check the AutoSave toggle.

Find and Remove Objects in Excel for Mac
Review before deleting: Go To Special can select multiple objects at once, including charts and shapes. Do not press Delete until you have confirmed what is selected. OLE objects created in Excel for Windows may have limited support on a Mac.
Free Microsoft Office alternative

Work With Excel Files in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats. Open existing workbooks to continue working with minimal disruption; WPS does not fix Microsoft Excel's AutoSave behavior.

Open and edit Microsoft Excel XLSX and XLS filesReview workbook content, including visible shapes and other objectsUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

How can I find hidden objects on an Excel worksheet?

In Excel for Mac, choose Edit > Find > Go To > Special > Objects. You can also use the Selection Pane on the Shape Format tab, when available, to inspect objects by name.

Will Go To Special find objects on every sheet?

Go To Special selects objects on the current worksheet. Click each worksheet tab and repeat the search to inspect the rest of the workbook.

What happens when I break an external workbook link?

When you choose Break Link under Data > Workbook Links or Edit Links, affected formulas that refer to that source are converted to their current values.

Why is AutoSave still unavailable after I remove objects?

Objects and links are not the only possible causes. Check that the workbook is saved to OneDrive or SharePoint in a supported format such as .xlsx, and review the AutoSave toggle in Excel.