I'd definitely encourage you to contact the vendor though, to see if this is expected before or not. I just offer it as a possible solution if there is no workaround any other Unless critical though, I'm not sure I'd want to go there as it could be dififcult to maintain and could slow down your workbook to a massive degree depending on how big it is. The key to this is that you would need to create a list of users that either had the option to calculate or not, and take that into account when firing the past routine. 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.

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).

Permantly disable links in excel