Creating old xls worksheets.


G

Guest

Hi.
I don't know if this is an excel or a windows explorer problem.
I want to alter the windows explorer "right click - new" menu so I can right
click e.g. an empty area of my desktop, select new and from there create an
old format xls document.
I have altered the registry key:
HKCR\.xls\Excel.Sheet.8\ShellNew\Filename
so I have the option to create a "Microsoft Excel 97-2003 worksheet" in the
right click menu. The problem is that when I double click my newly created
xls file I get an error message from excel telling me: "The file you are
trying to open <filename> is in a different format..."

I am running all this on a w2k3 terminal server so I can not use TweakUI
from the Powertoys for Windows XP.

Thanks in advance...
 
Ad

Advertisements

G

Guest

It would probably be better to set the default file type in Excel so that
everytime you save a file, it would be in the format that you desire. Goto
Tools>Options>Transition then select 'Save Excel files as:' and set that to
"Microsoft Excel 97-2003 worksheet"
 
Ad

Advertisements

G

Guest

That is already covered using a GPO and it works. If a user creates a new
worksheet from within Excel and saves it using default settings it is saved
as a xls file.
The problem is that there are to many users using the "right click" way to
create new worksheets.

Thanks anyway...

"bigwheel" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top