Re: Need Dynamic Data source help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you don't specify, the name is workbook-specific, but this doesn't help
the chart to find the name. To make a name work***-specific, you have to
name it with the *** name as a prefix:

'My ***'!RangeName

The prefix is lost after the name is entered, but you can still see it
listed to the right of the name in the listbox in the Define Names dialog.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


<robotman@xxxxxxxxx> wrote in message
news:1178037393.417834.308440@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
That makes sense. I thought when you define a new name it applies to
the whole workbook? That's why you need to specify the sheetname in
the name formula.

Are names ***-specific so whatever *** is active when you define
the name is the *** that the name will be associated with?

Thanks.

John




.

Quantcast