Need to run Excel 2003 and 2007 on same machine and . . .

[froggygremblin]

Excel 2003 needs to be the default version.

My issue is our company has adopted Office 2007 but we have one application
(ACT2006) that exports a report to Excel. Act2006 only works with Excel 2003
or earlier. If Excel 20007 is present on the machine the Export to Excel
button is greyed out.

Anyone got a way around this? I saw some posts on an ealier thread that
running multiple versions of office is possible but that they had to be
installed oldest version first. which leaves 2007 as teh default. Can you
edit the registry in some magical way to overcome this?

Thanks for any suggestions

 

[Bob Phillips]

You can install 2007 and 2003 but I am not aware of having to install them
in any order (I forget how I did mine, it was back in November). But I have
found that there is no rhyme nor reason that I can see as to which is
defaulted to. I have .xls files open in 2007 and .xlsm files open in 2003.
The only thing (I think) that I may have noticed is that it seems to be the
last version I accessed.

Have you looked at maybe upgrading to ACT!2010?


Bob

 

[Gord Dibben]

Since 2007 has decided it wants to be the default, de-register 2007 and
re-register 2003

Close Excel first and On the Windows Taskbar

Start>Run "C:\yourpathto2007\excel.exe" /unregserver

See the space between exe and /unregserver.

Then register 2003

Start>Run "C:\yourpathto2003\excel.exe" /regserver

This process should make Excel 2003 the default for opening files.

You may not have to unregister 2007 first but I err on the side of
caution<g>


Gord Dibben MS Excel MVP

 

[froggygremblin]

Many thanks! That sounds like its exactly the solution I'm looking for.