Pivot Table Hell

[Book Wormeo]

Hi team,

So I made a great new spreadsheet, and after testing etc. I moved it to the work drive, and low and behold, none of my pivot tables will update!

When I select 'Change Source' it only lets me adjust the file name, not the file path. The pivots only refer to information on other tabs within the workbook so I'm a little confused as to why these need the whole file path (and if so why it won't update dynamically).

Does anyone know the best way to fix this for excel 2013, Or do I need to remake all the pivots?

Thanks in advance,
Book Wormeo