Creating Pivot Table Relationships

[prenest]

Hi all,

I am trying to link 3 worksheets to one Pivot Table via relationships, but when I try to create my original Pivot Table I get the following error:

We couldn't load the Data Model. This may be because the Data Model in this workbook is damaged.

I'm not using external data, just regular data in a table format.

Any help would be appreciated, thanks in advance.

 

[ask2tsp]

Prenest, when linking tables (error) messages are a bit unclear sometimes. Could you provide more details. The lay-out of the three tables used. What is/are the identifying column(s). How are the tables linked. Also a small sample (10-20 rows) of each table will help.