Thank you for responding Roger - this service is amazing! do you work for
microsoft or are you simply a forum XL wizz ??

The code is one of the cells IS :::

='C:\Program Files\Microsoft
Office\OFFICE11\LIBRARY\EUROTOOL.XLA'!EUROCONVERT( B4,"EUR","ESP")

as an example - all the rest do refer to a different cell on the sheet that
i can read.

Might have to be out of touch until monday ... as i am travelling tomorrow
.... but will respond as soon as i can!

cheers, Amanda.

"Roger Govier" wrote:

Hi Amanda

What is the formula in the cells that come up with #NAME.
If you can tell us that, I would think the insertion of that Name
through InsertNameDefine with value equal the conversion rate between
Pesetas and Euros will solve you problem.

--
Regards

Roger Govier


"Amanda from Spain" <Amanda from wrote
in message ...
Hello, i have 4 spreadsheets from 2002 that i really need to use NOW
....
andddd, I have columns with Euros and Pesetas ...... which, in 2002
linked
on a different computer to the one i am using .... to the
euroconverter.....
BUT ... now, when i open any of the 4 documents ( and it´s the same
result if
i UPDATE - as when i DON´T UPDATE ) ..... all the cells that used the
EURO
CONVERTER have a NAME? inside !!! .... is there any way of ammending
this
quickly ????

Just before closing .... the strange thing is that .... when i open
the
document and the window comes up with UPDATE - DON´T UPDATE
options...... in
the background i can see the whole spreadsheeet will ALL the numbers
in it
.............. but then, when i either UPDATE, or DON´T UPDATE, or
even just
close that window .... all the cells turn into NAME??? ...... cells
!!!!!!!!!!!!!!!!

Would be so greatfull for an answer !!! thank you !!!! Amanda.