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.