Pivot Table in a Shared Workbook

G

Guest

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
 
D

Debra Dalgleish

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'
 
G

Guest

Great, thanks very much!

kindest regards,
Chris

Debra Dalgleish said:
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'
Click to expand...
 

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

Pivottable refresh in shared workbook 2
Sharing workbooks limitations - Merged Cells 12
how do i refresh a pivot table report in a shared file 1
shared workbook - shared workbook options grayed out 0
Unshare a Shared Workbook 1
corrupted shared excel workbook 1
Locking cells in a shared workbook 2
How to unlock workbook? 1

Top