Can't Get NodeXL to Import Excel Workbook

[SMRFoundation]

I've asked about this problem before and still haven't seen any resolution. when I try to import Excel workbook, I get error message "There are no other open workbooks", but I do have a workbook open. I also checked Task Manager to ensure that two application of excel were indeed running.

I've had this problem now on two different computers, both running Windows Vista.

Any advice or help please?

Attachments

CountExcelProcesses.exe CountExcelProcessesSourceCode.txt

This work item was migrated from CodePlex

CodePlex work item ID: '25437' Vote count: '1'

[SMRFoundation]

[tcap479@4/30/2014] If two copies of Excel are running (which appears in Task Manager as two "Excel.exe" rows), then I would not expect the NodeXL workbook to be able to detect the other open workbook. Separate copies know nothing about each other. In other words, the behavior you're describing today is as expected.

Did I misunderstand your earlier post? I thought you said there was just one "Excel.exe" row, in which case the NodeXL workbook should have been able to detect the other workbook, but couldn't. That was a mystery to me, for which I still don't have an explanation.

In any case, maybe we can start over. What happens if you do this:

1. Open the NodeXL workbook.

2. From the File menu of the NodeXL workbook, open the second workbook.

How many "Excel.exe" rows are there in Task Manager, and can you import the second workbook into the NodeXL workbook?

-- Tony

[SMRFoundation]

[tcap479@4/30/2014] Incidentally, the way Excel manages multiple workbooks is not at all straightforward and has changed with different Excel versions, so I'm not surprised that this is causing some grief.

-- Tony

[SMRFoundation]

[PMcLeod@5/1/2014] Thank you Tony. I followed the steps, - I opened NodeExl, and from that file menu opened by workbook. I checked task manager & saw 3 applications of excel - one named NodEXl and the other two with the name of my spreadsheet. then when I tried opening the spreadsheet, I still got the same error message.

I feel like I must be doing something very basic, wrong.

Thanks again

-plm

[SMRFoundation]

[tcap479@5/1/2014] I'm sorry, Peter--I forgot to remind you to look at the "Processes" tab in Task Manager, not the "Applications" tab. Can you please repeat the steps you just did, but tell me how many times "Excel.exe" appears in Processes tab of Task Manager. You can sort the Processes tab by clicking on the "Image Name" column header, which will make it easy to spot multiple "Excel.exe" rows.

Thanks, Tony

[SMRFoundation]

[PMcLeod@5/1/2014] Hi Tony,

there is just one excel.exe in the Processes tab -Poppy

[SMRFoundation]

[tcap479@5/2/2014] With just one copy of Excel running (and your latest reply indicates that only one copy of Excel is running), NodeXL should be able to find, list, and import data from other open workbooks. I'm stumped as to why this isn't working on your computer.

The other open workbooks aren't in "Protected View", are they? That's the only thing I know of that can cause open workbooks to not appear in the list when just one copy of Excel is running.

http://office.microsoft.com/en-us/excel-help/what-is-protected-view-HA010355931.aspx

If that's not it, then I don't have a solution. I'll let you know if I can think of anything else.

-- Tony

[SMRFoundation]

[PMcLeod@5/12/2014] Thank you again. The other workbook is not in protected view. In the meantime, would you have other suggestions of how to find a solution? Are there other resources I can turn to?

Poppy

[SMRFoundation]

[tcap479@5/12/2014] I'll post a question on Microsoft's forum for Excel programmers to see if anyone there has any ideas. Please tell me which version of Excel you are using.

-- Tony

[SMRFoundation]

[PMcLeod@5/15/2014] Thank you . I'm using Excel 2010.

[SMRFoundation]

[tcap479@5/15/2014] Poppy:

I've posted the problem here:

http://social.msdn.microsoft.com/Forums/office/en-US/b0305eda-155f-4ab9-8915-87a320b86cf4/applicationworkbooks-doesnt-find-other-open-workbooks?forum=exceldev

I'll let you know if anyone else has a clue. I'm stumped myself.

-- Tony

[SMRFoundation]

[PMcLeod@5/15/2014] Thanks again

[SMRFoundation]

[tcap479@5/16/2014] The next time you have multiple workbooks open, and you try to import one of them into NodeXL but can't, please do the following:

1) Download the CountExcelProcesses.exe program from this page. You can put it anywhere--on your desktop, or in a folder of your choice.

2) Double-click the downloaded program in Windows Explorer.

A message that starts with "Excel process count" will pop up. What is the number in the message?

Thanks, Tony

[SMRFoundation]

[tcap479@5/16/2014] CodePlex isn't letting me attach the program. I'll let you know as soon as I succeed.

-- Tony

[SMRFoundation]

[UnknownUser@5/16/2014]

[SMRFoundation]

[tcap479@5/16/2014] Adding program.

[SMRFoundation]

[UnknownUser@5/16/2014]

[SMRFoundation]

[tcap479@5/16/2014] Okay, I've added the program you need.

-- Tony