CAFE Cognos - How to ... Convert to Formulas on This Sheet ?

[Leith]

Hello,

I import data from Cognos into Excell in the form of columns. When I do calculations on the columns, and referesh the data the next day, the new calculations diappear. I tried clicking the "convert to formulas on this sheet" but it is greyed out.

Do you have any ideas for how to activate it? and save the newly created formulas?

Thanks

[gshilpa24]

Why do you have to do the calculations the next day? Do all your calculations at the report level and run in excel format.