Table relationship error

Copper Contributor

I am getting an error message when I try to update the data 

 

not enough system resources to display the dialog

 

File attached

 

Please help!

3 Replies

Hi Sergio

 

Where is the source for your Pivot Tables?

 

Which data are you updating?

 

What version of Excel are you using?

 

Thanks

 

Wyn

 

Hi Wyn,

 

I am using table 10 (Sheet: 2.2 List of initiatives) and table 2 (sheet: Summay Targets)

 

Excel 2016

 

Thanks for your help

 

Sergio

How did you create your pivot tables, they don't appear to be connected to the tables in the usual way

 

Did you use Create Relationships? 

 

Also, it looks like a Table in and external file is being referenced..  Tracking Tool Iberia v7.6.xlsx

 

Pivot Table Connections.PNG