Microsoft KB Archive/832342

= Cannot use the IMPORTARDATOSDINAMICOS function in the Spanish version of Excel 2002 =

Article ID: 832342

Article Last Modified on 1/15/2004

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



SYMPTOMS
In the Spanish version of Microsoft Excel 2002, when you click OK (Acceptar in Spanish) to use the GetPivotData (IMPORTARDATOSDINAMICOS) function, the Insert Function dialog box closes and the Function Arguments dialog box does not appear.



WORKAROUND
To work around this problem, follow these steps:
 * 1) In your Excel 2002 worksheet, click the cell where you want the information to appear.
 * 2) Type =.
 * 3) Click the cell of your pivot table that contains the data that you want.
 * 4) Press ENTER.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section of this article.



MORE INFORMATION
To start the GetPivotData function, follow these steps:
 * 1) Open your workbook in Excel 2002.
 * 2) On the Insert menu, click Function.
 * 3) In the Insert Function dialog box, change the Or select a category box to All.
 * 4) In the Select a function list box, click GETPIVOTDATA (IMPORTARDATOSDINAMICOS in Spanish).
 * 5) Click OK (Acceptar in Spanish).

For more information about the GetPivotData function, click Microsoft Excel Help on the Help menu, type getpivotdata in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: XL2002

Keywords: kbprb KB832342

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.