View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Experience with 2003 & 2007 on same computer?

That reminds me. I have a Personal.xls and a Personal.xlsb, both open in
both versions (sic!).

--
__________________________________
HTH

Bob

"Mike H" wrote in message
...
Hi,

I recently installed E2007 (Enterprise edition) alongside E2003 and have
to
confess I'm still very dubious about any benefits of the upgrade. I
completely fail to understand why we now have the ribbon which no doubt
will
become intuative but seems to me to be change for it's own sake. We
changed
it because we can seems to be the Microsoft Philosophy.

The main problem I've encountered is my use of personal.xls. The problem
may
be caused by my lack of understanding. Initially E2007 sucessfully found
P.XLS in my office 11 installation folder and opened it sucessfully until
I
changed it with E2007. Following that every time I opened E2007 I got an
error message telling me P.XLS was corrupt. To get around the problem I
renamed it P.XLSB (which is the name E2007 uses) and my problem was cured
but
now unfortunately E2003 won't open the file. It seems to me that Microsoft
could/should have made E2007 backwards compatible with P.XLS because now I
have to put up with 2 versions which may/will become out of synch.

Apart from this the 2 versions happily reside on the same PC as long as
you
specify at installation that you are doing a new installation and not an
upgrade to E2003.

Will Win XP continue to use Excel 2003 when I click on a ".csv" and
".xls"
file?


NO. It will use e2007 and open your E2003 Excel files in compatability
mode.
You can of course still use 'Open with' and specify 2003.

Will IE6 continue to use Excel 2003, for example when I download CSV data
from an online bank account?


I download my bank details and they now go to 2007 by default but there
may
be a workaround.

Will installing Excel 2007 after 2003 impact the VBA that I access when I
press alt+F11 in Excel 2003?

Will some VBA (same or different) be available when I press alt+F11 in
Excel
2007 if I install only Excel 2007?


There are no changes (I can see) to VBA in either of the versions and I've
had no issues since the e2007 installation.

Hope this gives some insight.

Mike



"JoeU2004" wrote:

I have Office/Excel 2003 on Win XP SP3.

I would like to install (just) Excel 2007 (not Office 2007) on the same
computer (standalone laptop).

I have found a 2008 posting with a reference to an MS KB that suggests
this
is possible as long as 2007 products are installed after 2003 products,
which would obviously be the case for me.

But that is not always the complete story.

Also, I am not an expert with Win XP and Office installations. I only
get
them pre-installed on new computers that I purchase. So I want to be
sure
that if I can install just Excel 2007 on the same computer with
Office/Excel
2003, it is virtually turn-key and idiot-proof.

Can anyone share their personal experiences with doing what I want to do?

Any gotchas that I need to be aware of?

(Besides being sure that I don't use the default path when installing
Excel
2007.)

Do Excel 2003 and 2007 share Registry keys?

Will IE6 continue to use Excel 2003, for example when I download CSV data
from an online bank account?

Will Win XP continue to use Excel 2003 when I click on a ".csv" and
".xls"
file?

Will installing Excel 2007 after 2003 impact the VBA that I access when I
press alt+F11 in Excel 2003?

Will some VBA (same or different) be available when I press alt+F11 in
Excel
2007 if I install only Excel 2007?

(I don't know if VBA is integrated with Excel code, or if it is installed
separately. I know that there is a separate VB product. I don't think
I'm
asking about that.)

Will I be able to uninstall Excel 2007 without affecting Office/Excel
2003?
Are there any gotchas to be aware of?

(Please answer the last paragraph only if you have personal experience
doing
so.)

I can deal with issues involving sharing files between Excel 2007 and
Office
2003 products. That is not a problem for me. I will probably use Excel
2007 just for isolated experiments.

I am only concerned about system-wide issues that might arise -- things
that
might break or work differently after installing (just) Excel 2007.

TIA.