The comments contents were pasted back into the cells as formulas to allow recalc.
You would also then need to make sure that every time the workbook was activated that Paste the formulas as values to avoid it updating.Write any formula containing a Futuresource function to a comment.If you're not using comments for anything in your workbook, and this is absolutley critical, you could put in a workaround to do the following:Įvery time the workbook is saved, you could Neither one is really going to be a workable solution long term. The real rub is that removing the addin would probably give you #NAME? errors, and they may be no way to stop the recalc short of doing that or pasting the formulas as values first.
How to turn off excel automatic recalculation update#
It may never have occured to the developers that someone wouldn't want to automatically update their numbers, so they may have ignored that check. I suspect that Futuresource Workstation may be working similarly. Disabling macros, however, would stop the recalc. So in my case, disabling linksĬompletely would have no effect whatsoever. Instead, the standard calculation triggers are what fire my UDF's to recalculate. When creating the UDF's, I never put in any effort to checking if the application was set to prompt users for updates on their links. So my worksheets now contain my custom functions like =GLDATA(x,y,z) In layman's terms, I programmed my own functions to use in the Excel grid. When I built the addin I mentioned above, I programmed several user defined functions (UDFs).
0 kommentar(er)
