ExcelBanter - EURO CONVERTER

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - EURO CONVERTER (https://www.excelbanter.com/excel-worksheet-functions/132611-euro-converter.html)

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.

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.

Thanx ever so much for responding David. I went to the page you suggested,
read the instructions ..... to download the ADD-INS .... buttttt it tells me
to go to TOOLS and then to ADD-INS .... and my bloody TOOLS menu in EXCEL
does notttt have the ADD-INS option ..... maybe i have an older version of
XL ??

One other question by the by .... does Windows come with the Euro Converter
already installed ??? is it a normal function of XL ??? you see, i have
never used it and the woman who wrote the spread-sheet is a Russian that is
no longer working for us .... so i am trying to pick up on her work !!!

cheers, Amanda ( by the way, i must travel tomorrow, so might not be able to
respond until next Monday )

"David Biddulph" wrote:

From http://office.microsoft.com/en-us/ex...909881033.aspx on the
EUROCONVERT() function:
"If this function is not available, and returns the #NAME? error, install
and load the Euro Currency Tools Add-in. "
--
David Biddulph

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

Amanda

Eurotools add-in is installed with a typical installation of Excel.

http://office.microsoft.com/en-us/ex...CH062527761033

As far as having no Add-ins on your Tools menu..............

1. Right-click on any Toolbar and Customize. Select the "Options" tab and
"always show full menus"

2. If no joy there, right-clickcustomizetoolbars. Select the Worksheet Menu
Toolbar and "reset"

Gord Dibben MS Excel MVP

On Wed, 28 Feb 2007 14:51:10 -0800, Amanda from Spain
wrote:

Thanx ever so much for responding David. I went to the page you suggested,
read the instructions ..... to download the ADD-INS .... buttttt it tells me
to go to TOOLS and then to ADD-INS .... and my bloody TOOLS menu in EXCEL
does notttt have the ADD-INS option ..... maybe i have an older version of
XL ??

One other question by the by .... does Windows come with the Euro Converter
already installed ??? is it a normal function of XL ??? you see, i have
never used it and the woman who wrote the spread-sheet is a Russian that is
no longer working for us .... so i am trying to pick up on her work !!!

cheers, Amanda ( by the way, i must travel tomorrow, so might not be able to
respond until next Monday )

"David Biddulph" wrote:

From http://office.microsoft.com/en-us/ex...909881033.aspx on the
EUROCONVERT() function:
"If this function is not available, and returns the #NAME? error, install
and load the Euro Currency Tools Add-in. "
--
David Biddulph

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