L
Lynn McGuire
Can I use both Excel 2003 and Excel 2010 on the same pc ?
I have licenses for both.
Thanks,
Lynn
I have licenses for both.
Thanks,
Lynn
Yes, you can.
Install 2003 first then 2010.
Gord Dibben MS Excel MVP
And install them in separate folders - even better is on separate partitions.
And install them in separate folders - even better is on separate partitions.
The Excel version that is currently in use is the one used when
new files are opened.
That was the case with WinXP and Office2003. I'm not sure which
controls that behavior.
But recently, here or in the Answers Forum, someone indicated that
that had changed with Win7 and/or Office 2007 or 2010. They said that
new files were always opened in the __first__ instance of Excel, not
the last active one.
Any truth to that? If so, is it configurable?
I depend on files being opened in the last active instance of Excel.
That was the case with WinXP and Office2003. I'm not sure which
controls that behavior.
But recently, here or in the Answers Forum, someone indicated that
that had changed with Win7 and/or Office 2007 or 2010. They said that
new files were always opened in the __first__ instance of Excel, not
the last active one.
Any truth to that? If so, is it configurable?
I depend on files being opened in the last active instance of Excel.
I did install Excel 2003 then 2010. 2010 removed the 2003 install.
Warning: following comments apply only to WindowsXP, on other operating systems, your mileage may vary.
Note: These are the rules that I believe apply. Feel free to disagree.
1. Last version installed is the default (unless registry modified - see below)
2. Excel is closed - default version opens when an Excel file is opened.
3. Excel is open - newly opened files appear in the open Excel version.
4. Multiple Excel versions open - files open in the version calling the file.
5. Third party applications starting a new Excel instance will probably? open the default version.
To change the default version of Excel...
Close Excel
Start Menu | Run
Use the full file path to Excel, note that /regserver is outside the quote marks.
(the file paths shown are apply to my system only, use your own)
Enter this first to disassociate an excel version...
"F:\Microsoft Office 2007\Office12\Excel.exe" /unregserver
Then enter this to specify the default version...
"C:\Program Files\Microsoft Office 2003\Office11\Excel.exe" /regserver
I am using Windows 7 x64.
The default excel is excel 2010 but I installed excel 2003 last.
The /unregserver command is not working on Excel 2010. It starts
Excel 2010 instead. I created a bat file to switch to excel 2003:
rem Enter this first to disassociate an excel version...
"c:\program files (x86)\microsoft Office\Office11\Excel.exe" /unregserver
"c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
rem Then enter this to specify the default version...
"c:\program files (x86)\microsoft Office\Office11\Excel.exe" /regserver