Exported Excel file - Displaying excel formula results

Tue, 17 Apr 2012 13:25:28 GMT

Hello,

I have some troubles with exported excel files.

I am exporting results into an excel file. At this point I want to add excel formula inside but Excel displays the formula not the result.

Of course I checked tools->options->Formula->automatic but nothing change.

Did Qlikview desactivate something in Excel when exporting into it ?

Many thanks in advance for your answers.

Kind regards

Gilles

Exported Excel file - Displaying excel formula results

hallquist_nate — Tue, 17 Apr 2012 16:13:21 GMT

Try reformatting the excel column to something other than what it is currently. I have seen this issue before and I think it has to do with the format of column being such that everything in the cell is text.

topic Exported Excel file - Displaying excel formula results in QlikView

Exported Excel file - Displaying excel formula results

Exported Excel file - Displaying excel formula results