Stopping PowerPivot Refreshing

S

StewartS

Board Regular
Joined
Feb 24, 2002
Messages
217
Hi

We have created a number of powerpivot reports where we want to keep the powerpivot data static. We have monthly reports which we need to refresh pivot tables in the report but we don't want to be able to refresh the powerpivot data. Therefore is there away of disabling the refresh data within powerpivot.

Using Excel 2010 and PowerPivot version 11.0.3000.0

Thanks

Stewart
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
You must log in or register to reply here.

Similar threads

J
  • Question Question
Using Slicer (or other Tool) to Add/Remove Fields from Rows of Pivot after Powerpivot (No-VBA)
Replies
1
Views
312
Matt Allington
M
M
  • Question Question
"The connection for this pivottable has been deleted" in Power Pivot
Replies
0
Views
899
Mr_Stern
M
B
  • Question Question
Display Measures with Custom Hierarchy
Replies
1
Views
125
Matt Allington
M
H
  • Question Question
Format of a column in a data model changes after refresh of data
Replies
6
Views
997
jdellasala
J
C
  • Question Question
Query adding columns on browser version of Excel when refreshed
Replies
0
Views
346
Curaga
C

Forum statistics

Threads
1,223,958
Messages
6,175,627
Members
452,661
Latest member
Nonhle

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top