Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table in a Shared Workbook
Hi! Can I use pivottables in a shared workbook? The reason I ask is that its
greyed out in a shared WB but not in a non-shared. I can't find anything on this, perhaps somebody can help? thanks! Chris |
#2
|
|||
|
|||
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' Riskybizniz wrote: Hi! Can I use pivottables in a shared workbook? The reason I ask is that its greyed out in a shared WB but not in a non-shared. I can't find anything on this, perhaps somebody can help? thanks! Chris -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Great, thanks very much!
kindest regards, Chris "Debra Dalgleish" wrote: 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' Riskybizniz wrote: Hi! Can I use pivottables in a shared workbook? The reason I ask is that its greyed out in a shared WB but not in a non-shared. I can't find anything on this, perhaps somebody can help? thanks! Chris -- 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 in separate workbook | Excel Discussion (Misc queries) | |||
using forms in a shared workbook | Excel Worksheet Functions | |||
pivot table | Excel Worksheet Functions | |||
Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel |