Excel not updating links when workbook closed

[Ramballah]

Hi,

In my workbook I have 2 pivot tables referencing to different workbooks.
One of the 2 pivot tables is working perfectly normal and updates whenever I click refresh or startup the file.
The other one however keeps telling me that it cant pull the information unless if I open that workbook:

So if I don't have workbook Project A saldilijst Debiteuren open it wont pull the information.
The other pivot table does work fine when I have it closed...

Could someone explain this to me?

Thanks in advance,
Ram

 

[Ramballah]

bump

 

[Ramballah]

I should also mention that I do not use any connections. My pivot table is made of data from a different workbook (same for my pivot table that is working)
There is no query or anything that could be it according to the internet. Neither is it a sumif function since its a pivot table.

 

[Ramballah]

bump

 

[Ramballah]

bump

 

[Ramballah]

bump

 

[zesid]

Hi,

In my workbook I have 2 pivot tables referencing to different workbooks.
One of the 2 pivot tables is working perfectly normal and updates whenever I click refresh or startup the file.
The other one however keeps telling me that it cant pull the information unless if I open that workbook:
View attachment 23432
So if I don't have workbook Project A saldilijst Debiteuren open it wont pull the information.
The other pivot table does work fine when I have it closed...

Could someone explain this to me?

Thanks in advance,
Ram

It may possible that your file has removed or renamed.

 

[Ramballah]

It may possible that your file has removed or renamed.

Nope not at all. If I reselect the range of the pivot table it will still give me the error.

 

[Ramballah]

bump

 

[Ramballah]

bump