Pivot code - new data

L

Ludavhen

Greetings people,
I am from Holland, and we have been using a database in Dutch. We are now
upgrading to a new version where table column names are in English.
The upgrade takes almost everything into account..except the pivot tables
that we've been using.....which are over 100.
The Pivot tables won't work anymore as the column names have been altered.
(In 99% of the files the data has been extracted into a sheet in excel and
the pivots run from that sheet)
I have the "translation table" and I am wondering if i can "translate the
column names that the pivot uses (is there a way to get the vba codes of
pivots that were not recorded as a macro?).
 

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

Top