Macro for automatically rewriting pivot part of the table

Give me a little more information on what you mean by "links to pivot table does not work anymore." Could it be that you are using something like a cross-tab query and creating new headers that are not known to the pivot table?

If so, then you should change the output of the query to produce the data in a normalized format.

I use both databases and Excel and some things are done better in one than another. You could use VLOOKUP to do things that JOIN does in a database, but the database is usually much more efficient. On the other hand, you can do cross tab queries or use a pivot table in excel on normalized data. In this case, Excel wins.