Hello,

I'm using Adagio Ledger 9.0B. This is a new issue since recently moving to Excel 2007. When I hit the excel button in Adagio Ledger to export data to an excel sheet I end up with a table in Excel 2007. Sometimes I don't want a table. Is there a way to turn this off?

Thanks.

Sorry no, but you can copy the data in Excel to another sheet and remove the table attributes.

"Sometimes" is a problem. We decided that, in the majority of cases, tables provide more advantages than disadvantages.

Could you give me an example of where having the data in a table is a problem?

Yes, I can give you examples. I transfered the GL balances (from View) to a spreadsheet. I pick a cell in the column beside the balance column and hit sum to add together certain cells, such as all the revenue and expense accounts. A new column pops up and it doesn't like the formula. I realize I can click the down arrow and tell it to stop but it's another step. If I do copy it, how do I remove the table attributes?

Another example, I use this function to cut and paste into my Word reports. I don't want shaded numbers, all I want is the data, so I have to reset the table to no colors. Again not a big deal but another step compared to the straight transfer in excel 2003.

Instead of picking a cell immediately adjacent to the table, leave a blank column for your auto sum. Alternatively, after entering the auto sum and generating all the #ref errors in the cells above and below, then press ctrl-z to get the one formula you need. You can clear the table formatting with a single mouse click on the home tab (Clear Formatting). You can create a default style for tables with no banding or header/footer highlighting and make it the default style using "Format as table | New Table Style". You can also remove all the table attributes (the column filters and total rows) by right mouse clicking in the table and selecting "Table | Convert to range".

In Word, you can "Paste special" to paste the plain text rather than the formatted rows (although I like the shading in the document). I'd recommend removing the formatting in Excel before the copy though as the operation is faster.

Because you only "sometimes" want the table attributes, and tables allow instant filtering and summing of values, as well as two click generation of bar and pie charts from the data, we still consider that overall they're a benefit.

PS - Of course, if you continue to run Excel 2003, then we don't generate tables. <g>

Andrew:

How did you come to the conclusion that a table had more advantages than disadvantages? Everytime I export to Excel I have to copy and paste the data into a new worksheet in order to get away from the table.

Auto filtering (I want to see all the checks written to Bill), pivot charts, nice formatting...

Here's a macro that clears the the table style:

Andrew:

Thanks for the code. Any ideas on how to get it to automatically run everytime you export from Adagio?

Place it in your macros workbook and attach it to a keypress or button.

Andrew:

Thanks, sometimes the simplest things escape us non-techies.