excel2013 pivot table can't auto refresh pivot table detail sheet

[Neil_Wang1002]

i've tried to simply show my question as below step by step.

The new sheet data that was click and generated from pivot table, is it ok to synchonize with original table?

[#2]

@Neil_Wang1002 That is by design. Double clicking on a cell in a pivot table will create a one-time snap shout of the underlying data. You indeed need to repeat the process if the data source changed.

[#3]

Hi, master Riny, may I ask is it only excel 2013 can't do, or either office 365 can't?

[#4 · Accepted solution]

@Neil_Wang1002 Neither can do this. It has always been like that.