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.