Remove Excel data link in Visio Drawing

Question

I am creating a server topology for one of our SharePoint farms and thought it would be easy to just link the Excel spreadsheet with our server information to the Visio drawing to auto-populate some things. It didn't work out that well, but the drawing is finished without it now. I cannot remove the link between the Excel spreadsheet and the Visio diagram. Whenever the drawing is opened the linked excel server list opens in a pane at the very bottom of the window. How would I eliminate the data link? Or just the spreadsheet from view when being opened?

Answer 1

Found it just to un-linking any reference to the data source, right-clicking the data source pane and choosing Remove Data Source Link.

Answer 2

I exactly don’t know how to do it, however, you can try the following steps for Visio drawing.

1. Start Visio, and then open the IDEFO diagram.
2. Click the Activity box shape that you want to configure, and then on the Window menu, click Show ShapeSheet.
3. In the Actions table, locate the Menu column.
4. In the Menu column, right-click the name of the document or page link that you want to remove, and then click Delete Row.
5. Close the ShapeSheet window.

Source: http://support.microsoft.com/kb/829224