We have approximately 5-10 users who share an excel workbook on a shared folder. Recently, the workbook started to become unstable and it will freeze and then will be removed from the shared folder leaving behind 2 temp files.
With my understanding of shared excel workbooks, these temp files are being used to update the file. But what has boggled my mind is why the actual excel file disappears. Users will still have the workbook open but they are unable to edit the file and save it.
These users are running Excel 2007 and 2010. Both x32 and x64. Everyone is on Windows 7.
The excel workbook has 11 frozen panes and 1100+ rows.
Could anyone point me in the direction to help troubleshoot this issue? Our longterm solution is to use SharePoint 2010 but I'd like to at least get this problem resolved while I put up a SharePoint site.