using range names between several spreadsheets

[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!

 

[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.

 

[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.......

 

[Dave Peterson]

I missed that in your original question.

Debra Dalgleish shows a way (for a different purpose, though):
http://contextures.com/xlDataVal05.html#Reference
but it should answer your question.

 

[stef]

OK that's great peter, i'll look into it tx.

I missed that in your original question.

Debra Dalgleish shows a way (for a different purpose, though):
http://contextures.com/xlDataVal05.html#Reference
but it should answer your question.