excel 2002 and excel 2007

V

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
earlier I installed windows xp excel 2002. recently I have also installed excel 2007.

now if I open any excel file it opens in excel 2007 which is default excel format, even though the was originally creaed in excel 2002.

I would like the files to open in excel 2002. When I use "open with" I have only one "microsoft excel" under recommended programmes. There is no other excel programme in thelist. Either I have to go to other programmes and browse and find out excel under office10 then it opens in excel 2002.

alternatively once I open excel 2002 subsequently all files open in excel 2002.

Is there any other easier way.

thanks
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Sort by date Sort by votes
Add a 2nd program when right clicking on the "whatever.xls" file

Rightclick Start
Explore
Tools
Folder Options
File Types
In the “registered file types” window, find the xls file type and highlight it (left click on it)
Advanced
New
Type in the action (Example: Open with 2007 or Open with 2002)
Browse
Find the executable file for the program. Highlight it by left clicking on it once.
Open
In the “Application used to perform action” window add a space and “%1”
OK
OK
Apply, OK


HTH

John
 
Upvote 0
Glad to find out that it worked for you.
I should have mentioned that the "%1" needs to have the quotation marks.
Regards
John
 
Upvote 0
You must log in or register to reply here.

Similar threads

pcc
  • Solved
Upgrade from Excel 2002 to Excel 2021 - where is my customisation?
Replies
1
Views
173
pcc
pcc
M
  • Solved
Can't open a new xlsx file with Excel 2007
Replies
3
Views
250
RoryA
RoryA
B
  • Question Question
Opening userform
Replies
4
Views
113
RoryA
RoryA
N
  • Question Question
Always open xlsx files in the already-open instance of Excel
Replies
2
Views
277
nevyoung
N
I
  • Question Question
Unable to Open or Copy Corrupted Excel Files on Network Drive
Replies
1
Views
124
Candyman8019
C

Forum statistics

Threads
1,223,234
Messages
6,170,891
Members
452,366
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top