PIVOTTABLE not updating on File open

[Pete_Bristol]

Dear Forum,

Please can you help?

I have a workbook containing about 10 pivottables which are all DEFINATELY set to "Refresh on File open".

8/10 of them update as expected but two dont. I thought maybe these two connected/shared in some way the same pivotcache but they are both different. However, both are linked to pivot charts.

Please can anybody offer advice as to why these two tables might not update? Configurations? Settings? etc

Thanks in anticipation,

Regards,

Pete

 

[Krishnakumar]

Cross-Post

 

[MarkAndrews]

Cross-Post

A chap from another forum suggested a workaround, which does work, in that you have to tick the box about saving data with file. As this clears out the data, I guess Excel has no choice but to reload it?

Anyhow, many thanks for your time and help.

Regards,

Pete

As Pete mentioned earlier KrishnaKumar