Hi Roy - I have done this - I have copied and pasted the second code into the VB editor for the sheet which the pivots are on. This is the only data in there. When it is just in the sheet, then nothing happens, either when I just update the data, then move back to the sheet with the pivots on, nor when I close and reopen the spreadsheet.

I have also put it into the ThisWorkbook one. However, when I put it into the ThisWorkbook, then closed and reopened the spreadsheet, I got the following error:

Compile Error:
Sub or Function not defined

It stops at the row:
Private Sub Workbook_Open()

What am I doing wrong?

Thank you so much with your help so far - my brain and macros just don't seem to gel together!