Within Excel 2010, press “Ctrl-Alt-Shift-F9”  to force a full calculation.  In cases whereby “F9” or “Shift-F9” do not work,  saving the sheet into the newer “XLSX” format and forcing the calc will usually do the trick.

This integration is supported by Infor. Questions regarding resources, functionality, or troubleshooting with the F9 solution can be directed to Infor Support.