Hi

I have a pivot which is feeding another part of my spreadsheet but for this to happen correctly the pivot needs to have "Repeat all item labels" selected in the report layout. Sometimes when I open the file or if I manipulate the pivot (for example playing with the filters) the pivot resets to NOT repeating all item labels.

Is there a way to stop this from re-setting?

Many thanks in advance.

Tom