DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2551525 - Last Review: April 17, 2014 - Revision: 8.1

On This Page

Summary

To provide improved function accuracy, consistent functionality that meets expectation, and function names that more accurately describe their functionality, several Excel functions were updated, renamed, or added (http://office.microsoft.com/en-us/excel-help/what-s-new-changes-made-to-excel-functions-HA010355760.aspx)  to the function library in Microsoft Excel 2010, Microsoft Excel Services 2010 and Microsoft Excel Online 2010.

Additionally, some frequently entered functions were re-localized in 10 different languages (Czech, Danish, Dutch, Italian, Norwegian, Portuguese, Portuguese-Brazil, Spanish, Swedish, and Turkish). This results in a #NAME? error when the familiar Microsoft Excel 2007 function name is entered instead of the updated function name in Excel 2010. When you open a workbook in Excel 2010, Excel Services 2010 or in the Excel Online that contains function names from earlier versions of Excel, the updated function name appears.

Because of customer feedback, Microsoft has decided to return these frequently entered functions back to their Excel 2007 localized names. To return the function names to their 2007 names, download Microsoft Office 2010 Service Pack 1.

Example

The VLOOKUP function in Spanish is named BUSCARV under Excel 2007. However, in Excel 2010 the Spanish name was changed to CONSULTAV. If you enter BUSCARV instead of CONSULTAV in Excel 2010 pre-SP1 you would receive a #NAME? error.

To reproduce this behavior, follow these steps in the Spanish version of Excel 2010:
  1. Create a new Excel workbook.
  2. In cell A1, type 1, and then in cell A2, type 2.
  3. In cell B1, type a, and then in cell B2, type b.
  4. In cell D1, type 1, and then in cell D2, type =BUSCARV(D1,A1:B2,2).
If you have not installed Service Pack 1, you will receive the error #¿NOMBRE? when you enter =BUSCARV(D1,A1:B2,2) in Excel 2010. The correct function to enter in a pre-SP1 Excel 2010 version is =CONSULTAV(D1,A1:B2,2).

However, when you install Service Pack 1, you will receive the error #¿NOMBRE? if you enter =CONSULTAV(D1,A1:B2,2) in Excel 2010. The correct function to enter in a post-SP1 Excel 2010 version is =BUSCARV(D1,A1:B2,2).




More information

After Service Pack 1 is installed, all workbooks that were created in earlier versions of Excel including pre-SP1 Excel 2010 workbooks automatically display the updated function names. The functions do not have to be re-entered in order to see the updated names.

To download and install Office 2010 SP1, visit the following Microsoft Knowledge Base article:

2460049 - Description of Office 2010 SP1 (http://support.microsoft.com/kb/2460049/)


For enterprise customers, visit any or all of these Microsoft Knowledge Base articles depending on your environment:

2460043 - Description of Office 2010 Language Pack SP1 (http://support.microsoft.com/kb/2460043/)
2460073 - Description of Office Online SP1 (http://support.microsoft.com/kb/2460073/)
2460056 - Description of Office Servers 2010 Language Pack SP1 (http://support.microsoft.com/kb/2460056/)
2460044 - Description of Office Language Interface Pack 2010 SP1 (http://support.microsoft.com/kb/2460044/)
2460045 - Description of SharePoint Server 2010 SP1 (http://support.microsoft.com/kb/2460045/)
2460047 - Description of SharePoint and Project Server 2010 SP1 (http://support.microsoft.com/kb/2460047/)

Function and Language tables

The following section provides the languages and functions updated by Service Pack 1.

Czech
The following table lists the Czech worksheet functions that were changed in Service Pack 1:

Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
IFERRORCHYBHODNIFERROR
LEFTVLEVOZLEVA
NOTNENÍNE
RIGHTVPRAVOZPRAVA
TEXTTEXTHODNOTA.NA.TEXT


Danish
The following table lists the Danish worksheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
AVERAGEGENNEMSNITMIDDEL
AVERAGEIFGENNEMSNIT.HVISMIDDEL.HVIS
AVERAGEIFSGENNEMSNIT.HVISSMIDDEL.HVISER
COUNTIFSTÆL.HVISSTÆL.HVISER
CUBEKPIMEMBERKUBEKPIMEDLEMKUBE.KPI.MEDLEM
CUBEMEMBERPROPERTYKUBEMEDLEMSEGENSKABKUBEMEDLEM.EGENSKAB
CUBERANKEDMEMBERKUBERANGERETMEDLEMKUBERANGERET.MEDLEM
CUBESETKUBE.ANGIVKUBESÆT
CUBESETCOUNTKUBE.ANGIV.ANTALKUBESÆT.ANTAL
DAVERAGEDGENNEMSNITDMIDDEL
DOLLARVALUTAKR
FLOORGULVAFRUND.GULV
GCDFÆLLES.DIVISORSTØRSTE.FÆLLES.DIVISOR
HYPERLINKLINKHYPERLINK
IFERRORHVISFEJLHVIS.FEJL
INTHELHELTAL
ISERRER.FEER.FJL
LOOKUPOPSLAGSLÅ.OP
MODETILSTANDHYPPIGST
NNTAL
OCT2DECOCT.TIL.DECOKT.TIL.DEC
RECEIVEDMODTAGETMODTAGET.VED.UDLØB
RIGHTBHØJRE_BHØJREB
SUMIFSSUM.HVISSSUM.HVISER

The following table lists the Danish Macro sheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
RESET.TOOLBARNULSTIL.VÆRKTØJSLINJEGENDAN.VÆRKTØJSLINJE
TEXT.BOXTEKSTFELTTEKSTBOKS

Dutch
The following table lists the Dutch worksheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
CHOOSEKIESKIEZEN
CLEANSCHOONWISSEN.CONTROL
DAVERAGEDGEMIDDELDEDBGEMIDDELDE
DAYS360D360DAGEN360
DCOUNTDAANTALDBAANTAL
DGETDHAALDBLEZEN
DOLLARVALUTAEURO
DSTDEVDSTDEVDBSTDEV
DSUMDSOMDBSOM
FINDVINDEN.ALLESVIND.ALLES
LOOKUPOPZOEKENZOEKEN
LOWERKLEINELETTKLEINE.LETTERS
MIDMIDDENDEEL
NPVHNWNHW
PMTAFLOSSINGBET
PROPERBEGINKAPBEGINLETTERS
REPLACEVERVANGVERVANGEN
ROUNDAFRONDINGAFRONDEN
SLNRAALIN.AFSCHR
SQRTVWORTELWORTEL
UPPERHOOFDLETTHOOFDLETTERS
VALUEGETALWAARDE
VDBVAPVDB

The following table lists the Dutch Macro sheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
BREAKEINDEONDERBREKEN
FORVOORVAN
GOTOGANAARGA.NAAR
GROUPGROEPGROEPEREN
NOTEOPMERKINGNOTITIE
RESTARTOPNIEUWOPNIEUW.STARTEN

Italian
The following table lists the Italian worksheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
FINDRICERTROVA
MINUTEMINUTIMINUTO
SECONDSECONDISECONDO


Norwegian
The following table lists the Norwegian worksheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
CHARTEGNTEGNKODE
CLEANRYDDRENSK
IPMTRANNUITETRAVDRAG
ISPMTER.ANNUITETER.AVDRAG
MAXMAKSSTØRST
PMTANNUITETAVDRAG

The following table lists the Norwegian Macro sheet functions that where changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
NEXTNEXTNESTE

Portuguese
The following table lists the Portuguese worksheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
FIXEDFIXOFIXA
NANDNÃO.DISP
USDOLLARMOEDA2MOEDA.EUA

Portuguese - Brazil
The following table lists the Portuguese - Brazil worksheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
COLUMNCOLUNACOL
FACTFATOFATORIAL
FIXEDFIXODEF.NÚM.DEC
FREQUENCYFREQUÊNCIAFREQÜÊNCIA
MINMÍNMÍNIMO
PRODUCTPRODUTOMULT
RECEIVEDRECEBIDORECEBER
SEARCHPESQUISARLOCALIZAR
SERIESSUMSOMASÉRIESOMASEQÜÊNCIA
STDEVDESVPAD.NDESVPAD
TRUNCTRUNCTRUNCAR
VARVARESTVAR

The following table lists the Portuguese - Brazil Macro sheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
DATE.STRINGCADEIA.DATADATA.SÉRIE
ENABLE.COMMANDHABILITAR.COMANDOATIVAR.COMANDO
ENABLE.TOOLHABILITAR.FERRAMENTAATIVAR.FERRAMENTA
EXECUTEEXECUTAREXECUTE
FCLOSEARQ.FECHARARQN.FECHAR
GET.WORKSPACEINFO.ESPAÇO.TRABALHOINFO.ÁREA.TRABALHO
LINKSLINKSVÍNCULOS
NUMBER.STRINGCADEIA.NÚMEROSEQÜÊNCIA.NÚMERO
REGISTERREGISTRARREGISTRO
RESUMECONINTUARREINIC

Spanish
The following table lists the Spanish worksheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
CHARCARCARACTER
CONVERTCONVERTCONVERTIR
DATEVALUEVALFECHAFECHANUMERO
DAYS360DÍAS360DIAS360
DCOUNTBDCUENTABDCONTAR
HLOOKUPCONSULTAHBUSCARH
IFERRORSIERRORSI.ERROR
MIDMEDEXTRAE
MODRESTORESIDUO
MODEMODOMODA
NANDNOD
SQRTRCUADRAIZ
TBILLEQLETRA.DE.TES.EQV.A.BONOLETRA.DE.TEST.EQV.A.BONO
TIMETIEMPONSHORA
TIMEVALUEVALHORAHORANUMERO
TRIMRECORTARESPACIOS
VLOOKUPCONSULTAVBUSCARV

The following table lists the Spanish Macro sheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
GOTOIRIR.A
NEXTSIGUIENTESALIR.BUCLE
RETURNDEVOLVERVOLVER

Swedish
The following table lists the Swedish worksheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
CLEANRENSASTÄDA
DAYS360D360DAGAR360
DDBDFAVDEGAVSKR
FALSEFALSKFALSKT
HLOOKUPHTSÖKLETAKOLUMN
HOURTIMTIMME
ISNAÄRETÄRSAKNAD
ISNUMBERÄRNUMÄRTAL
ISTHAIDIGITŽRTHAISIFFRAISTHAIDIGIT
LEFTVÄNSTERPILVÄNSTER
LOWERSMÅGEMENER
MIDMITTEXTEXT
MODELÄGETYPVÄRDE
NIN
NAETSAKNAS
NPVNVLFNETNUVÄRDE
PMTAVBETBETALNING
PVNVNUVÄRDE
RATEPRSRÄNTA
RIGHTHÖGERPILHÖGER
SLNLNALINAVSKR
SYDÅATPÅRSAVSKR
TRIMSTÄDARENSA
TRUESANNSANT
UPPERSTORAVERSALER
VLOOKUPVTSÖKLETARAD

Turkish
The following table lists the Turkish worksheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
SUMTOPLAMTOPLA

The following table lists the Turkish Macro sheet functions that were changed in Service Pack 1:
Collapse this tableExpand this table
English 2010 FunctionExcel 2010Excel 2010 SP1
GET.MOVIEAL.FILMGET.MOVIE
MOVIE.COMMANDFILM.KOMUTMOVIE.COMMAND







Applies to
  • Microsoft Excel 2010
Keywords: 
KB2551525
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support