Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 ?

share|improve this question
Check the defer layout changes option on the pivotchart view. – soandos Feb 21 '12 at 1:13
@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 Becker Feb 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. – soandos Feb 21 '12 at 15:39
@soandos glad to hear that, i thought there was something wrong with me not finding that.. – yurib Feb 21 '12 at 16:16
@yurib, I don't think there is an equivalent option in Access. No idea why though. – soandos Feb 21 '12 at 16:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.