Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I'm not aware of a setting that automatically creates defined names...

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='798373' date='16-Oct-2009 15:36']I'm not aware of a setting that automatically creates defined names...[/quote]


    Hi hans,

    I was more thinking it the other way around - a setting that could turn off the auto creation of defined names.
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    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.)
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='rory' post='798375' date='16-Oct-2009 15:43']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.)[/quote]

    Maybe I'm confusing this with auto creation of styles in Excel as well...??
    - is there a setting that turns this off?
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I'm not aware of a setting that would cause Excel to automatically create styles, so I don't think you can turn this on or off either.

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    No, not that I know of, if you are talking about number formats?
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='rory' post='798382' date='16-Oct-2009 15:54']No, not that I know of, if you are talking about number formats?[/quote]


    hmmmmm
    - thanks for the quick answers. Guess I'll have to sleep on that one then.
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Henrik Ryberg' post='798379' date='16-Oct-2009 13:50']Maybe I'm confusing this with auto creation of styles in Excel as well...??
    - is there a setting that turns this off?[/quote]
    The only way to have styles added to your workbook is by copying cells and/or sheets from another workbook, which have a style that differs from (or is absent from) the workbook you paste them into. There is no way to prevent that, other than by pasting values and NOT formats.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •