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 ba...
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?
- Probably, but the goal is to avoid manuel opertations when the report is opened.
- Perhaps it helps to add 0*TODAY() to some strategic cell's formula (preferably a cell on which the charts (indirectly) depends?