Pivot table 'format' that fills it self when data is pasted in to a sheet.

[KVT Holland]

Hi,

I'm new to the pivot tables but they've already drove me crazy. I've been trying to make a format workbook where people can export data to.
This data gets 'translated' by the use of formulas in another sheet. The pivot table should then just read the translated data and fill the
pivot tables as they where on the original sheet.

- I've tried using a macro that would import the data and then give the range the name that the pivot was linked to and deleted the old one, but this would result in to it looking like the picture
- I've tried saving the translated data as chart, named range and copie as value (and tried as tekst).
- Copy the pivot in to another workbook that contained the data that worked in another sheet
- I've tried to macro an vba code the pivot to do what i want
- Even if i deleted all the data that was used and then pasted the exact same data back in to the same spot.

To be honest.... everything i dit resulted it in to looking like this and no way to make it look like it should. I was however able to adjust al the adresses
and names and then refresh the pivot tables. I tried making a macro that would swap the text in the data sheets with the data of the new sheet, but that
not a viable option due to to many variables.

This is how it should look (sort of)

I hope you guys can explain why the pivot table is so hard to drop new data on. and how i should approach this.
At this point i'm just temped to reproduce the data without the pivot table.

Kind regards,

Koen.