Pivot table source file error

Question

Using Microsoft 2013. Pivot table will not refresh getting error message: 'Cannot open PivotTable source file' [File name...] Data'. I've tried extensively to delete and re-paste the referred data in excel.  I've also tried to split the sheet given the large number of lines >77000 lines. 

I would appreciate any insight so I can resolve asap. Thank you in advance.

Answer 1

so what happened?  Is there an answer?

Answer 2

It is is difficult to say anything now without looking at your workbook.

Is it possible for you to upload your workbook to onedrive.live.com in a public folder and publish the link here? If your workbook contains confidential data, you can keep 2 - 3 rows only of data in such a fashion that error is replicated and remaining data you can delete. Also, you can change the data for rows kept so that confidentiality of your data is maintained.

Answer 3

Hi Vijay,

Thank you for your response. Pivot table sits within the same workbook and the paths have not changed.

Answer 4

Where is the source table residing? Is it on the same workbook or in a different workbook?

If in a different workbook, the workbook should reside in the same path where it was when pivot was created.