How to Keep an Embedded Visio Object the Same Size in Excel
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.

- 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.
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.
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.
Double-click the embedded Visio object in your Excel spreadsheet to open the OLE editing view, and switch to your desired Visio page.
Click any empty cell outside of the Visio object to exit the editing mode and return to standard Excel view.
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.
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.

Use an ActiveX Image Control for Fixed Dimensions
If frequent page switching causes severe layout disruptions, export your Visio pages as static images and use an ActiveX control to guarantee a strictly fixed display area.
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.

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.




