Excel 2010 opens all spreadsheets in new instance of Excel
Posted on 2011-03-17
I just upgraded to Office 2010. Now when I open a spreadsheet any way besides using the File - Open command in Excel itself I get new instances of Excel for each spreadsheet I am opening. For example, if I go to a folder that has 3 spreadsheets, select all 3, right click Open, each spreadsheet opens in a new instance of Excel and I get the "Personal.xls is locked for editing. Open Read-Only" popup message in all but the first instance. And my macros won't work.
This occurs no matter how I open the spreadsheets, from folders as above, email attachments, doesn't matter. Very annoying. I tried a search but all I come up with is how people want to open spreadsheets in new instances of Excel. I would like to reuse the existing instance of Excel. I did find one answer from someone who used Click-to-Run installation vs installing from CDs that might be relevant but I am not sure. The installation file was downloaded to my laptop from my company.
As always, all help will be appreciated.