Pivot table - language problem

D

djdiplomat

New Member
Joined
Sep 7, 2009
Messages
32
I'm writing some reports for our German division.

Their pivot tables show grand totals etc in German 'Gesamtergebnis' etc.

When I refresh the table it reverts to English and the look-ups I am using error. Is there a way to keep the reports in German when I refresh to make it easy for me to test?

Thanks
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
You must log in or register to reply here.

Similar threads

S
  • Question
Pivot Table sum/count question.
Replies
1
Views
247
denzo36
D
A
  • Solved
Pivot Table Slicers mystery!!!
Replies
9
Views
852
adambc
A
M
  • Question
Pivot Table showing 2 sectors
Replies
2
Views
284
RoryA
RoryA
F
  • Question
Pivot table - refresh all - error 'reference isn't valid' - find the route pivot table causing the issue
Replies
2
Views
583
Alex Blakenburg
A
PeteWright
  • Question
using decimal separator in VBA on computers with different language settings causing errors
Replies
2
Views
2K
Alex Blakenburg
A

Forum statistics

Threads
1,215,063
Messages
6,122,928
Members
449,094
Latest member
teemeren

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top