title: VBA Prevent Charts from AutoUpdating in Excel
body: <p>I have a button to import data into my spreadsheet. I ported the calculated values for visuals outside of the dashboard range and plotted charts linking to those values. Whenever I import new data, those values change instantly as well as the charts. Is it possible to prevent the charts from automatically updating, and move that command to a macro?</p>
  
  <p>Thanks,</p>