I'm creating a pivot chart view of some data in MS Access 2010. I'm working with a large data set so every operation takes a long time.

My problem is that access automatically re-creates the pivot chart view with every change i make:
once after setting the series field,
again after setting the values field,
again after setting the categories field etc.
waiting for the chart to be recreated after every change like that is a complete waste of time and it's driving me mad.

I'd like to be able to make all the changes i want and only then hit a button and have access generate the chart, a sort of "apply" button. is it possible in any way ?

@soandos - This seems like a very specific and most likely correct answer. Why do you make it as a comment instead of an answer? Not a criticism - I'm genuinely curious.
–
Dave BeckerFeb 21 '12 at 6:06

@DaveBecker, I know that is how to do it in excel, but I did not have access on the machine that I was working on at the time. Now that I am checking, I cannot find that option.
–
soandosFeb 21 '12 at 15:39

@soandos glad to hear that, i thought there was something wrong with me not finding that..
–
yuribFeb 21 '12 at 16:16

@yurib, I don't think there is an equivalent option in Access. No idea why though.
–
soandosFeb 21 '12 at 16:19