1 Reply Latest reply on Mar 27, 2013 1:04 PM by cg

    HFM Report export to Excel changes cell category

      we just updgrated to version and are noticing some strange behavior coming out of an some HFM reports we are exporting to Excel.

      We are trying to sum up some values and are getting #VALUE!. We have to manually change the category settings of all columns in order to enable any Excel formulas. This occurs when values are "-".

      We can manually change Excel to reflect the cells to be numbers but there are a lot of reports to change, and on top of this, the prior version of HFM/Reports did not display that issue.

      Pls let me know how to resolve this issue.. Many thanks.