"bj" wrote:
you need to add the file name
for example if you are in source data-series
and you want a named range (xy) in Workbook named test.xls
enter the values as
=test.xls!xy
"ArthurJ" wrote:
I would like to use rangenames to specify the data sources for a chart, but
Excel does not seem to like this. I have tried entering the rangename in the
following formats:
rangename
=rangename
={rangename]
={"rangename"}
... and various other formats.
Surely there is a way to do this ....?
Art
|