Stop auto-refresh on Pivot Tables

[Gemma D]

Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Does anyone know how to stop a pivot table automatically refreshing when you drag & drop options in from the navigation panel?? Is this a setting in the OLAP cube that needs to be changed?

Ideally, I would like to construct a pivot table & then click the refresh button to generate the information.<o></o>
<o></o>
All suggestions welcomed! Thank you!<o></o>

Gemma

 

[nancymk]

Hi there - You can just go to the table options and make sure "refresh on open" is unchecked and "refresh every XX minutes is unchecked"

Then it should only refresh when you hit the exclamation point.

 

[Greg Truby]

Do you really mean *refresh*, as in it re-querying the pivot's data source (in which case I think Nancy's suggestion should work).

Or do you mean that you don't want it to re-draw or re-calc the pivot until you're done adding/moving fields? In which case you might want to try out the Pivot Table wizard's layout helper. You can arrange all the fields there and then, when you click FINISH, the wizard will create the pivot.

 

[Gemma D]

Yes, I mean 'refresh'. I have used the Wizard, and this is very helpful, but I need to drill down into the dimentions table of the olap cube - this is what takes the time & crashes my machine!!! Any ideas?? Thanks

 

[Greg Truby]

I'm sorry, but I don't have any experience using a "OLAP cube" per se as a pivot source. Other than ranges, I have only hooked into Access tables. So I don't really have a means of testing your scenario. Were I hooking into an Access query and triggering unwanted refreshes, I would change the query to a make-table query in an attempt to decrease volatility. Not sure if you have a similar option available to you.

 

[makanijatin]

Yes, I mean 'refresh'. I have used the Wizard, and this is very helpful, but I need to drill down into the dimentions table of the olap cube - this is what takes the time & crashes my machine!!! Any ideas?? Thanks

There is option at bottom "Defer Layout Update" and if you will check that check box then you have to click update every time you want to update your pivot table