|
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
Hi,
Got a user that has a huge number of “defined names” that she isn’t aware of having created. 4,700 in all!!
She’s asking for a way to avoid this creation of names in the future. I believe that I way back have seen a comment on a setting that could be set, so that auto-creation of defined names are prevented.
Can anyone confirm the existence of the setting – and in case, would you also know where I can find it??
TIA
I think the point is that there is no auto creation of named ranges (hence the lack of setting). 
(other than built-in ones like querytable ranges, print areas etc.)
I think the point is that there is no auto creation of named ranges (hence the lack of setting).
Maybe I’m confusing this with auto creation of styles in Excel as well…??
– is there a setting that turns this off?
No, not that I know of, if you are talking about number formats?
hmmmmm 
– thanks for the quick answers. Guess I’ll have to sleep on that one then.
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Notifications
