Changing CacheIndex causes the calculated fields to be lost

Hi
We are creating a new pivot cache and then changing an existing pivot tables cache index to the new cache pivotcache.index value.

pvtTable.CacheIndex = pc.index

By doing so we lose the pvtTable.CalculatedFields.Item values. Can anybody please explain how we can work around this problem


Thanks

Thanks for the reply. I fig out that the calculated fields are part of the cache but can you please explain how to I move it to the new cache