Data dissapears

[Former Member]

I have a 5 yr proforma income statement that operates on scenarios (base case, downside, upside). The formulas are vlookup, triggered by the case selected. I am trying to show this in a selector table disabling the selector function. In excelsius I can see all the values but in preview mode or exported the table will not show the vlookup cells, basically all of the 5 year go forward values. Any help on this would be much appreciated.

Thanks

Mark

[Former Member]

Hi Mark,

I can look at your file if you can share it with me.

Margaret

[Former Member]

Hi Micheal,

Check if you have used any dynamic visibility on any of the components.

This can be one reason why the cells disappears after preview.