Mike, the old accelerator keys still work in Excel 2007 - Alt-T-I brings up
the addin dialog for example.
--
__________________________________
HTH
Bob
"Mike H" wrote in message
...
Hi,
This is disconcerting to me, even though I do not currently use
personal.xls. But it sounds like the "xlsb" and "xls" files can coexist,
with Excel 2007 using "xlsb" and Excel 2003 using "xls". Right?
Have you tried assigning Excel 2003 to "xls" and "csv" and Excel 2007 to
"xlsm" extensions in the File Options File Types control options?
Not quite. They do coexist peacefully but by default .xls files will open
with 2007 in compatibility mode. Initially using 'Open with' I did create
a
sucessful association between .xls and 2003 ( and could no doubt do the
same
with .csv) but as it is my intention to migrate to 2007 I removed this
association.
As others have noted there is nothing really going to bite you on the leg
'Providing' you preserve the original insstallation of e2003. It will cost
you more becuase you will have to purchase the full edition and not the
upgrade but beware even with the full edition you can still do an upgrade
installation if your not careful.
Turning back to the subject of the ribbon apart from a few bells and
whistles there is no difference and digging can get you back to the
standard
e2003 menus. as an example click the 'Number group' on the Home tab and
you
see various format options. Drill down by clicking 'More Number formats'
and
you get the Classic E2003 cell formating menu. View tab and macros is
exactly
the same and I'm sure there are more.
I seem to be in moan mode but I'm not completely unloving of it, I like
the
developer tab for working with VBA and the Office button is very
intuative.
The inclusion of ATP is nice
mike
"JoeU2004" wrote:
"Mike H" wrote:
I recently installed E2007 (Enterprise edition) alongside E2003
Thanks for all the information. Very useful.
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
I feel the same way, sight unseen. I completely object with the Excel
team's philosophy of not providing a "classic" alternative.
But I'm not interested in Excel 2007 for "real" usage; just for
experimenting and answering questions. So it can be a pile of sh*t for
all
I care.
The main problem I've encountered is my use of personal.xls.
This is disconcerting to me, even though I do not currently use
personal.xls. But it sounds like the "xlsb" and "xls" files can coexist,
with Excel 2007 using "xlsb" and Excel 2003 using "xls". Right?
That would suit my purposes, although I understand your concern about
having
to maintain two files.
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.
Damn! That is unacceptable. Thanks for that heads-up.
Have you tried assigning Excel 2003 to "xls" and "csv" and Excel 2007 to
"xlsm" extensions in the File Options File Types control options?
----- original message -----
"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.