08-18-2009, 12:47 PM
Yes, it works with simple formulas just fine.
What I am finding is that for some reason when QM initializes the app it does not load the Add-ins.
NETWORKDAYS is part of the Analysis ToolPak which doesn't seem to be loading through the QM Excel.Application app._create.
When I set visibility to TRUE, the program stays open after the error.
If I choose Tools->Add-ins then disable Analysis ToolPak, then re-enable Analysis ToolPak, and then go to edit one of the error'd cells, everything goes back to normal. If I do not disable and re-enable Analysis ToolPak...nothing works to fix it.
Is it possibly something in the way QM calls for the Excel application to run?
What I am finding is that for some reason when QM initializes the app it does not load the Add-ins.
NETWORKDAYS is part of the Analysis ToolPak which doesn't seem to be loading through the QM Excel.Application app._create.
When I set visibility to TRUE, the program stays open after the error.
If I choose Tools->Add-ins then disable Analysis ToolPak, then re-enable Analysis ToolPak, and then go to edit one of the error'd cells, everything goes back to normal. If I do not disable and re-enable Analysis ToolPak...nothing works to fix it.
Is it possibly something in the way QM calls for the Excel application to run?