Pivottable refresh in shared workbook

  • Thread starter Thread starter mkeener
  • Start date Start date
M

mkeener

How can I refresh pivottables in a shared workbook? I have "refresh on open"
marked which doesn't seem to refresh unless I remove sharing. Also, is there
a way to "open exclusive" like we can with Access databases? If I can
automate removing/replacing sharing, I know I can refresh pivottables between
those two actions.

Thanks much for any assistance!
 
To facilitate sharing of workbooks, Excel has to remove certain core
functionalities. The only way around this is to unshare the workbook. I
don't know of an open exclusive type of access, unless of course, it means
using unshared workbooks.

- Jon
 
Thanks for info, Jon.

Jon Peltier said:
To facilitate sharing of workbooks, Excel has to remove certain core
functionalities. The only way around this is to unshare the workbook. I
don't know of an open exclusive type of access, unless of course, it means
using unshared workbooks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
Click to expand...
 

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

Exclude Network Path In PivotTable Based on Sharepoint 1
How to refresh a Scenario PivotTable Report? 9
Refresh order when refreshing all in a workbook 1
Pivottable refresh problem 1
Pivot Table in a Shared Workbook 2
Shared File Automatic Update 1
this action will cancel a pending refresh data command 3
erratic response while working on a table in excel linked to a tab 2

Back
Top