Auto refresh pivot table with linked data

I don't understand.

Your sample shows that when you update the source table the pivot table updates.

What else do want it to do?

Hi
I update the number in Sheet2 E1 which link to Sheet1 C2

If I manually enter the number in Sheet1 C2, the pivot table refresh automasticlly.

But now Sheet1 C2 link to Sheet2 E1 and the pivot table does not refresh automasticlly.

How can I refresh the pivot table automasticlly with linked formula.

Thanks

Originally Posted by kersplash

I don't understand.

Your sample shows that when you update the source table the pivot table updates.

What else do want it to do?

Pls see my reply

Try the attached. Moved the cell you are changing to it's own sheet then put the macro within that sheet.

Do you mean I cann't have the number into the same sheet with the pivot table?

If you have it on the same sheet then it will keep triggering the Worksheet_Change event.

There may be another solution where you could keep it on the same sheet.