d/epm Excel Integration refinement

Mike Potashnick

I have been exercising Excel Integration and have a couple of observations about the current state of the delivery.

On the positive side, it is really much improved and these comments are designed to help it get even better.

Although it is good that the continual relogging on has gone, the continual closure of the task pane bar is a real issue when you are using the report INFOR.WRITE mode. 

Whenever you want to recalculate the sheet, you have to go to home, reopen the task pane and press recalculate the sheet.

There needs to be an auto recalc mode or a recalc button surfaced somewhere else in Excel to allow this function to be a single click.

Thanks

Mike

Vit Holy

Hello Mike,

Thanks for the feedback! Yes, we are aware of this and in one of the future releases we will introduce our own ribbon tab with the navigation and recalculation will be one of the improvements in there.

Part of that will be also introduction of custom shortcut keys, so you will be able to call e.g. Recalc Sheet, etc.

Unfortunately, the custom functions behavior is not 'well-designed' from our POV and we have still ongoing discussion with Microsoft because when we used volatile functions, those were recalculated whenever rendering was happening (i.e. when you changed format, it recalculated all the volatile functions when Automatic calculation mode was enabled). And based on customers feedback we decided to rework this and remove volatility.

However, as a temporary workaround you can use Ctrl+Alt+Shift+F9 shortcut (native functionality of Excel) ... but be aware it triggers full rebuild of formula dependency tree and force recalculation of all workbooks, therefore it can be slow.

Hope it helps!

Vit