"Problem with content" everytime I open a workbook RRS feed

  • Frage

  • 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:

    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?

    Dienstag, 8. Oktober 2013 07:17