https://community.sap.com/t5/technology-q-a/afo-workbook-refresh-issue/qaa-p/12245864#M4585467 <P>Hi Gabriele,</P><P>why do you think this is an issue? Changing a cell value in an input-ready query and then calling some command with implicitly trigger a 'Recalculate'; so if nothing is wrong with the changed value the value is send to the planning buffer and 'refresh' will simply re-read the most recent data from the buffer.</P><P>Why is this behavior reasonable? </P><P>After changing a cell value and the pressing a button to execute a planning function you don't want to execute 'Recalculate' first; the same is true if you change the query view, e.g. drill-down an additional characteristic in the rows etc. </P><P>So refresh just follows this general rule.</P><P>Regards,</P><P>Gregor</P> Wed, 02 Dec 2020 15:12:38 GMT gregor_dieckmann 2020-12-02T15:12:38Z https://community.sap.com/t5/technology-q-a/afo-workbook-refresh-issue/qaq-p/12245862 <P>Hi,</P> <P>I am facing an issue refreshing an AFO Workbook based on an input-ready query.<BR /> When I change a value in a cell without save it and then I refresh the workbook (Refresh Prompt or “Refresh All” button), I continue to see the new entered value in the cell, although it was not saved. If I close and open again the workbook, the cell shows me the correct value. The refreshing issue happens only if the Workbook is based on input-ready query.</P> <P> Can anyone help me on how refresh correctly the Workbook?</P> <P>Thanks.</P> Wed, 02 Dec 2020 13:14:52 GMT https://community.sap.com/t5/technology-q-a/afo-workbook-refresh-issue/qaq-p/12245862 former_member536751 2020-12-02T13:14:52Z https://community.sap.com/t5/technology-q-a/afo-workbook-refresh-issue/qaa-p/12245863#M4585466 <P>What version of AFO you are using and what is the backend system?<BR /><BR />Thanks,</P><P>Debjit</P> Wed, 02 Dec 2020 13:22:36 GMT https://community.sap.com/t5/technology-q-a/afo-workbook-refresh-issue/qaa-p/12245863#M4585466 DebjitSingha 2020-12-02T13:22:36Z https://community.sap.com/t5/technology-q-a/afo-workbook-refresh-issue/qaa-p/12245864#M4585467 <P>Hi Gabriele,</P><P>why do you think this is an issue? Changing a cell value in an input-ready query and then calling some command with implicitly trigger a 'Recalculate'; so if nothing is wrong with the changed value the value is send to the planning buffer and 'refresh' will simply re-read the most recent data from the buffer.</P><P>Why is this behavior reasonable? </P><P>After changing a cell value and the pressing a button to execute a planning function you don't want to execute 'Recalculate' first; the same is true if you change the query view, e.g. drill-down an additional characteristic in the rows etc. </P><P>So refresh just follows this general rule.</P><P>Regards,</P><P>Gregor</P> Wed, 02 Dec 2020 15:12:38 GMT https://community.sap.com/t5/technology-q-a/afo-workbook-refresh-issue/qaa-p/12245864#M4585467 gregor_dieckmann 2020-12-02T15:12:38Z