View pivotchart in shared workbook
 

Hi
I have a workbook with several worksheets. Each of the worksheets has a
pivotchart that is perfectly fine when the workbook is opened normally.
When the workbook is shared, the charts are not viewable - the whole chart
area is just a grey box.
I am not trying to change or add new charts - just simply want to view the
existing ones.
Can anyone help please?
Thanks
John