Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Can't change spreadsheet default app to Excel 97

26 Sep 2017   #1
Hoggy Dog

Windows 7 Home Premium 64 Bit
 
 
Can't change spreadsheet default app to Excel 97

I am running Excel and Word from Office 97 because the later versions don't do anything more for me than 97 does. I have tried to set the default app for *.xls spreadsheets to Excel 97, but Windows is having none of it- it wants me to purchase Office 2010 (or whatever later version that I absolutely neither need nor want) and so Office 2010 Starter is the only *.xls spreadsheet default app shown and there is no option to browse for the version of Excel.exe I actually want to set as the default app.

How can I force Windows 7, choking and gagging no doubt because Mr. Gates can't live without my $300 for absolutely nothing of any value to me, to allow me to set Excel 97 as my default *.xls app?

Alternatively, how can I set up a desktop shortcut to my most regularly-used spreadsheet that will allow me to specify the Office 97 version of Excel.exe to open it with? I have done this once on another Win 7 machine but forgotten how I dood it.

Thanks in advance for any help, and apologies for the mini-rant against Microsoft, but their hubris, arrogance and complete contempt for their customers just leave me breathless at times.


My System SpecsSystem Spec
.
26 Sep 2017   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Excel 97 is now 20 years old, so you have really had a good run with it. But like everything in life some things come to an end & we have to change. I would suggest that you move to Excel 2010 or later & I would not recommend the Starter version if you do a lot of spreadsheet work, as it does have limited ability.

This MS website might help you with using the old version with a new version of Excel.

Use Excel with earlier versions of Excel - Excel
My System SpecsSystem Spec
27 Sep 2017   #3
mrjimphelps

Linux Mint 18.2 xfce 64-bit (VMWare host) / Windows 8.1 Pro 32-bit (VMWare guest)
 
 

Quote   Quote: Originally Posted by Hoggy Dog View Post
I am running Excel and Word from Office 97 because the later versions don't do anything more for me than 97 does. I have tried to set the default app for *.xls spreadsheets to Excel 97, but Windows is having none of it- it wants me to purchase Office 2010 (or whatever later version that I absolutely neither need nor want) and so Office 2010 Starter is the only *.xls spreadsheet default app shown and there is no option to browse for the version of Excel.exe I actually want to set as the default app.

How can I force Windows 7, choking and gagging no doubt because Mr. Gates can't live without my $300 for absolutely nothing of any value to me, to allow me to set Excel 97 as my default *.xls app?
You may have tried the following; but in case you haven't...

Open File Manager. Browse to any spreadsheet with .xls as the file extension. Right-click on it, and choose "Open with". Then click the button which says "Choose program to open with this file", or something like that. Browse to where Excel 97 is located, and select excel.exe from that folder.

Quote   Quote: Originally Posted by Hoggy Dog View Post
Alternatively, how can I set up a desktop shortcut to my most regularly-used spreadsheet that will allow me to specify the Office 97 version of Excel.exe to open it with? I have done this once on another Win 7 machine but forgotten how I dood it.
This one is easy -- create a shortcut, and for the target you will put two items: Excel.exe, and the spreadsheet you want to open (put a space between the two items). For example:
"C:\Program Files\...\<excel folder>\excel.exe" "C:\...\myfavoritespreadsheet.xls"

Make sure that the "Start In" field has the path that Excel.exe is located in, but don't include "excel.exe":
"C:\Program Files\...\<excel folder>"
My System SpecsSystem Spec
.

27 Sep 2017   #4
Hoggy Dog

Windows 7 Home Premium 64 Bit
 
 

Quote   Quote: Originally Posted by mrjimphelps View Post
You may have tried the following; but in case you haven't...

Open File Manager. Browse to any spreadsheet with .xls as the file extension. Right-click on it, and choose "Open with". Then click the button which says "Choose program to open with this file", or something like that. Browse to where Excel 97 is located, and select excel.exe from that folder.
Yes, this works but isn't persistent. I have also manually set Excel.exe (97) as the default app for all files with .xls extension, but regardless of how I set my Excel 97 executable as the default app for file type .xls, Windows ignores my setting and slams it to Office 2010 Starter and then tells me that it won't run my macros unless I pay for a new version of Office. This high-handedness is part of the reason for my mini-rant- despite being told what I want it to do, Windows won't do it unless I spend money for a product I don't need. I object to this kind of marketing.

Quote   Quote: Originally Posted by mrjimphelps View Post
This one is easy -- create a shortcut, and for the target you will put two items: Excel.exe, and the spreadsheet you want to open (put a space between the two items). For example:
"C:\Program Files\...\<excel folder>\excel.exe" "C:\...\myfavoritespreadsheet.xls"

Make sure that the "Start In" field has the path that Excel.exe is located in, but don't include "excel.exe":
"C:\Program Files\...\<excel folder>"
Thanks for this- I remembered roughly the syntax (Application+some argument delineator+target file to open) but couldn't remember the delineator... is it a dash? a slash? Turns out it's a space (i.e. no delineator required.) Plus, I would not have rememberd to change the "start in" field in the Shortcut Properties dialog. Given Windows' refusal to abide by the default-app parameters I've given it (in two different ways) this method will have to do. Thanks again for your help.
My System SpecsSystem Spec
27 Sep 2017   #5
Hoggy Dog

Windows 7 Home Premium 64 Bit
 
 

Quote   Quote: Originally Posted by Ranger4 View Post
Excel 97 is now 20 years old, so you have really had a good run with it. But like everything in life some things come to an end & we have to change. I would suggest that you move to Excel 2010 or later & I would not recommend the Starter version if you do a lot of spreadsheet work, as it does have limited ability.

This MS website might help you with using the old version with a new version of Excel.

Use Excel with earlier versions of Excel - Excel
Thanks for your opinion. I don't happen to share it but I've done enough anti-Microsoft ranting. I came here for help, and got it from mrjimphelps.
My System SpecsSystem Spec
Reply

 Can't change spreadsheet default app to Excel 97




Thread Tools




Similar help and support threads
Thread Forum
printing excel 2003 spreadsheet lines
Whenever I create a new ss in Excel 2003 complete with lines, I find that when I print it the lines are all quite thick. Is there a way of adjusting the default thickness of the lines to minimum, please? Currently the lines are so thick that make data reading a little difficult or uncomfortable. I...
Microsoft Office
How to change Excel default file?
Windows 7 Home Premium, 64 bit, SP1, Office 2010. I want the default Excel file to be slightly different from the default ‒ different font and size centered vertically and different row and column sizes, nothing major. I created a new template with the name “Book.xltx” and saved it in...
Microsoft Office
Display not refreshed when scrolling excel spreadsheet
Help, my excel spreadsheets (not large) do not display properly when I scroll. Some lines repeat, other do not refresh. I minimize the window then maximize it, and it displays OK, but after when I scroll, Excel does not refresh or update the cells properly. The worst case is having a screen...
Graphic Cards
Problem with Excel Spreadsheet
I have to admit that I am not proficient in the MS Excel program. I have to fill in a form for a potential employer but the cell is too small to contain all of the information--the information that I typed in goes "off the page" into neighboring cells that are not part of the form. I can't seem to...
Microsoft Office
PDF File data into Excel Spreadsheet ?
I have WIN 7 with Excel 2003. Is it possible to transfer data contained in a .pdf file onto an Ecel spreadsheet ? If it is possible what is the procedure ?
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 15:42.
Twitter Facebook Google+