using range names between several spreadsheets

S

stef

Excel 2002 SP3
Win XP HE SP1

how do i use a range name that is defined in 1 excel file with a formula
i am writing in another excel file?
i can't figure out how to just copy|paste the name, etc.
tx!
 
D

Dave Peterson

Here's something you could try to see the syntax:

In the workbook that's getting the formula
Type =
in an empty cell

The go to the workbook that has the name. If the name is local to a particular
sheet, go to that sheet.

Hit F3 to see the Paste Name dialog
choose the name you want
hit enter

Look at how the formula was completed.
 
S

stef

that works. i had already done that but i guess i didn't notice it was
actually working--pasting it inside the other (current) sheet in other file.
however, it is not as good as having the actual name defined in the
current sheet/file.
i can define it in current sheet but it wd be so much simpler if i cd
just take the name defined in 1 file and just copy paste as a name into
current sheet/file.......
 
Top