error the following control is missing: Sheet4 issue cannot open saved file

Mar 24, 2011 at 11:44 PM

Good Afternoon,

I have an issue trying to open a saved NodeXLGraph.xltx file created by a user. I am running on a Windows XP SP3 computer with MS Office 2007 SP2. Just to let every one know I am technician and this is the fist time I have been asked to work on the NodeXL file or issue.

What I can do:

- open the NodeXLGraph.xltx I can see the NodeXL Ribbon when run from the start, programs, Microsoft NodeXL, NodeXL Excel Template. I am able to save a copy of the template with out change and reopen it.

What I have read posted here was 2 articles first http://nodexl.codeplex.com/workitem/20066 in regards to a similar issue not being able to open a saved file, and I see that was able to be resolved by following http://nodexl.codeplex.com/discussions/72820?ProjectName=nodexl.

What I tried:

- From article http://nodexl.codeplex.com/discussions/72820? which out lines MS Excel should have the trusted folder listed where the file is will be located. I added the C:\Program Files\Microsoft Research\Microsoft NodeXL Excel Template to the trusted locations. Opened the template then did a file, open and pointed to the saved file. The file fails to open with a part of the error message I will list the rest at the bottom of the page. Error message "This document might not function as expected because the following control is missing: Sheet4. Data that relies on this control will not be automatically displayed or updated, and other custom functionality will not be available. Contact your administrator or the author of this document for further assistance."

- I also moved the XLTX to a folder already listed under the MS Excel trusted location no luck.

- Next I removed and re-installed Microsoft VisualStudio Tools Office same issue.

Thank You for you assistance.

Please see full Detail message below:

This document might not function as expected because the following control is missing: Sheet4. Data that relies on this control will not be automatically displayed or updated, and other custom functionality will not be available. Contact your administrator or the author of this document for further assistance.

 

************** Exception Text **************

Microsoft.VisualStudio.Tools.Applications.Runtime.ControlNotFoundException: This document might not function as expected because the following control is missing: Sheet4. Data that relies on this control will not be automatically displayed or updated, and other custom functionality will not be available. Contact your administrator or the author of this document for further assistance. ---> System.Runtime.InteropServices.COMException (0x800A03EC): Programmatic access to the Microsoft Office Visual Basic for Applications project system could not be enabled. If Microsoft Office Word or Microsoft Office Excel is running, it can prevent programmatic access from being enabled. Exit Word or Excel before opening or creating your project.

   at Microsoft.VisualStudio.Tools.Office.Runtime.Interop.IHostItemProvider.GetHostObject(String primaryType, String primaryCookie, IntPtr& hostObject)

   at Microsoft.VisualStudio.Tools.Office.Internal.HostItemProviderExtendedContractAdapter.GetHostObject(String objectType, String cookie)

   at Microsoft.Office.Tools.Excel.Adapter.ExcelHostItemProvider.GetWorksheet(String objectType, String cookie)

   at Microsoft.Office.Tools.Excel.Adapter.ExcelHostItemProvider.GetHostObject(String objectType, String cookie)

   at Microsoft.VisualStudio.Tools.Office.Internal.HostItemProviderExtendedContractAdapter.Microsoft.VisualStudio.Tools.Applications.Contract.IHostItemProviderContract2.GetHostObject(String objectType, String cookie)

   at Microsoft.VisualStudio.Tools.Office.Internal.IOfficeHostItemProviderProxy.GetHostObject(Type primaryType, String primaryCookie)

   at Microsoft.VisualStudio.Tools.Applications.Internal.IHostItemProviderProxy.Microsoft.VisualStudio.Tools.Applications.Runtime.IHostItemProvider.GetHostObject(Type primaryType, String primaryCookie)

   at Microsoft.VisualStudio.Tools.Office.RemoteComponent.GetHostItem[T](Type type, String cookie)

   at Microsoft.Office.Tools.Excel.Worksheet.GetObjects()

   --- End of inner exception stack trace ---

   at Microsoft.Office.Tools.Excel.Worksheet.GetObjects()

   at Microsoft.Office.Tools.Excel.Worksheet.get_Proxy()

   at Microsoft.Office.Tools.Excel.Worksheet.get_Controls()

   at Microsoft.Office.Tools.Excel.NamedRange.Init()

   at Microsoft.Office.Tools.Excel.NamedRange..ctor(IHostItemProviderExtended hostItemProvider, IServiceProvider serviceProvider, String cookie, Object container, String identifier)

   at Microsoft.NodeXL.ExcelTemplate.Sheet4.InitializeControls()

   at Microsoft.NodeXL.ExcelTemplate.Sheet4.Initialize()

   at Microsoft.VisualStudio.Tools.Office.EntryPointComponentBase.Microsoft.VisualStudio.Tools.Applications.Runtime.IEntryPoint.Initialize(IServiceProvider hostContext)

   at Microsoft.VisualStudio.Tools.Applications.AddInAdapter.ExecutePhase(ExecutionPhases executionPhases)

   at Microsoft.VisualStudio.Tools.Office.Internal.OfficeAddInAdapter.InitializeEntryPointsHelper()

************** Loaded Assemblies **************

mscorlib

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

   CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

----------------------------------------

Microsoft.VisualStudio.Tools.Office.Runtime.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.v9.0.dll

----------------------------------------

System

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Core

   Assembly Version: 3.5.0.0

   Win32 Version: 3.5.30729.1 built by: SP

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll

----------------------------------------

System.AddIn

   Assembly Version: 3.5.0.0

   Win32 Version: 3.5.30729.1 built by: SP

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.AddIn/3.5.0.0__b77a5c561934e089/System.AddIn.dll

----------------------------------------

System.Configuration

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------

System.Xml

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

System.AddIn.Contract

   Assembly Version: 2.0.0.0

   Win32 Version: 3.5.30729.1 built by: SP

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.AddIn.Contract/2.0.0.0__b03f5f7f11d50a3a/System.AddIn.Contract.dll

----------------------------------------

Microsoft.VisualStudio.Tools.Applications.Hosting.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Hosting.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Hosting.v9.0.dll

----------------------------------------

System.Deployment

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll

----------------------------------------

System.Security

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.3613 (GDR.050727-3600)

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.dll

----------------------------------------

Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0.dll

----------------------------------------

Microsoft.VisualStudio.Tools.Applications.ServerDocument.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v9.0.dll

----------------------------------------

System.Windows.Forms

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

----------------------------------------

System.Drawing

   Assembly Version: 2.0.0.0

   Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

Microsoft.VisualStudio.Tools.Office.Contract.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Contract.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Contract.v9.0.dll

----------------------------------------

Microsoft.Office.Tools.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Office.Tools.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.v9.0.dll

----------------------------------------

Microsoft.NodeXL.ExcelTemplate

   Assembly Version: 1.0.1.159

   Win32 Version: 1.0.1.159

   CodeBase: file:///C:/Documents%20and%20Settings/SteinR/Local%20Settings/Apps/2.0/2GYZTB77.M81/93GMD3HC.H7P/micr..vsto_89bba316835ec8ea_0001.0000_9dcba76bc7723332/Microsoft.NodeXL.ExcelTemplate.DLL

----------------------------------------

Microsoft.VisualStudio.Tools.Office.Excel.AddInAdapter.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Excel.AddInAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Excel.AddInAdapter.v9.0.dll

----------------------------------------

Microsoft.Office.Tools.Excel.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Office.Tools.Excel.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Excel.v9.0.dll

----------------------------------------

Microsoft.Office.Interop.Excel

   Assembly Version: 12.0.0.0

   Win32 Version: 12.0.6425.1000

   CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.Office.Interop.Excel/12.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll

----------------------------------------

Microsoft.VisualStudio.Tools.Office.AddInAdapter.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.AddInAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.AddInAdapter.v9.0.dll

----------------------------------------

Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0.dll

----------------------------------------

Microsoft.VisualStudio.Tools.Applications.Contract.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.21022.123

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Contract.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Contract.v9.0.dll

----------------------------------------

Anonymously Hosted DynamicMethods Assembly

   Assembly Version: 0.0.0.0

   Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

   CodeBase: file:///C:/WINDOWS/assembly/GAC_32/mscorlib/2.0.0.0__b77a5c561934e089/mscorlib.dll

----------------------------------------

Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0.dll

----------------------------------------

Microsoft.VisualStudio.Tools.Office.Excel.HostAdapter.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Excel.HostAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Excel.HostAdapter.v9.0.dll

----------------------------------------

Microsoft.VisualStudio.Tools.Office.HostAdapter.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.HostAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.HostAdapter.v9.0.dll

----------------------------------------

Microsoft.Office.Tools.Common.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Office.Tools.Common.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.v9.0.dll

----------------------------------------

Microsoft.VisualStudio.Tools.Office.Excel.AddInProxy.v9.0

   Assembly Version: 9.0.0.0

   Win32 Version: 9.0.30729.1

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Excel.AddInProxy.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Excel.AddInProxy.v9.0.dll

----------------------------------------

office

   Assembly Version: 12.0.0.0

   Win32 Version: 12.0.6425.1000

   CodeBase: file:///C:/WINDOWS/assembly/GAC/office/12.0.0.0__71e9bce111e9429c/office.dll

----------------------------------------

Microsoft.NodeXL.Core

   Assembly Version: 1.0.1.159

   Win32 Version: 1.0.1.159

   CodeBase: file:///C:/Documents%20and%20Settings/SteinR/Local%20Settings/Apps/2.0/2GYZTB77.M81/93GMD3HC.H7P/micr..vsto_89bba316835ec8ea_0001.0000_9dcba76bc7723332/Microsoft.NodeXL.Core.DLL

----------------------------------------

Microsoft.NodeXL.ApplicationUtil

   Assembly Version: 1.0.1.159

   Win32 Version: 1.0.1.159

   CodeBase: file:///C:/Documents%20and%20Settings/SteinR/Local%20Settings/Apps/2.0/2GYZTB77.M81/93GMD3HC.H7P/micr..vsto_89bba316835ec8ea_0001.0000_9dcba76bc7723332/Microsoft.NodeXL.ApplicationUtil.DLL

----------------------------------------

Microsoft.NodeXL.Visualization.Wpf

   Assembly Version: 1.0.1.159

   Win32 Version: 1.0.1.159

   CodeBase: file:///C:/Documents%20and%20Settings/SteinR/Local%20Settings/Apps/2.0/2GYZTB77.M81/93GMD3HC.H7P/micr..vsto_89bba316835ec8ea_0001.0000_9dcba76bc7723332/Microsoft.NodeXL.Visualization.Wpf.DLL

----------------------------------------

Microsoft.NodeXL.Util

   Assembly Version: 1.0.1.159

   Win32 Version: 1.0.1.159

   CodeBase: file:///C:/Documents%20and%20Settings/SteinR/Local%20Settings/Apps/2.0/2GYZTB77.M81/93GMD3HC.H7P/micr..vsto_89bba316835ec8ea_0001.0000_9dcba76bc7723332/Microsoft.NodeXL.Util.DLL

----------------------------------------

PresentationCore

   Assembly Version: 3.0.0.0

   Win32 Version: 3.0.6920.1427 built by: SP

   CodeBase: file:///C:/WINDOWS/assembly/GAC_32/PresentationCore/3.0.0.0__31bf3856ad364e35/PresentationCore.dll

----------------------------------------

WindowsBase

   Assembly Version: 3.0.0.0

   Win32 Version: 3.0.6920.1427 built by: SP

   CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/WindowsBase/3.0.0.0__31bf3856ad364e35/WindowsBase.dll

----------------------------------------

Microsoft.Research.WinFormsControls

   Assembly Version: 1.0.1.6

   Win32 Version: 1.0.1.6

   CodeBase: file:///C:/Documents%20and%20Settings/SteinR/Local%20Settings/Apps/2.0/2GYZTB77.M81/93GMD3HC.H7P/micr..vsto_89bba316835ec8ea_0001.0000_9dcba76bc7723332/Microsoft.Research.WinFormsControls.DLL

----------------------------------------

Microsoft.NodeXL.Algorithms

   Assembly Version: 1.0.1.159

   Win32 Version: 1.0.1.159

   CodeBase: file:///C:/Documents%20and%20Settings/SteinR/Local%20Settings/Apps/2.0/2GYZTB77.M81/93GMD3HC.H7P/micr..vsto_89bba316835ec8ea_0001.0000_9dcba76bc7723332/Microsoft.NodeXL.Algorithms.DLL

----------------------------------------

 hank Y

Mar 25, 2011 at 5:37 AM

The problem you are seeing is not related to any of the NodeXL posts you referred to.  It is caused by a missing or renamed worksheet.

Right-click the worksheet tabs at the lower-left corner of the Excel window ("Edges," "Vertices," "Groups," and so on) and select "Unhide" from the right-click menu.  There should be two entries in the "Unhide sheet" list: "Do Not Delete" and "Misc."  What do you see in the "Unhide sheet" list?

-- Tony

Apr 19, 2011 at 5:11 PM

I have a similar problem, I tried to check what do I have on "Unhide", and I got exactly what you have described "Do Not Delete" and "Misc." 

suggestions?

Apr 19, 2011 at 5:21 PM

Please post the troublesome workbook and I'll take a look at it.  You can't post attachments using the Discussion tab on CodePlex, but you can using the Issue Tracker tab at http://nodexl.codeplex.com/workitem/list/basic.  Create a new issue and include the workbook as an attachment.  You don't need to explain anything; I'll know what it is.

-- Tony

Apr 19, 2011 at 6:03 PM

posted as Issue 20547

Apr 19, 2011 at 9:11 PM
Edited Apr 19, 2011 at 9:12 PM

Got it, thanks.

The workbook opens without a problem on my computer.  However, I saw this happen to someone else a while back, and the cause turned out to be an oddity in his version of Excel that resulted in it being picky about the order of the worksheets within the workbook.

Try this:

1. Open the workbook.  Ignore the error message that you get.

2. Unhide the hidden worksheets.

3. Move the "Misc" worksheet to the immediate right of the Overall Metrics worksheet.  You can move a worksheet by dragging its tab.  The worksheet order should then be Edges, Vertices, Do Not Delete, Groups, Group Vertices, Overall Metrics, Misc, lookup, Groups LU, and the rest of your own worksheets.

4. Save the workbook.

5. Open the workbook again.  Did that fix the problem?

-- Tony

Apr 20, 2011 at 7:15 AM

Solved !

Do I need to do anything to avoid it from happening?

Tx

Apr 20, 2011 at 3:17 PM

You'll want to add your own worksheets after NodeXL's own worksheets.  On my computer, if I click Excel's "Insert Worksheet" tab to the right of NodeXL's Overall Metrics tab, this happens automatically; the new worksheet gets inserted after all existing worksheets.  On your computer, don't right-click an existing tab and select Insert from the right-click menu.  That will insert the new worksheet before NodeXL's own worksheets.

Do you know whether your computer is kept up to date with Microsoft updates, including those for Office?  I'm trying to figure out why this bug doesn't occur on any of my computers but has happened to at least two people so far.  I can insert a new worksheet anywhere without a problem, which is the way things are supposed to work.

Thanks,
    Tony