Shared Workbook

J

juanpablo

Why the Pivot Tables are disabled when I share a workbook under the option of
Tools->Share Workbook->Allow Changes by More Than One User at a Time.???

JPG
 
J

Jim Thomlinson

Sharing is essentially a type of protection. When workbook is shared there
are a whole pile of things that are disabled. Right from the XL help file...

You won't be able to add or change the following: merged cells, conditional
formats, data validation, charts, pictures, objects including drawing
objects, hyperlinks, scenarios, outlines, subtotals, data tables, PivotTable
reports, workbook and worksheet protection, and macros.
 

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

shared workbook - shared workbook options grayed out 0
Sharing workbooks limitations - Merged Cells 12
How to Activate "Show all" in a Protected Shared Workbook 1
Pivot tables - Editing the data source shared by multiple pivot ta 1
Can't share workbook. The "Share Workbook" option is off. Why? 4
Pls help on Shared WorkBook 1
Locking cells in a shared workbook 2
Doubt about pivot table 2

Top