1
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 ?
yurib
Posted 2012-02-21T00:58:47.823
Reputation: 1 042
Check the defer layout changes option on the pivotchart view. – soandos – 2012-02-21T01:13:32.033
@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 – 2012-02-21T06:06:41.160
@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 – 2012-02-21T15:39:54.820
@soandos glad to hear that, i thought there was something wrong with me not finding that.. – yurib – 2012-02-21T16:16:50.313
@yurib, I don't think there is an equivalent option in Access. No idea why though. – soandos – 2012-02-21T16:19:50.840