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

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

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