Using Microsoft Excel Solver with Xcelsius

[Former Member]

Hi Everyone,

Does anyone know if Solver (Excel add-in) is supposed to work with Xcelsius? I tried the following -

1. I wrote a VBA code in an excel sheet that runs Solver for me upon cell value change in cell (1,1)

2. Imported the same excel sheet in to Xcelsius and placed a checkbox to change value in (1,1) to 1 when checked.

The solver runs outside of Xcelsius, but when imported in to Xcelsius it does not function in .swf mode but runs with errors in Xcelsius workspace (edit mode). Any thoughts?

I use Xcelsius 2008 SP1 w FP3 and Excel 2003

Regards,

Pranav

[Former Member]

Hi Pranav

Unfortunately Xcelsius does not support any VBA code.

Hope this helps

[Charles|http://www.reportex.co.uk/xc_waterfallchart.html]

[Former Member]

Thank you Charles for answering promptly.

I just wanted to explain the situation once more to be sure I understand your answer correctly. I created an new workbook with VBA code to run solver upon change of value in a particular cell. Then I imported the workbook in to Xcelsius and created labels to represent solution. I also created a check box to change the value of the trigger cell...and when i preview..it does not run. Even though it runs in the non-preview mode or workspace.

I am sure you would come back and still give the same answer..but isn't there any way to do this? I wish to create scenarios where user inputs values in the dashboard and checks the box to force excel to solve the problem. And when it is done that..Xcelsius represents the new solution on the dashboard.

Is that not possible at all?

Pranav

[Former Member]

Hi

It's not possible to use any VBA when previewing the Xcelsius file. The VBA when in Design mode may still work though.

You will need to find an alternative non-VBA solution, perhaps use more complex Excel formulae to solve your equations.

Regards

Charles