To address this, call the AddIn method again to reconnect the add-in, and then call the CalculateFull method to recalculate the formulas in the spreadsheet. Using the XMLData or XMLUrl methods in script to load new values into the spreadsheet will disconnect the Analysis ToolPak function add-in.Spreadsheet1.Range('A1').Formula = '=ISEVEN(7)' ' Call the AddIn method to connect the add-in to the ' Instantiate the Analysis ToolPak function add-in. Set Spreadsheet1 = CreateObject('OWC11.Spreadsheet') ' Instantiate a Spreadsheet component object.

You can also instantiate the Analysis ToolPak function add-in and add formulas entirely from script as shown in the following example.For example, the following formula that uses the ISEVEN function to test whether a numeric value is an even number will return FALSE: Once you make these changes, you can use the Analysis ToolPak functions in formulas in your Spreadsheet component. Where Spreadsheet1 is the value of the ID attribute for the OBJECT tag for the Spreadsheet component on the page. Open the Web page file that contains a Spreadsheet component in a text editor or Web page editor.

To use the Analysis ToolPak functions, you must add two tags to the Web page that contains the Spreadsheet component to connect the Analysis ToolPak add-in. The Spreadsheet component supports an additional set of functions that provide the same functionality as the functions in the Analysis ToolPak add-in in Microsoft Excel. Previous page next page Use the Analysis ToolPak function add-in

How to add analysis toolpak to excel