![]() |
Working with Both Excel 2003 and 2007
I'm in the middle of transitioning from 2003 to 2007 (half company on each
version) How do you set it so that Excel 2007 in the primary excel...ie when openning a file from it automatically defaults to 2007 insted of 2003 Can this be done? Thanks -- Helping Is always a good thing |
Working with Both Excel 2003 and 2007
Hi,
I have E2003, E2007 & E2010 on the same machine and as I've added new versions the latest version has become the 'default' version. Are you saying this isn't happening? -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "QuietMan" wrote: I'm in the middle of transitioning from 2003 to 2007 (half company on each version) How do you set it so that Excel 2007 in the primary excel...ie when openning a file from it automatically defaults to 2007 insted of 2003 Can this be done? Thanks -- Helping Is always a good thing |
Working with Both Excel 2003 and 2007
Since 2003 has decided it wants to be the default, de-register 2003 and
re-register 2007 Close Excel first and On the Windows Taskbar StartRun "C:\yourpathto2003\excel.exe" /unregserver See the space between exe and /unregserver. Then register 2007 StartRun "C:\yourpathto2007\excel.exe" /regserver This process should make Excel 2007 the default for opening files. You may not have to unregister 2003 first but I err on the side of caution<g Gord Dibben MS Excel MVP On Fri, 5 Mar 2010 12:58:49 -0800, QuietMan wrote: I'm in the middle of transitioning from 2003 to 2007 (half company on each version) How do you set it so that Excel 2007 in the primary excel...ie when openning a file from it automatically defaults to 2007 insted of 2003 Can this be done? Thanks |
Working with Both Excel 2003 and 2007
Yes that's what I'm saying...it just started to default to excel 2003. Even
if it's an excel 2007 file -- Helping Is always a good thing "Mike H" wrote: Hi, I have E2003, E2007 & E2010 on the same machine and as I've added new versions the latest version has become the 'default' version. Are you saying this isn't happening? -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "QuietMan" wrote: I'm in the middle of transitioning from 2003 to 2007 (half company on each version) How do you set it so that Excel 2007 in the primary excel...ie when openning a file from it automatically defaults to 2007 insted of 2003 Can this be done? Thanks -- Helping Is always a good thing |
Working with Both Excel 2003 and 2007
Just to be contrary, I don't usually unregister xl2003 first. I figure that
reregistering xl2007 should be enough to take over the association. I'm not sure what the heck gets reset when you unregister a version. But if my suggestion failed, I'd use Gord's! Gord Dibben wrote: Since 2003 has decided it wants to be the default, de-register 2003 and re-register 2007 Close Excel first and On the Windows Taskbar StartRun "C:\yourpathto2003\excel.exe" /unregserver See the space between exe and /unregserver. Then register 2007 StartRun "C:\yourpathto2007\excel.exe" /regserver This process should make Excel 2007 the default for opening files. You may not have to unregister 2003 first but I err on the side of caution<g Gord Dibben MS Excel MVP On Fri, 5 Mar 2010 12:58:49 -0800, QuietMan wrote: I'm in the middle of transitioning from 2003 to 2007 (half company on each version) How do you set it so that Excel 2007 in the primary excel...ie when openning a file from it automatically defaults to 2007 insted of 2003 Can this be done? Thanks -- Dave Peterson |
Working with Both Excel 2003 and 2007
Hi,
You need to unregister 2003 as default Start|Run and enter "path to e2003\excel.exe" /unregserver then start run "path to e2007\excel.exe" /regserver Note the syntax is very finnicky, see the space before / -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "QuietMan" wrote: Yes that's what I'm saying...it just started to default to excel 2003. Even if it's an excel 2007 file -- Helping Is always a good thing "Mike H" wrote: Hi, I have E2003, E2007 & E2010 on the same machine and as I've added new versions the latest version has become the 'default' version. Are you saying this isn't happening? -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "QuietMan" wrote: I'm in the middle of transitioning from 2003 to 2007 (half company on each version) How do you set it so that Excel 2007 in the primary excel...ie when openning a file from it automatically defaults to 2007 insted of 2003 Can this be done? Thanks -- Helping Is always a good thing |
All times are GMT +1. The time now is 10:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com