Scope of Named Range

[andrewc]

Hi,

If I select the scope as "Workbook" when creating a named range, does this mean that this name is available for reference by any other workbook?

Are there any limits on this?

Thanks!

[Izandol]

It means that the name can be used directly anywhere in that workbook. If you wish to use it from another workbook you must prefix it by the name of the workbook and an exclamation point:
=somebook.xlsx!some_name

You may also access sheet level names from other workbooks:
='[somebook.xlsx]somesheet'!some_name

[andrewc]

Thanks very much!