Forum Discussion

Sergio Gellida's avatar
Sergio Gellida
Copper Contributor
Jan 04, 2017

Table relationship error

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!
excel
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jan 05, 2017

Hi Sergio

 

Where is the source for your Pivot Tables?

 

Which data are you updating?

 

What version of Excel are you using?

 

Thanks

 

Wyn

 

Sergio Gellida's avatar
Sergio Gellida
Copper Contributor
Jan 05, 2017

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

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jan 05, 2017

    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

     

Resources