Office - messages #15877

Office

Messages

Prospero Blocks

Hot Searches

NASA

Chat Center

Board Folders

	MS Office - Ge... 4351 msgs in 879 dscns Latest: Nov-13
	Outlook 10259 msgs in 1962 dscns Latest: Nov-21
	Word & Word VBA 9368 msgs in 1767 dscns Latest: Nov-18
	Excel & Excel VBA 12847 msgs in 2265 dscns Latest: Nov-17
	Powerpoint 750 msgs in 196 dscns Latest: Sep-18
	Access & Acces... 5436 msgs in 1214 dscns Latest: Nov-6
	Graphic Tools 130 msgs in 34 dscns Latest: Aug-25
	Publisher 254 msgs in 47 dscns Latest: Oct-18
	Works Suite 360 msgs in 73 dscns Latest: May-26
	Money & MSTaxS... 97 msgs in 27 dscns Latest: 12/25/08
	MS Maps & Trips 78 msgs in 15 dscns Latest: Oct-23
	FrontPage 1259 msgs in 224 dscns Latest: Oct-15
	Other Office P... 325 msgs in 82 dscns Latest: Oct-29
	OneNote 144 msgs in 19 dscns Latest: Nov-11

Message Area

To list

New

Excel & Excel VBA

Excel 2003/2007: set 2003 as default?

Print Discussion

#1 of 13 Posted Oct-20 10:56 AM

From Julian Posts 476 Last Nov-17
To All [Msg # 15877.1 ]

I have Excel 2003 and 2007 installed on my computer.

How do I set Excel 2003 as default when double clicking on a file with .xls extension?
Tried "everything", but 2007 keeps on firing up.

Julian

Options

#2 of 13 Posted Oct-20 12:11 PM

From Dale G. Shields (WUGNET) Posts 310 Last Nov-21
To Julian [Msg # 15877.2 15877.1 ]

What do you mean by "everything"???

Right-click on an XLS file | Open With | Choose Program | Locate Excel 2003 | Check "Always use" and OK your way out...

Options

#3 of 13 Posted Oct-20 12:17 PM

From Julian Posts 476 Last Nov-17
To Dale G. Shields (WUGNET) [Msg # 15877.3 15877.2 ]

Dale, tried your suggestion. But Excel 2007 starts when double clicking on a file with .xls extension (and made with Excel 2003).

Options

#4 of 13 Posted Oct-20 12:26 PM

From Dale G. Shields (WUGNET) Posts 310 Last Nov-21
To Julian [Msg # 15877.4 15877.3 ]

I was afraid of that - Excel 2007 probably resets the associations to it every time it runs...

Ther may not be a way for you to accomplish what you want...

Options

#5 of 13 Posted Oct-20 1:04 PM

From Julian Posts 476 Last Nov-17
To Dale G. Shields (WUGNET) [Msg # 15877.5 15877.4 ]

Ok thanks.

Cheers,

Julian

Options

#6 of 13 Posted Oct-20 6:39 PM

From Bill Manville Posts 4150 Last Nov-21
To Julian [Msg # 15877.6 15877.5 ]

I would do
Start > Run > "%program files%\Microsoft Office\Office 11\Excel.exe" /Regserver

I don't have Excel 2003 and 2007 installed on the same machine so I can't be sure it will work.

Bill Manville
Excel MVP/TA
Oxford, England

Options

#7 of 13 Posted Oct-27 10:04 AM

From Julian Posts 476 Last Nov-17
To Bill Manville [Msg # 15877.7 15877.6 ]

Thanks Bill, will look into this.

Julian

Options

#8 of 13 Posted Oct-27 6:57 PM

From 4merCL Posts 49 Last Nov-21
To Julian [Msg # 15877.8 15877.1 ]

Julian --

I curious as to why you wish to default to Excel 2003.

IANM, Excel 2007 is backward compatible and should be able to handle your files which may have originated on the earlier version.

ADDENDUM: In addition to giving whatever extra functionality that was developed into the later version.

Best regards, 4merCL

Edited Oct-27 by 4merCL

Options

#9 of 13 Posted Oct-27 8:42 PM

From Bill Manville Posts 4150 Last Nov-21
To 4merCL [Msg # 15877.9 15877.8 ]

As a general rule, you should not develop a workbook on one version of Excel if it is to be used in an earlier version.

So, if the users of Julian's application run Excel 2003 he should develop the application on 2003.
If he developed it on 2007 then he would be likely to use features that are not available in 2003 and the application would not function correctly.

For clients who have a mixture of 2003 and 2007, I develop on 2003 and test on both 2003 and 2007.

Bill Manville
Excel MVP/TA
Oxford, England

Options

#10 of 13 Posted Oct-27 10:53 PM

From 4merCL Posts 49 Last Nov-21
To Bill Manville [Msg # 15877.10 15877.9 ]

>> So, if the users of Julian's application run Excel 2003 he should develop the application on 2003. <<

Thank you for pointing out that which had not occured to me....that Julian's work might be distributed to other users who lacked the more up to date version.

In that case, creating in the earlier format is eminently sensible.

I should say that my face is red, in that I have relevant experience in a small office that had workstations with differing versions of MS Publisher and have been faced with portability issues when opening a document prepared on one station at a different one. In mitigation, its probably been a couple of years since that was the case, as upgrades have brought the different workstations pretty much into harmony.

Best regards, 4merCL

Options

#11 of 13 Posted Oct-31 10:21 AM

From Julian Posts 476 Last Nov-17
To Bill Manville [Msg # 15877.11 15877.6 ]

Hello Bill,

What setup do you use to test on different operating systems and/or Office versions?

(Could use dual boot or virtual pc)

Cheers,

Julian

Options

#12 of 13 Posted Nov-1 3:30 AM

From Bill Manville Posts 4150 Last Nov-21
To Julian [Msg # 15877.12 15877.11 ]

I have Office 2000, 2002 and 2003 installed side-by-side on Windows XP as my primary system.
I use Office 2007 in a virtual PC (windows XP) on the same system - due to not trusting 2007 alongside the others when it first came out.

I also have a Vista laptop which currently has 2003 and 2007 side-by-side and 2010 technical preview in a Vista virtual PC.

I would tend to use VPC because that's what I am used to doing and it allows me to run both environments simultaneously (unlike dual boot).

Bill Manville
Excel MVP/TA
Oxford, England

Options