Pivot table refresh - how do you stop auto-refresh?

B

bscruggs

I hava an extremely large pivot table linked to an
offline OLAP cube. Is there a way to prevent the pivot
table from recalculating whenever a change a column or
row field?

I'm looking for a pivot table analog of the tools-
 
B

Bill Ridgeway

Open the Pivot table options -
Click on <View><Toolbars><Pivot table>
Open up the panel <Pivot table> and click on <Options ...>
In the section <Data source options> and untick <refresh on open>

Regards.

Bill Ridgeway
Computer Solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table layout that popluates the row label in each row? 3
Pivot ungrouping on refresh? 3
Pivot Table Page Break Refresh Problem 0
Pivot Table refresh 3
how do i refresh a pivot table report in a shared file 1
Excel 2k Pivot Table refresh scenario 1
OLAP Pivot Table Calculations 4
How do I save Pivot Table Data 4

Top