ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why is "History" a "reserved name" while naming Excel worksheets? (https://www.excelbanter.com/excel-discussion-misc-queries/96962-why-history-reserved-name-while-naming-excel-worksheets.html)

Pradeep

Why is "History" a "reserved name" while naming Excel worksheets?
 
If I try to rename a sheet from say "Sheet 1" to "History", I get an error
message stating "History is a reserved name". Why is this so?

Dave Peterson

Why is "History" a "reserved name" while naming Excel worksheets?
 
Start a new (test) workbook and save it.

Turn on Tools|track changes
make a few changes
save the workbook

Tools|track changes|highlight changes
check the "list changes on a new sheet" box

You'll see that you get a new sheet named History.



Pradeep wrote:

If I try to rename a sheet from say "Sheet 1" to "History", I get an error
message stating "History is a reserved name". Why is this so?


--

Dave Peterson


All times are GMT +1. The time now is 09:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com