Hi David

If I minimise the file there is a blank folder behind it with just toollbar
across the top - no cells underneath.

Message is invalid name
Do not exceed 31 Characters, ensure does not cantain the usual characters
and ensure you did not leave the sheet un nmaed or words to that effect.

"Dave Peterson" wrote:

I would guess that the OS has nothing to do with the problem.

Now I'm not quite sure what you're doing. I don't understand what's attached to
a blank spreadsheet.

But each worksheet has to have its own unique name. There are limits to the
length of that name (31 characters) and what characters can be used in that
name. (Both "Manual" and "Manual Bonus" both work fine for me.)

Is there a chance that you have other sheets (maybe hidden) in that workbook
that use that name?

And just to be thorough, what is that standard message that you get (just type
it in your next response).



Teeny wrote:

Hi Dave

Orginal was Manual then tried Manual Bonus plus a range of other including
Joe Bloggs, Did'nt try the escape button. having slept on the problem I
wonder if it could be that at work I am using Windows 98 and at home XP?
however havent had any other problems with it.

The other thing I notice is that it seems to be attached to a blank
spreadsheet which is the one with the tool bars and I can't get rid of the
blank sheet without deleting the one I need.

It's getting more complicated each time I look at it.
Regards Teeny
"Dave Peterson" wrote:

What was the original name and what is the name you're trying to use?

And can you hit escape to just abort the change?

Some names are not legal under newer versions of excel--History is my favorite
example. It used to be legal, then xl97 (IIRC) said that only excel can use
that name.



Teeny wrote:

I have moved a worksheet to another workbook in Excel, however when I rename
it I get the message the standard message about naming sheets, when I try to
save it back to the previous name it comes up with same message and will not
let me quit Excel.

--

Dave Peterson


--

Dave Peterson