| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table with protect workbook
Dear All,
In a file, I wanna have the track changes on one worksheet but also using pivot table on the other. However, while the track changes on (& workbook shared!), I cant use the filter buttons in the pivot table... So do you have any ideas to overcome this?? or both can be used at same place?? Thx lots! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table with protect workbook
You can't change or create a pivot table in a shared workbook.
For more information on shared workbooks, look in Excel's Help, under the topic 'Features that are unavailable in shared workbooks' kalz wrote: In a file, I wanna have the track changes on one worksheet but also using pivot table on the other. However, while the track changes on (& workbook shared!), I cant use the filter buttons in the pivot table... So do you have any ideas to overcome this?? or both can be used at same place?? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table | Excel Discussion (Misc queries) | |||
| Pivot table keeps dupping to another linked pivot table | Excel Discussion (Misc queries) | |||
| Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
| Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
| Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
Hybrid Mode
