I have the same problems - I get around it by making a copy of the pivot chart in VBA and opening this instead of the original - therefore the properties for the original pivot chart don't get changed. However you need to make sure that your pivot chart form does not have any VBA code, otherwise it can;t run the DoCMmd.CopyObject from VBA. (I think what stops this is because the copied object has code, Access has to re-compile and it can't do that when it is part way through the code.)
If anyone knows how to Lock the properties instead I would really like to do that, or at least make it so that the pivot charts propoerties are not saved back to the Access file.
