Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EURO CONVERTER
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
euro millions | New Users to Excel | |||
convert euro to SEK with converter tool? | Excel Discussion (Misc queries) | |||
how do i convert EURO to GBP? | Setting up and Configuration of Excel | |||
euro converter | Excel Discussion (Misc queries) | |||
Euro conversion | Excel Worksheet Functions |