Spreadsheet with track changes and pivot tables

[Henrik Andresen]

Hi.
I have a problem that i am unable to solve.
I have a spreadsheet with several sheets in it, one sheet is a standard data
sheet with text and numbers and the rest of the sheets are pivot tables.
My problem is that i want to enable the feature Track Changes on the sheet
with the text and number data, but when i do this the rest of the sheets that
are pivot tables gets disabled. When i enable the track changes feature in
the spreadsheet i get a question about saving the spreadsheet as a shared
workbook, when i choose yes here all the pivot tables gets disabled.
So, is there any way to have a spreadsheet with several sheets that are
pivot tables and one sheet with data in it to have track changes enabled on
it? (The sheet that i want to enable track changes on is not a pivot table)

Sincerely
Henrik Andresen

 

[Bob Greenblatt]

Hi.
I have a problem that i am unable to solve.
I have a spreadsheet with several sheets in it, one sheet is a standard data
sheet with text and numbers and the rest of the sheets are pivot tables.
My problem is that i want to enable the feature Track Changes on the sheet
with the text and number data, but when i do this the rest of the sheets that
are pivot tables gets disabled. When i enable the track changes feature in
the spreadsheet i get a question about saving the spreadsheet as a shared
workbook, when i choose yes here all the pivot tables gets disabled.
So, is there any way to have a spreadsheet with several sheets that are
pivot tables and one sheet with data in it to have track changes enabled on
it? (The sheet that i want to enable track changes on is not a pivot table)

Sincerely
Henrik Andresen

Sorry, but it does not look possible. Tracking changes turns on workbook
sharing which turns off the ability to modify a pivot table. You may be able
to accomplish what you want using 2 workbooks. One containing only the
source data which will be shared and tracking changes, and the other with
the pivot tables. This second workbook should have a data sheet linked to
the original source data.