Question Re: Automatic Calculation or Refresh of Data in Excel in Supply Chain Management Q&A https://community.sap.com/t5/supply-chain-management-q-a/automatic-calculation-or-refresh-of-data-in-excel/qaa-p/11839546#M166025 <HTML><HEAD></HEAD><BODY><P>Hi Ryan,</P><P></P><P>You can use 'simulate' button which is available next to save to locally simulate the changes done in input key figures and see the impact on calculated kf.</P><P>After this you can save the data,if satisfied with the result. Else refresh the planning view to get back the original value.</P><P></P><P>Thanks,</P><P>Rohit</P></BODY></HTML> Fri, 09 Sep 2016 19:17:13 GMT former_member242371 2016-09-09T19:17:13Z Automatic Calculation or Refresh of Data in Excel https://community.sap.com/t5/supply-chain-management-q-a/automatic-calculation-or-refresh-of-data-in-excel/qaq-p/11839545 <HTML><HEAD></HEAD><BODY><P>Currently I have to save data in Excel to see changes to a calculated key figures update.</P><P></P><P>Let's say I have several manual forecast input key figures that are configured to calculate into a Total Forecast key figure.&nbsp; As the users are typing and hitting "Enter" or tabbing to the next period or combination I want to see the Total Forecast key figure automatically update real time without having to first hit Save Data.</P><P></P><P>Where do set this to occur automatically, or what are the steps if configured in multiple places (i.e. IBP and/or Excel template).</P></BODY></HTML> Fri, 09 Sep 2016 18:53:33 GMT https://community.sap.com/t5/supply-chain-management-q-a/automatic-calculation-or-refresh-of-data-in-excel/qaq-p/11839545 ryanjrickard 2016-09-09T18:53:33Z Re: Automatic Calculation or Refresh of Data in Excel https://community.sap.com/t5/supply-chain-management-q-a/automatic-calculation-or-refresh-of-data-in-excel/qaa-p/11839546#M166025 <HTML><HEAD></HEAD><BODY><P>Hi Ryan,</P><P></P><P>You can use 'simulate' button which is available next to save to locally simulate the changes done in input key figures and see the impact on calculated kf.</P><P>After this you can save the data,if satisfied with the result. Else refresh the planning view to get back the original value.</P><P></P><P>Thanks,</P><P>Rohit</P></BODY></HTML> Fri, 09 Sep 2016 19:17:13 GMT https://community.sap.com/t5/supply-chain-management-q-a/automatic-calculation-or-refresh-of-data-in-excel/qaa-p/11839546#M166025 former_member242371 2016-09-09T19:17:13Z