Solutions - Can't open pivot table source file excel 2019 [filename.xlsx]Sheetname or 2013.

 After searching on google and reading so many articles I didn't get any proper solutions to the problem:

"Can't open pivot table source file excel 2019 [filename.xlsx]2013"

OR

"Can't open pivot table source file excel 2019 [filename.xlsx]Sheetname"

I have found a solution at a Stackoverflow posts:

1. Opened the file with the corrupted path
2. Open the file that the corrupted workbook is referencing

    3. Click OK

    4. Move (don't copy) the datasheets from the file that the corrupted pivot tables are referencing into the corrupted file. Now your pivot tables should be referencing only sheets within the workbook.

    5. Create a blank sheet in the formerly corrupted file

    6. Move (not copy) all sheets except for the blank one created before to a new workbook.

    7. Save locally to your machine.

    8. Upload to your desired location.

Source: https://stackoverflow.com/questions/29545080/excel-pivot-table-data-source-after-file-name-change-refers-to-previous-file-na