How to Remove a Deleted Visio Shape Data Field from Excel Exports
Question details
The user needs to completely remove a deleted Visio Shape Data field so it no longer generates a column when exporting an organization chart to Excel.

- Product
- Microsoft Visio, Microsoft Excel
- Device & OS
- not provided
- Scenario
- Exporting a modified Visio organization chart to an Excel spreadsheet after removing custom shape data fields.
- Observed behavior
- A field previously deleted from the Define Shape Data dialog continues to appear in the exported Excel file, even though it is no longer visible in the shape's expected ShapeSheet location.
Verify that your Visio organization chart is fully saved and close any currently open Excel exports to ensure you are not viewing a cached version of the data.
Check Document, Page, and Master Shape Data
Custom fields are sometimes retained at the Master shape level or inherited from the document, causing them to persist during export even if deleted from an individual shape.
In Visio, shapes often inherit data structure from a Master shape in the Document Stencil. If the field was only deleted from instances on the page, the Master shape might still be pushing the deleted field into the export wizard.
Go to File > Options > Advanced. Scroll down to the General section and check 'Run in developer mode', then click OK.
Navigate to Developer > Document Stencil. Right-click the Master shapes used in your organization chart, select Edit Master > Edit Master Shape, and check the Define Shape Data dialog to see if the field is still there. Delete it if found.
Right-click an empty area of your drawing page and select 'Show ShapeSheet'. Scroll to the Shape Data section to ensure the deleted field is not saved at the page level.

Test with a New Organization Chart to Isolate the Issue
Creating a new file helps determine if the phantom field issue is isolated to a corrupted Visio document or if it is a broader application glitch.
Easily Manage Exported Organization Data with WPS Office
If your Visio exports contain residual columns or formatting issues, you can seamlessly open, edit, and clean up the exported data using WPS Spreadsheets. WPS Office is a powerful, lightweight suite that handles spreadsheet data effortlessly.

Frequently Asked Questions
Why does a deleted field still show up in Visio Excel exports?
The field is often cached in the document's underlying XML, retained in a Master shape within the Document Stencil, or held in the organization chart wizard's memory even after being removed from an individual shape.
How do I access the ShapeSheet in Visio?
First, enable Developer mode by going to File > Options > Advanced and checking 'Run in developer mode'. Afterward, you can right-click any shape or page and select 'Show ShapeSheet'.
Can I just manually delete the column in the exported Excel file?
Yes. If Visio persistently exports a ghost field, you can open the resulting .xlsx file, right-click the column letter containing the deleted field, and select 'Delete' to permanently remove it from your final spreadsheet.




