Pivot table paths changed as I changed filename and folder

The paths changed to absolute on its own which I find very odd and I can not find a solution for this anywhere.

I have done this kind of files lots of types and with this one everytime I change folder or change name it keeps the original file as a path which is very problematic as there are lots of pivot tables and all I need is to copy paste data and refresh all tables (which obviously no longer work).

Any suggestion is welcome! File is attached. Thanks.