Pivot table error message when workbook opens....

[Gooford]

I have a workbook with a large number of links to a number of external workbooks.

A lot of this information feeds into pivot tables.

When I open the workbook I get a message saying that there is a problem with the headings on one of the pivot tables, but how can I find out which one it is?

I cant see an obvious problem with any of them

Regards

G

[Skorpion16]

Hi GooFord...

Can you put your workbook here... for we can see the real problem, because what you said was very vague...


thanks in advanced

[Gooford]

thats the problem - I cant cos of the data involved.

I cant really create an example as I dont understand what is causing the problem. I will have a think about how to describe it better - thanks!

Basically, when I open the workbook, I get the attached messages:

Firstly, I want to know if there is a way of identifying which of the five pivot tables this message relates to?

If not, I think I may have to manually go through each one

[Skorpion16]

can you put what said in error message...???