Working with Pivot Tables in a shared workbook

[Jarryd]

Hi,

I have a workbook that has a load of pivot tables in it. When I share the
workbook I can't use the pivot tables anymore. Please would someone tell me
why, and how do I get around this. I need to be able to share this
spreadsheet so that other users can make use of the pivot table I have
created.

TIA,

Jarryd

 

[Jarryd]

Hi,

By the way. I don't need to modify the pivot tables, just change the fields
selected in the current report, e.g. this month I have selected June for my
report, but next month I want to be able to select July, but the drop downs
are inactive.

Please help. TIA,

Jarryd

 

[Debra Dalgleish]

You can't change or create a pivot table in a shared workbook, and
there's no setting you can change to make it operational.

Perhaps you could create the pivot table in a different workbook
(non-shared), based on the data in the shared workbook.

For more information on shared workbooks, look in Excel's Help, under
the topic 'Features that are unavailable in shared workbooks' or view
the list at the Microsoft site:

Features that are unavailable in shared workbooks
http://office.microsoft.com/en-ca/assistance/HP052010801033.aspx

 

[Jarryd]

Hi Debra,

I knew that the Reports couldn't be modified, but I thought you could still
use them as Pivot Tables, i.e. that the drop downs would still work so you
could change the data displayed. So basically you can't use a pivot table
AT ALL in a shared Excel workbook apart form looking at the results as they
were at the time of sharing. Is that correct?

TIA,

Jarryd

 

[Debra Dalgleish]

That's correct. If you could select a different item from a dropdown,
that would change the pivot table layout.