I have been using this trick in Data Validation as suggested by Debra in her
article "Data Validation -- Use a List from Another Workbook" bit it never
occurred to me to use the same like you have suggested.

"Gary''s Student" wrote:

A very good question!!

Insert Name Define joesplace
refers to:
='C:\Temp\[first.xls]Sheet1'!$A$1

I was very surprised that this works!
--
Gary''s Student - gsnu200848


"quirkyjoe" wrote:

I am familiar with EXCEL's "named ranges" ability to name a cell
something more meaningful like "sales" rather than let EXCEL default
it to "A1".

I am working on multiple woorkbooks with multiple tabs in each. When
I use a cell from one workbook in a calcualtion in another workbook I
get something like this:

F4*K4*N4*'C:\Documents\Project A\[Workbook A.xls]'SalesTab'!$A$2

My question is, can I rename all the gooble-de-gook 'C:\Documents
\Project A\[Workbook A.xls]'SalesTab' into something more meaningful
so my calculations in the cells do not get all cluttered with path and
woorkbook file names? Or at a minium shorten the gooble-de-gook
somehow?

Thanks.