I am trying to export the G/L to excel and I get the error message Error: Data May be Lost. It only exports about a quarter of the data. How do I fix this?

Perhaps you have more than 65535 rows of data?

What are you trying to get to Excel? Transactions or a Trial Balance? It is often easier to use the financial reporter to get this kind of data out to Excel.

If your accountant is looking for the data in Excel format to retrieve into Caseware, then let them know that Caseware is capable of directly retrieving your Adagio data.

How are you exporting data? From a report, or the Export Accounts function, or an Excel Direct smartfinder?

If you are using an Export functions such as Accounts or Batches, you may get the 'error - data may be lost' if you have Excel 2007 because the created exported Excel file is a low-version file (so we don't prevent people with older versions of Office to use the function). There should not be any loss of data, unless there are more than 65535 records as mentioned above.

Hi Deedee

I have a number of clients who get this message, and many others who don't. I've never been able to figure out a reason.

In all cases I've seen, the only data that is lost is the first column. Usually (at least in the case of GL) this is not a very important column. So my clients live with it.

The fact was is that there was more that 65000 entries and I wasn't operating a current enough version of Excel. Many thanks for the help.

Deedee:

You could export the GL in logical sections like: Assets, Liabilities & Equity, Revenues, Expenses.

it doesn't matter what module i export to, if i am using Excel 2007, i always get that error message.

That's an Excel thing because of the 'version' of the Excel file that Adagio exports to. Typically nothing is lost and you can ignore it - I haven't run across a scenario that data was lost unless more that 65000 rows were meant to be exported.

What are you trying to get to Excel? Transactions or a Trial Balance? It is often easier to use the financial reporter to get this kind of data out to Excel.

This error message has been in existence for years (well okay in recent memory which is preatty good):)

Adagio exports to Excel v2.x (or some very old version of Excel). When Excel opens the file it no longer support this version and that is the error message it displays. Not sure what might be lost, I've never found anything missing.

This version of Excel has a record limitation (16,000 I think). If you export more records then these are lost. The solution is to either use GridView (hich uses a current version of Excel) or to do the exports in logical chunks as Ralph suggests.