Forum Discussion
AutoSave leading to File contains corrupt data?
v-chuncz-msftToday I got the issue again. 3 binaries to be combined, all around 30 MB in size, slightly over 100k rows each.
Refresh failed because file contains corrupted data but now way to tell which one. I opened the three of them in Excel desktop from the SharePoint library, switched AutoSave off, saved them manually. After that, no more corrupted data. Let's see what comes next...
Hi there Beat,
I've been experiencing the same issue recently with a large Excel file in a SharePoint site. First time it happened I reloaded the file in the query editor all the way from the beginning and this seemed to fix it, but only for a week. The file is not as big as yours, less than 100k rows, but your suggestion of manually opening it on the desktop and saving seemed to have fixed the issue for now. Hopefully that does it but I'm a bit confused on what's going on in the first place.