reserved sheet name

R

rose

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

Bob Phillips

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)
 
M

Michael

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

"History" is the usual culprit

Michael
 
B

Bob Phillips

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)
 
R

rose

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.
 
D

Debra Dalgleish

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.
 
R

rose

Interesting - thank you, Debra
Debra Dalgleish said:
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.
Click to expand...
 
Top