Reserved names in Excel

H

Hans

Does anybody know a list of predefined names in Excel ?

I know names like Print_Area and Print_Titles, but are
there more?

Regards
 
D

Dave Peterson

There's another called FilterDatabase (from data|filter|Autofilter).

And probably lots more.

Get this name manager by Jan Karel Pieterse's (with Charles Williams and
Matthew Henson). You can find it at:
NameManager.Zip from http://www.bmsltd.co.uk/mvp

Then open this addin and run it against a workbook that you've used a lot. You
might see lots of stuff that you never knew about.
 
J

Jan Karel Pieterse

Hi Hans,
Does anybody know a list of predefined names in Excel ?

I know names like Print_Area and Print_Titles, but are
there more?
Click to expand...

Certainly.

Having an advanced filter adds names like:

Sheet1!_FilterDatabase
Sheet1!Criteria

If on the same sheet you have set up custom views, You get strange
names like:

Sheet1!Z_ACEBDD96_AAB3_4874_A7A8_EDD8D679EAE5_.wvu.FilterCriteria
Sheet1!Z_ACEBDD96_AAB3_4874_A7A8_EDD8D679EAE5_.wvu.FilterData

(each view adds a set of two names like this, the gibberish seems to
relate to the name of the view)

If you add reports using the Report manager, you get names like this:

wrn.newreport.

Where newropert reflects the name of the report.

I assume there are more, but I havent investigated all of the
possibilities yet.


Regards,

Jan Karel Pieterse
Excel TA/MVP
 
J

Jim Rech

Excel's built-in names according to the Excel 97 Developer's Kit are:

Consolidate_Area
Auto_Open
Auto_Close
Extract
Database
Criteria
Print_Area
Print_Titles
Recorder
Data_Form
Auto_Activate
Auto_Deactivate
Sheet_Title
 
D

Dave Peterson

I don't think I've ever used the Report Manager, but I've seen names that look
like wrn.* in my workbooks.

(I use a very nice addin to work with names! Thanks again for that.)
 
Top