#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default EURO CONVERTER

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.
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default EURO CONVERTER

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.




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default EURO CONVERTER

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.






  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default EURO CONVERTER

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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
euro millions DarkNight New Users to Excel 2 October 21st 06 05:49 PM
convert euro to SEK with converter tool? Tess Excel Discussion (Misc queries) 1 June 19th 06 03:04 PM
how do i convert EURO to GBP? Angie Setting up and Configuration of Excel 0 October 31st 05 04:42 PM
euro converter Joe Black Excel Discussion (Misc queries) 1 October 28th 05 12:54 AM
Euro conversion NumberCruncher Excel Worksheet Functions 0 April 20th 05 03:50 PM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"