Pete_Bristol
Board Regular
- Joined
- Mar 8, 2006
- Messages
- 122
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
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