reserved sheet name
 

When I try to rename the worksheet, I get the error "reserved name".
Anyone familiar w/this message? How do I release the reserve?

What name are you using? It sounds like you are trying to call it something
Excel reserves for itself, like ..., well I can't think of an example.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"rose" wrote in message
...
When I try to rename the worksheet, I get the error "reserved name".
Anyone familiar w/this message? How do I release the reserve?

Hi Bob
I know how you feel.....took me a couple of minutes too !!

"History" is the usual culprit

Michael

"Bob Phillips" wrote:

What name are you using? It sounds like you are trying to call it something
Excel reserves for itself, like ..., well I can't think of an example.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"rose" wrote in message
...
When I try to rename the worksheet, I get the error "reserved name".
Anyone familiar w/this message? How do I release the reserve?

Hi Michael,

Thank you. I tried so many names, function names, object names, I even tried
=SUM thinking it will hate that, and got nowhere.

But History does indeed fail.

Regards

Bob

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michael" wrote in message
...
Hi Bob
I know how you feel.....took me a couple of minutes too !!

"History" is the usual culprit

Michael

"Bob Phillips" wrote:

What name are you using? It sounds like you are trying to call it
something
Excel reserves for itself, like ..., well I can't think of an example.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"rose" wrote in message
...
When I try to rename the worksheet, I get the error "reserved name".
Anyone familiar w/this message? How do I release the reserve?

Right! It is "history" that I'm trying to use!
Hmmm - curious. I guess it will remain a mystery unless Mr Gates can
enlighten us.

"rose" wrote:

When I try to rename the worksheet, I get the error "reserved name".
Anyone familiar w/this message? How do I release the reserve?

When a workbook is shared, you can keep track of changes to that
workbook. The changes are recorded on a sheet named "History".

So, Excel won't let you create a sheet named "History", to avoid any
potential conflicts.

rose wrote:
Right! It is "history" that I'm trying to use!
Hmmm - curious. I guess it will remain a mystery unless Mr Gates can
enlighten us.

"rose" wrote:


When I try to rename the worksheet, I get the error "reserved name".
Anyone familiar w/this message? How do I release the reserve?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Interesting - thank you, Debra
"Debra Dalgleish" wrote:

When a workbook is shared, you can keep track of changes to that
workbook. The changes are recorded on a sheet named "History".

So, Excel won't let you create a sheet named "History", to avoid any
potential conflicts.

rose wrote:
Right! It is "history" that I'm trying to use!
Hmmm - curious. I guess it will remain a mystery unless Mr Gates can
enlighten us.

"rose" wrote:


When I try to rename the worksheet, I get the error "reserved name".
Anyone familiar w/this message? How do I release the reserve?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html