Consistent file corruption with ODBC link. FMP to Excel 2011
I have a file in Excel Mac 2011 that links to a local filemaker 12 source via ODBC. The link produces a table in excel of some 7000 rows, 50 columns. This data is then summarized via a pivot tables in the same workbook.
The excel file is consistently becoming corrupted. It will work fine for a while, including data refreshes, and appears to save / open without problem. I am always careful to allow plenty of time for both data refreshes and saves. After closing the excel file more than a couple of times it will become damaged and on opening I get a message that "some content is unreadable, do you want to repair". On repairing, the file seems to work OK, and the log file will read:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>Repair Result to data8 07855.xml</logFileName><summary>Errors were detected in file 'Macintosh HD:Users:jw:Desktop:ODBC test:data8.xlsx'</summary><repairedRecords summary="Following is a list of repairs:"><repairedRecord>Repaired Records: Table from /xl/tables/table1.xml (List)</repairedRecord></repairedRecords></recoveryLog>
This doesn't really tell me that much, apart from the fact that Table1 (the table produced by the ODBC import) was damaged.
Further closing and opening of the same file will then always come up with the warning the "some content is unreadable" on opening. If I start from scratch again (new file, new ODBC table) the result repeats itself and the new file will become damaged after a couple of close / opens.
Anyone else experienced this? Any workaround?
Is this sort of problem likely to be in Excel, MSQuery, or Filemaker?
It may be worth noting that I have other similar links (between excel & FMP12 via ODBC) on the same computer that work ok, with no corruptions.
Many thanks in advance.