No, I am saying that if you qualify each name with the sheet name as well as
qualifying the RefersTo value with the sheet name, you would then use

You are saying use
A1 (cell in spreadsheet 2001) = Total + Subtotal
and
A1 (cell in spreadsheet 2002) = Total + Subtotal

the definitions will assume the sheet names.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ericx" wrote in message
...

Hi Bob,

Thanks for responding, much appreciated.

Your solution is definitely an option.
I wanted ...

1. common NAME definitions across spreadsheets (i.e. the same "Total"
name definition in different spreadsheets)
AND
2. common formulas across spreadsheets (i.e. A1=Total + Subtotal)

but it looks like I only get the choice between 1 or 2, not both.

You are saying use
A1 (cell in spreadsheet 2001) = 'Year 2001'!Total + 'Year
2001'!Subtotal
and
A1 (cell in spreadsheet 2002) = 'Year 2002'!Total + 'Year
2002'!Subtotal

so unique formulas, same NAME definitions...

Correct?

Eric


--
ericx
------------------------------------------------------------------------
ericx's Profile:
http://www.excelforum.com/member.php...o&userid=16860
View this thread: http://www.excelforum.com/showthread...hreadid=320456