| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shared Workbook
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Shared Workbook
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. -- HTH... Jim Thomlinson "juanpablo" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Shared Workbook
But there has to be something to make it work or not??
"Jim Thomlinson" wrote: 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. -- HTH... Jim Thomlinson "juanpablo" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared workbook | Excel Worksheet Functions | |||
| Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
| who done it in a shared workbook | Excel Worksheet Functions | |||
| Shared Workbook | Excel Discussion (Misc queries) | |||
| update pivot in shared shared workbook | Excel Discussion (Misc queries) | |||
Linear Mode
