Object reference not set to an instance of an object

Jan 27 at 12:42 PM
Hello, something strange happening here.

Yesterday I was working normally, and at the end of the day I saved everything and rebooted the computer (system asked me to do it after some Windows 7 automatic updates).

This morning, I turned on the computer. NodeXL made an automatic version update and Excel open my database, without NodeXL tab. An Excel cryptographic error message popped up, saying: “Object reference not set to an instance of an object”. Uh????

Yes, I can open a new instance of NodeXL tab (through Start/All Programs/NodeXL Excel template), but when I try to open yesterday “File/Open/Recent Workbooks” it open the Excel Database ...without the NodeXL tab.

What I did wrong last night, when I saved everything? My data is here, in front of me, but no NodeXL.

In Advance thank you
Coordinator
Jan 27 at 1:30 PM
Edited Jan 27 at 1:31 PM
Hello,

this was a bug with the previous version of NodeXL and the latest version fixed it, but unfortunately the workbooks downloaded with the old version have this error. To recover a workbook downloaded and saved with the old version please follow these steps:
  1. Open the workbook and you should see the error message you described, Click "OK"
  2. Right-click the "Edges" sheet and click "Unhide..."
  3. In the dialog box that appears, select "Time Series Edges" and Click "OK"
  4. This command will show a new sheet called "Time Series Edges", please move this sheet at the end of the sheet list
  5. Hide "Time Series Edges" sheet by right-clicking it and selecting "Hide"
  6. Save the workbook and reopen it
  7. Now the workbook should open correctly
We are sorry for any inconvenience caused!

Regards,
Arber
Jan 27 at 2:58 PM
Arber,

Thank you for your quick answer.

Unfortunately it didn't worked. Items 1 and 2 OK. Item 3, In the Unhide dialog box appears: Do Not Delete and Misc.

I did what suggested (...please move this sheet at the end of the sheet list ) to "Do Not delete" sheet, moved it to end of the sheet list. Hide, save and tried again. Same result :-(

Then I did the same to Misc, with same result.

Finally I did to both, Misc and Do Not Delete. Nothing worked.

Any other suggestion, to save my yesterday's 8 hour work?

Thanks in advance.

Daniel





This worksheet is no longer used but is retained to allow older versions of NodeXL to open workbooks created with NodeXL version 1.0.1.96 or later.
Coordinator
Jan 27 at 5:26 PM
Hello,

can you please send me the problematic workbook so I can take a look? Send it to arberceni@smrfoundation.org

Regards,
Arber
Coordinator
Jan 28 at 2:46 PM
Hello Daniel,

I was able to successfully open your workbook. I noticed there is a sheet called "Sheet1". Did you add that? Please try moving it at the end of the sheets list and if this doesn't work, please try moving the license at a folder which does not contain OS-specific data (you can use Documents, Downloads, Desktop, D: drive).

Regards,
Arber
Feb 1 at 7:24 AM
Arber, I have the same problem. I installed NodeXL Pro and it worked fine. Then it started crushing with the same message. I uninstalled, reinstalled again, but it doesn't even get to the point where the license file is asked.
I do not have any workbook saved. I just cannot work.

Thank you

lorenzo
Coordinator
Feb 1 at 12:24 PM
Hi Lorenzo,

I replied to the other thread opened by you https://nodexl.codeplex.com/workitem/65070

Regards,
Arber
Mar 5 at 6:35 PM
Hello guys. I'm having a similar issue regarding object reference. Could you help me?

System.NullReferenceException: Referência de objeto não definida para uma instância de um objeto.
em Smrf.NodeXL.ExcelTemplate.ThisWorkbook.ThisWorkbook_Startup(Object sender, EventArgs e)
em Microsoft.Office.Tools.Excel.WorkbookImpl.OnStartup()
em Microsoft.Office.Tools.Excel.WorkbookImpl.WorkbookExtensionImpl.Microsoft.Office.Tools.EntryPoint.OnStartup()
em Microsoft.Office.Tools.Excel.WorkbookBase.OnStartup()
em Smrf.NodeXL.ExcelTemplate.ThisWorkbook.FinishInitialization()
em Microsoft.Office.Tools.Excel.WorkbookBase.Microsoft.Office.Tools.EntryPoint.FinishInitialization()
em Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.ExecutePhase(ExecutionPhases executionPhases)
em Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.Microsoft.VisualStudio.Tools.Office.Runtime.Interop.IExecuteCustomization2.ExecuteEntryPoints()


************** Assemblies Carregados **************
mscorlib
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1063.1 built by: NETFXREL3STAGE

Base de Código: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

System
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1038.0 built by: NETFXREL2

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

Microsoft.VisualStudio.Tools.Office.Runtime
Versão do Assembly: 10.0.0.0
Versão do Win32: 10.0.50903.0

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.dll

Microsoft.Office.Tools
Versão do Assembly: 10.0.0.0
Versão do Win32: 10.0.50903.0

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.dll

Microsoft.VisualStudio.Tools.Applications.Runtime
Versão do Assembly: 10.0.0.0
Versão do Win32: 10.0.50903.0

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.dll

System.Core
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1038.0 built by: NETFXREL2

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

Microsoft.Office.Tools.Excel.Implementation
Versão do Assembly: 10.0.0.0
Versão do Win32: 10.0.50903.0

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Excel.Implementation/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Excel.Implementation.dll

Microsoft.Office.Tools.Common.Implementation
Versão do Assembly: 10.0.0.0
Versão do Win32: 10.0.50903.0

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Common.Implementation/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.Implementation.dll

Microsoft.Office.Tools.Excel
Versão do Assembly: 10.0.0.0
Versão do Win32: 10.0.50903.0

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Excel/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Excel.dll

Microsoft.VisualStudio.Tools.Applications.ServerDocument
Versão do Assembly: 10.0.0.0
Versão do Win32: 10.0.50903.0

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.dll

System.Windows.Forms
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1038.0 built by: NETFXREL2

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System.Drawing
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1068.2 built by: NETFXREL3STAGE

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

Smrf.NodeXL.ExcelTemplate
Versão do Assembly: 1.0.1.350
Versão do Win32: 1.0.1.350

Base de Código: file:///C:/Users/augus/AppData/Local/Apps/2.0/MCHT1PR3.44Z/Y7ZPK3VV.DCY/smrf..vsto_91729be392989ec5_0001.0000_9f442d46d2bc93ea/Smrf.NodeXL.ExcelTemplate.DLL

Microsoft.Office.Tools.Excel.v4.0.Utilities
Versão do Assembly: 10.0.0.0
Versão do Win32: 10.0.30319.1

Base de Código: file:///C:/Users/augus/AppData/Local/Apps/2.0/MCHT1PR3.44Z/Y7ZPK3VV.DCY/smrf..vsto_91729be392989ec5_0001.0000_9f442d46d2bc93ea/Microsoft.Office.Tools.Excel.v4.0.Utilities.DLL

System.Xml
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1064.2 built by: NETFXREL3STAGE

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.Office.Tools.Common
Versão do Assembly: 10.0.0.0
Versão do Win32: 10.0.50903.0

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Common/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.dll

Microsoft.Office.Tools.Common.v4.0.Utilities
Versão do Assembly: 10.0.0.0
Versão do Win32: 10.0.30319.1

Base de Código: file:///C:/Users/augus/AppData/Local/Apps/2.0/MCHT1PR3.44Z/Y7ZPK3VV.DCY/smrf..vsto_91729be392989ec5_0001.0000_9f442d46d2bc93ea/Microsoft.Office.Tools.Common.v4.0.Utilities.DLL

Smrf.NodeXL.ApplicationUtil
Versão do Assembly: 1.0.1.350
Versão do Win32: 1.0.1.350

Base de Código: file:///C:/Users/augus/AppData/Local/Apps/2.0/MCHT1PR3.44Z/Y7ZPK3VV.DCY/smrf..vsto_91729be392989ec5_0001.0000_9f442d46d2bc93ea/Smrf.NodeXL.ApplicationUtil.DLL

Smrf.NodeXL.Core
Versão do Assembly: 1.0.1.350
Versão do Win32: 1.0.1.350

Base de Código: file:///C:/Users/augus/AppData/Local/Apps/2.0/MCHT1PR3.44Z/Y7ZPK3VV.DCY/smrf..vsto_91729be392989ec5_0001.0000_9f442d46d2bc93ea/Smrf.NodeXL.Core.DLL

Smrf.NodeXL.Visualization.Wpf
Versão do Assembly: 1.0.1.350
Versão do Win32: 1.0.1.350

Base de Código: file:///C:/Users/augus/AppData/Local/Apps/2.0/MCHT1PR3.44Z/Y7ZPK3VV.DCY/smrf..vsto_91729be392989ec5_0001.0000_9f442d46d2bc93ea/Smrf.NodeXL.Visualization.Wpf.DLL

System.ServiceModel
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1038.0 built by: NETFXREL2

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll

System.Runtime.Serialization
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1038.0 built by: NETFXREL2

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll

SMDiagnostics
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1038.0 built by: NETFXREL2

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll

System.ServiceModel.Internals
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1038.0 built by: NETFXREL2

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll

System.Configuration
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1038.0 built by: NETFXREL2

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

System.Transactions
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1038.0 built by: NETFXREL2

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll

System.Security
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1038.0 built by: NETFXREL2

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Security/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Security.dll

System.Management
Versão do Assembly: 4.0.0.0
Versão do Win32: 4.6.1038.0 built by: NETFXREL2

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Management/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Management.dll

Microsoft.VisualStudio.Tools.Applications.ServerDocument.resources
Versão do Assembly: 10.0.0.0
Versão do Win32: 10.0.50903.0

Base de Código: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.resources/v4.0_10.0.0.0_pt-BR_b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.resources.dll

Coordinator
Mar 6 at 10:22 PM
Hello,

please try moving your license at some folder which does not contain OS-sensitive data (you can use Documents, Downloads, D: drive etc).

Regards,
Arber
Mar 8 at 7:07 PM
Hello arber. I tied to do what you said it it didn't work. The license was already inside a folder (Documents folder) which didn't have any OS files or whatsoever. I moved it to the Downloads folder, but even so it didn't work, and the error was the same.
What can I do?
Thank you very much.
Augusto.
Coordinator
Mar 10 at 12:27 PM
Hello Augusto,

can you please check if the license file is "Read-only" (right click->Properties)? If that is the case please uncheck the "Read-only" checkbox and click "OK".

Regards,
Arber
Mar 11 at 1:36 AM
Hello arber. I've just checked it and it's already unchecked. I was using NodeXL normally before formatting my laptop, since windows was too slow. After the procedure and the reinstallation, it started to show the concerning issue.

Regards,
Augusto.

2016-03-10 9:27 GMT-03:00 arber <[email removed]>:

From: arber

Hello Augusto,

can you please check if the license file is "Read-only" (right click->Properties)? If that is the case please uncheck the "Read-only" checkbox and click "OK".

Regards,
Arber

Read the full discussion online.

To add a post to this discussion, reply to this email ([email removed])

To start a new discussion for this project, email [email removed]

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com


Coordinator
Mar 11 at 2:16 PM
Hello Augusto,

I have sent you an e-mail.

Regards,
Arber