Forum Discussion
Refresh, recalc dynamic functions when file is opened.
Hi,
I have a problem with some dynamic functions, diagram that does recalculate when a file is openede rith new data.
The document has 3 sheets
- One datatable
- one for a dynamic report based on selecetions.
- One for a report/dahsboard with diagram and selections.
It works perfect. But not when its opened with new data in the datatable. Then the dynamic report/diagram only show the first line in the the dynamic report/diagram. Until we:
- Make a selection from the drop down menue, or
- click on the diagram.
Is it possible to force Excel to update, without doing any of the 2 options above?
Best Regards
- Geir
Pictures:
- Is there a way you might share your workbook (anonymized of course) with us?
- I can not share this one, because of the data. And it is also working now, since I Have done the "change report" from the dropdown menue. It works perfect until the data table is generated again next month, from an PLS system automatically. Then it only shows the first row. Until "action" is taken.
- Does it also work to press the F9 function key while holding down Control+Alt+Shift?
