Formatting Issues

How to Keep an Embedded Visio Object the Same Size in Excel

Steve KSteve K Oct 22, 2026 870 views

Question details

The user wants to prevent an embedded Visio object from automatically resizing or repositioning itself when changing between different Visio pages within an Excel spreadsheet.

How to Keep an Embedded Visio Object the Same Size in Excel
Product
Excel
Device & OS
not provided
Scenario
Switching the active page of an embedded Visio drawing directly inside an Excel worksheet.
Observed behavior
The embedded Visio object changes its size and position on the Excel sheet after a page switch, despite the internal Visio pages having matching dimensions.
Before you start

Ensure your Excel workbook is saved before modifying Object Linking and Embedding (OLE) properties. Note that Microsoft Excel does not have a native feature to permanently lock the display area of an interactive Visio object during internal page transitions.

Solution 1Recommended

Manually Resize and Restrict Cell Movement

Since Excel dynamically alters the bounding box when the Visio page changes, you must manually correct the size and change the object properties to prevent surrounding cell edits from further displacing it.

Excel's OLE integration constantly attempts to re-render the object's viewable area based on the new active Visio page. Adjusting object properties minimizes accidental shifts caused by regular spreadsheet usage.

1
Switch Visio Page

Double-click the embedded Visio object in your Excel spreadsheet to open the OLE editing view, and switch to your desired Visio page.

2
Exit Editing Mode

Click any empty cell outside of the Visio object to exit the editing mode and return to standard Excel view.

3
Resize the Object

Click the Visio object once to select it, then click and drag the sizing handles on the corners or edges to restore your preferred dimensions.

4
Lock Object Positioning

Right-click the resized object, select 'Size and Properties', expand the 'Properties' section in the side pane, and select the 'Don't move or size with cells' option.

Manually Resize and Restrict Cell Movement
Free Microsoft Office alternative

Experience smoother spreadsheet formatting with WPS Office

Tired of dealing with frustrating object resizing and OLE embedding limitations in Microsoft Excel? Try WPS Office. It offers a lightweight, highly compatible alternative that handles complex spreadsheets and graphic objects with stability and ease.

Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Robust graphic and object management tools for consistent layout designs.Lightweight architecture ensures fast performance without freezing or lagging.Familiar ribbon interface for a seamless, zero-learning-curve transition.
QA img-9

Frequently Asked Questions

Can I lock the aspect ratio of an embedded Visio object in Excel?

Yes. Right-click the Visio object, select 'Size and Properties', expand the 'Size' menu, and check the 'Lock aspect ratio' box. This keeps the proportions consistent when scaling, though it may not fully prevent resizing during an internal page switch.

Why does the embedded object change size when the Visio pages are identical?

Excel's Object Linking and Embedding (OLE) engine dynamically recalculates the bounding box whenever the active view changes. It prioritizes the rendering of the newly activated Visio page over the previously set container dimensions in Excel.

Does pasting the Visio drawing as a picture fix the resizing issue completely?

Yes. If you copy the Visio diagram and use Excel's 'Paste Special' to paste it as a Picture (PNG or JPEG), it becomes a standard static image. It will never resize or change unexpectedly, but you will lose the ability to edit the Visio diagram directly within Excel.

Can a VBA macro automatically resize the object after I change pages?

Yes. You can write a VBA script that captures the specific width and height of your shape, allowing you to run the macro to instantly restore those predefined dimensions after switching Visio pages.