| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivottable refresh in shared workbook
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivottable refresh in shared workbook
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/ _______ "mkeener" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivottable refresh in shared workbook
Thanks for info, Jon.
"Jon Peltier" wrote: 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/ _______ "mkeener" wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to refresh a Scenario PivotTable Report? | Excel Discussion (Misc queries) | |||
| Refresh and PivotTable with Analysis Services | Excel Worksheet Functions | |||
| Refresh Pivottable last 4 weeks data from today | Excel Worksheet Functions | |||
| pivottable Table options - Refresh every <##> min is greyed out | Excel Discussion (Misc queries) | |||
| Shared Workbook Settings, End User Update Changes Refresh Rate | Excel Discussion (Misc queries) | |||
Hybrid Mode
