Hi Everyone,
I have seen very little documentation on this so maybe some Excel Gurus may be able to shed some light. I have one user who seems to consistently corrupt her excel workbooks saved on the mapped network drive. I have told her to do a couple of things to try to fix it:
– told her never to leave it open overnight incase the backups caused it
– removed all of the links to external spreadsheets
– confirm there were no macros within the spreadsheet
All of these things have been done and I even created a new excel file and copied all of the tabs across to a new spreadsheet. Even after that, once again the file says that it has become corrupted when she goes to open it and it tries to recover the corrupted data. The logs that it spits out doesn’t really mean much to me so I am not too sure what other things could be causing this.
The file is moderately large, and pretty important since it is her financial workbook. Every month she adds to it, and when I suggested that we should maybe look into recreating it, I was told that was too much work (40 hrs) and that she would quit instead… and I’m not really looking to get into a fight with our senior accountant.
So does anyone have any suggestions on what might be causing this to happen? Or things I should try to do? I read one post where it mentioned it might be a good idea to recreate the /app data/ folder for excel or office by just renaming the current one and letting try to recreate it, is there anything else anyone can think of that could be causing files to get corrupted?
Thanks!
Jeff
