Re: [ExcelDna] How to make Excel recalculate all ExcelDna functions when a worksheet is opened?
1,464 views
Skip to first unread message
Naju Mancheril
Mar 5, 2013, 2:24:06 PM3/5/13
to exce...@googlegroups.com
Option 1 is to force the user to refresh (using Ctrl+F9, I think... the most aggressive way to do this is to search and replace "=" with "=" ... that will rewrite and re-evaluate all formulas).
Option 2 is to make these functions into RTD functions. These are "reconnected" when a workbook is reopened.
Patrick O'Beirne
Mar 8, 2013, 4:15:42 AM3/8/13
to exce...@googlegroups.com
That's application.calculatefullrebuild
See decisionmodels.com for the details.
On 08/03/2013 08:52, DavidS wrote:
See decisionmodels.com for the details.
On 08/03/2013 08:52, DavidS wrote:
I found that Ctrl+Shift+Alt+F9 will cause Excel to re-evaluate all UDFs. I expect that this can also be done in code somehow.
--
zhenyu Chen
Jan 13, 2017, 5:15:27 PM1/13/17
to Excel-DNA
Excellent solution!
Reply all
Reply to author
Forward
0 new messages