Skip to Content
0
Former Member
May 09, 2008 at 09:33 AM

Help: Acordion Doesn't Work with Formulas

23 Views

I am having some difficulty getting the Accordion menu to work properly. I have an accordion component that does successfully send data to a cell in my excel model. However, I want to perform functions based on the results of that insertion, but it does not appear to work.

My excel logic is a column of labels for the accordion menu next to a column of source values numbered 1 through n. The accordion pulls a value and inputs it into cell C2. Then there is a third column to display a binary value to drive dynamic visibility. This column has a simple formula of =IF(C2=[value in the corresponding row],1,0). However, when I preview, the accordion does insert into C2, but the binary formulas do not change accordingly

Conversely, when I use a list box with the exact same cells, values, and formulas it does work properly. My only conclusion is that somehow the accordion menu inserts are not triggering the formulas to update properly.

I have attached a simple Xcelsius file that illustrates the issue. If you have any solutions, I am all ears!