I work in a research lab and we use an Excel file to enter data. The file is saved on a server that multiple people access from different locations. Usually if someone else has it open, it will only open in read-only. Lately, if a second person tries to open it, a message pops up that says "Alert. We found a problem with some content in 'file name.xlsx.' Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes." If you click Yes, another pop says "Alert. The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt." At some point (we haven't been able to determine when, as it doesn't seem to be predictable) an empty folder is created, that has the same name as the Excel file but with a string of varying letters and numbers after it. Multiple empty folders like this are created every day. Some examples of the string of letters and numbers are as follows, notice that the first 12 characters repeat:
xlsx.sb-388634f5-whyS2F
xlsx.sb-388634f5-h0hqXF
xlsx.sb-388634f5-GUudM6
xlsx.sb-388634f5-hBFtWk
xlsx.sb-388634f5-rkVL5q
xlsx.sb-30dc7262-36Lomy
xlsx.sb-30dc7262-1I4KOA
xlsx.sb-30dc7262-BzfXuT
xlsx.sb-30dc7262-ZqrDyE
It seems like in general the first 12 characters of each string is the same if the folders were created on the same day, but definitely not always. Sometimes the string is the same over several days, or there are random other strings in the middle of the group of a different string. Any help is greatly appreciated!!
Solved by X. Q. in 14 mins