Pivottable refresh in shared workbook

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!
 
J

Jon Peltier

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
 
M

mkeener

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

Refresh order when refreshing all in a workbook 1
troubleshoot shared workbook 0
trouble with shared workbook 1
Refresh of links in shared file. 0
corrupted shared excel workbook 1
this action will cancel a pending refresh data command 2
Refreshing Pivot Tables in a Shared Workbook 1
Font shrinkage in a Shared workbook 0

Top