Can't Refresh Pivot Table When Using External Data Source

Hi! I am using an Excel file (Raw.xlsx) to store my raw data, and take another Excel file (Pivot.xlsx) to make PivotTable from Raw.xlsx
When generating the PivotTable, every works fine. When click [Refresh] in the Raw.xlsx, whatever changes been made in the Raw.xlsx can "sync" to the Pivot.xlsx

However, once I save and reopen the Pivot.xlsx, I can't refresh the PivotTable anymore. I've tried changing Data Source, but it doesn't work. Can anyone help me on this? Thank you very much!!

Hi,

Please try the following and see if it works:

1. Right click on the Pivot Table
2. Pivot T'able Options
3. Select "Data Tab"
4. Select the tick mark "Refresh data when opening the file"



Regards,
Chandra


Please click on '* Add Reputation' if this was helpful in resolving the issue.