Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple VBA Code Working in Excel 2007 but not Excel 2003 #N/A | Excel Programming | |||
Excel 2003 Match formula not working in Excel 2007 | Excel Programming | |||
Simple Excel 2003 macro not working in Excel 2007 | Excel Programming | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Pivot in excel 2003 is not working when open in excel 2007 | Excel Worksheet Functions |