http://www.howtogeek.com/howto.....fice-2007/

Brian (commenter)
Great article, works perfectly for word documents. However when i try and open a new .xls file from right-click new Microsoft Office Excel 97-2003 Worksheet I get the following error in Excel 2007:
The file you are trying to open, ‘test.xls’ is in a different format than specified by the file extension . . .
Then if you say yes to the error message and enter a few characters in the worksheet and then save, it throws a warning :
test.xls may contain features that are not compatible with Text (Tab Delimited). Do you want to keep the workbook in this format?
Looks like the reg hack is making the default as .csv, rather than the old .xls . . .
Any thoughts on how to get the old .xls to work?

Solution
========
1. Manual Registry Hack
[HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8\ShellNew]
"FileName"="excel4.xls"
2. Create New document(blank workbook) with excel2007 and save as "C:\Windows\ShellNew\excel4.xls(save as type : execl 97-2003 workbook)"

Posted 2 years ago
Top