I get this question a lot and I just got it again. Is there a way to export a financial statement to Excel without any hidden rows - only what appears on the screen?

I seem to remember that there was, but I can't find it right now. I also seem to remember that it exported as Values Only, no formulas in the Total row.

Thanks

Steve

In the Financial Reporter select View | Customize | Settings | Exports and enable "Values only".

Can you tell me if that setting is by user, by workstation, and/or by dataset?

Thanks

Steve

Hi
Is there a similar thing for the general ledger and other modules (at the moment, payables comes to mind)?

I've found the exporting to excel since the upgrade includes all sorts of hidden rows and merged cells.

For example, in payables, I save the list of the outstanding cheques we've just written as an excel file, so that I can incorporate them into a spreadsheet we use for a bank reconciliation. I used to be able to simply rearrange the columns and cut and paste what I needed - 30 seconds and I was done. Now I have to unmerge cells, sort the data to separate data from blank crap, delete blank rows and columns, and then re-sort lines and columns to get what I need. It's turned into a multi-minute exercise.

Marc

I'm just reading the general inquiries forum and see a solution I will try.
Marc

Hi Steve,

I lookedup the reply and forgot to post it.

The setting is stored by windows user | workstation (in the Registry).

Hi Marc,

Then you'll be pleased to see an ExcelDirect button on the check reconciliation screen in Adagio Payables 9.2A!

Hi Andrew

At the risk of being greedy, an ExcelDirect button on the check rec screen isn't very useful unless there is also a way to filter what displays and can be sent to Excel. Most importantly, by status, including pending status. I hope that is coming soon.

Steve

Hi Steve,

I'm looking at the check rec in AP 9.2A and the excel direct sends all fields selected in the column editor including status.

See Dan's answer.

One of the reasons we send to Excel as a Table is because of its excellent filtering capabilities.