I would like a Pivot Table and Chart to refresh automatically when the source data has changed. I have tried some VBA codes that were posted on the internet but they made Excel crash.

Any suggestions? Look forward to your input.