This discussion is archived
1 Reply Latest reply: Mar 27, 2013 6:04 AM by cg RSS

HFM Report export to Excel changes cell category

cg Newbie
Currently Being Moderated
Greetings,
we just updgrated to version 11.1.2.2 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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points