Office Compatibility Issues

How to Prevent Linked Excel Objects from Resizing in PowerPoint

WPS Editor Oct 1, 2026 868 views

Question details

The user needs to know how to keep linked Excel charts or tables from automatically changing size and scope in PowerPoint when the source data is updated.

How to Prevent Linked Excel Objects from Resizing in PowerPoint

Product: Microsoft PowerPoint and Excel
Device & OS: not provided
Scenario: Updating source data in an Excel workbook that is dynamically linked to a PowerPoint presentation.
Observed behavior: Linked Excel charts and table ranges unexpectedly change dimensions or scope after the source data updates, and PowerPoint lacks a reliable built-in option to lock the object size.

Before you start

Ensure both your Excel workbook and PowerPoint presentation are saved locally on your device to prevent broken links or synchronization delays during the update process.

Solution 1Recommended

Use Paste Special and Adjust Zoom Levels

Define the exact source range in Excel and maintain a 100% zoom level across both applications to minimize automatic resizing when pasting.

PowerPoint does not provide a native, reliable feature to permanently lock the dimensions of linked Excel objects. However, keeping zoom levels consistent and utilizing the Paste Special feature correctly can prevent most unexpected resizing issues.

Set zoom levels to 100%

Open both your Excel workbook and PowerPoint presentation. Look at the zoom slider in the bottom right corner of both applications and set it to exactly 100%.

Copy the Excel data

In your Excel file, precisely select the chart or specific table range you want to link, then press Ctrl+C to copy the defined source range.

Use Paste Special in PowerPoint

Switch to your PowerPoint slide. Navigate to the Home tab on the ribbon, click the small dropdown arrow under the Paste button, and select 'Paste Special'.

Paste as a linked object

In the dialog box, choose the 'Paste Link' option. Select 'Microsoft Excel Worksheet Object' from the list provided, and click OK to insert the linked data.

Use Paste Special and Adjust Zoom Levels

Testing New Presentations: If the linked object still resizes unexpectedly, test this workflow in a brand-new PowerPoint file to verify if the original presentation has corrupted link pathways.

Free Microsoft Office alternative

Try WPS Office for Seamless Document Linking

If you are tired of formatting glitches and resizing limitations in Microsoft Office, WPS Office provides a free, lightweight alternative. Enjoy a familiar interface, highly compatible formats, and a stable environment for linking charts and datasets across your documents.

Completely free and lightweight office suiteHighly compatible with Microsoft Excel (.xlsx) and PowerPoint (.pptx) formatsFamiliar tabbed interface for zero-learning-curve migrationStable handling of embedded objects and linked presentation data

microsoft office alternative - wps office

Frequently Asked Questions

Why do my linked Excel charts change size in PowerPoint?

When source data is updated, PowerPoint recalculates the displayed object's dimensions automatically. Because PowerPoint lacks a built-in lock for linked OLE objects, changes in Excel's layout, row heights, or data volume can trigger an unexpected resize on the slide.

Does locking the Excel worksheet prevent the linked object from resizing?

No. Locking the Excel worksheet prevents unauthorized edits to the data or structure within Excel itself, but it does not stop the linked chart or table from resizing when updated in PowerPoint.

How can I fix a linked Excel object that has already resized?

You can manually fix the size by right-clicking the object in PowerPoint, selecting 'Size and Position', and resetting its scale. If the problem persists, delete the object and re-paste it using 'Paste Special' while ensuring both programs are set to a 100% zoom level.

Can I embed the Excel data instead of linking it to avoid resizing?

Yes. Embedding the Excel object (using Paste Special > Paste, rather than Paste Link) inserts the data directly into PowerPoint. This often stops unexpected resizing, but it increases the presentation file size and removes the live connection to your original Excel workbook.

Office App Problems