Excel Localization and Pivot Tables

T

Theala

I tested this behavior in Excel 2003, 2007 and 2010 (Beta).

When I use Pivot Tables with Data Source references (Ex: TABLE[#ALL])
it can´t work if I use Excel in another Language (Localization) from
previous save. That means that if i created in Excel in English, I can
´t refresh Pivot Table in Portuguese, because of localization (EX:
TABLE[#ALL] = English , TABLE[#TUDO] = Portuguese).

Is there a design issue or a bug?

All other formulas translates and work as intended. (Ex: SUM =
English , SOMA = Portuguese)

PS: A workaround is to manually change data source in each Pivot
Table. (Ex: TABLE[#ALL] -> TABLE[#TUDO])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Pivot table report invalid 0
Embedded Excel into Word with Tables 0
Excel 2013 Pivot Data Range formula reference problem 0
Consolidation Table from Different Excel Tabs with Different Format 1
Multiple Pivot Tables Expand to Fit 0
Consolidate Pivot Tables/Cache using Excel 2003 1
Excel 2010 Slicer Connection / Pivot Table Problem 3

Top