Problem saving Pivot charts

[omodarah]

Dear all,

I have what I hope is a simple problem, but one if I dont solve will become a nightmare to manage.

I have an application that need to provide set Pivot Chart views for Management to look at and I just found yesterday that I cannot save a Pivot chart in Access 2003 or 2007. When I save it and re-open it just displays the Chart with the field list and I have to do the work all over again.

Can someone please tell me how I save a Pivot Chart view?

Thanks in advance.

 

[omodarah]

The problem was that I was basing my Chart on a Query as opposed to the Table. The query always recalculates on open. Problem solved.