When I am printing the Financials out of Adagio Financial Reporter and then exporting it out to Excel using the "To Excel Direct" option the headings come across, but not the data. Would you know why this is happening? I don't believe any worksheets, columns, rows, etc. are protected which would cause this.

There is a problem with formulae which contain == .

The solution is to restructure the formula. For example, you might change the following:

From: =IF(($A9==".Range"),"B"&MID(B9,3,5)&"B"&MID(B9,8,8),"B"&MID(B9,3,12))

To: =IF(($A9!=".Range"),"B"&MID(B9,3,12),"B"&MID(B9,3,5)&"B"&MID(B9,8,8))

I am having a similar problem.
I don't have any == formulae.

When I select "To Excel Direct", a new book opens and the tabe is renamed and that's it. No headings, no data.

What is wrong?

Hi bal,

Are there headers and/or footers in the statement. Some of the "$x" fields don't go across properly. Try removing them.

No headers. No footers.
What do you mean by "$x"?

Thanks.

No headers. No footers.
What do you mean by "$x" fields?

Thanks.

The headers and footers in the financial reporter support entries such a $P for the current page number, $C for the company name etc.