I have an Excel 2013 workbook with an external data source (CSV file) which is mapped to a worksheet and then used as a source for a chart. The CSV file looks like this:
DateTime;Burndown
2013-10-07 18:46:03;173
2013-10-08 07:46:09;173
2013-10-08 07:46:24;173
2013-10-08 08:19:05;168
2013-10-08 08:19:13;167
The CSV is created by an external process and the import and refresh works just fine. But when I save and close the file, each time I re-open it, Excel says:
"We found a problem with some content in 'Foo.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."
Okay, so several times a day I click Yes and the workbook is just fine. Burt when I want to re-save I need to specify the target directory again just like with "Save as...", because Excel thinks it has repaired the workbook. This is getting on
my nerves. How can I convince Excel to actually just normally load and save the workbook?
