Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Browse other questions tagged .