Hello,
is there any way to change/delete pivottable cache in excel 2003?
I have problem with Olap cubes when change only caption of dimensions member. I have to move dimension and put it again because pivottable remember the old caption. I have another question: Can I remember all dimensions, measures and formats in pivot and move them all and put them again on same way by code and not do that by hand?
is there any way to change/delete pivottable cache in excel 2003?
I have problem with Olap cubes when change only caption of dimensions member. I have to move dimension and put it again because pivottable remember the old caption. I have another question: Can I remember all dimensions, measures and formats in pivot and move them all and put them again on same way by code and not do that by hand?