Excel Services in Sharepoint 2010 not displaying pivot table on refresh

R

rkamke

New Member
Joined
Feb 14, 2012
Messages
1
I have an Excel workbook published to my Sharepoint doc library and it is set to refresh automatically every 60 minutes and I don't have it set to refresh on open. When I open the workbook in my sp library I lose the fields in my pivot tables, but the data is refreshing in the rest of the workbook. I also have them set to save the cell formatting in the table options. What am I missing?
Thanks
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
You must log in or register to reply here.

Similar threads

D
  • Question
Pivot Table Refresh Issue
Replies
7
Views
333
Alex Blakenburg
A
R
  • Question
Data Model Error - Effecting all versions of the same workbook
Replies
0
Views
184
Rollnation3
R
H
  • Question
VBA code to open an excel workbook, Refresh the query (PQ), once it has finished running, save and close the workbook
Replies
2
Views
607
hananak
H
trishcollins
  • Question
Private Worksheet Pivot table Update is affecting Pivot table on another worksheet which uses same data source
Replies
0
Views
412
trishcollins
trishcollins
S
  • Question
Filter in Pivot Table Field List Clearing when The Pivot Table Is Refreshed
Replies
1
Views
459
arun_eagertolearn
A

Forum statistics

Threads
1,221,523
Messages
6,160,321
Members
451,637
Latest member
hvp2262

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