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...