I have a strange problem. I do feel the need to give you all a background of what is wrong and what i have attempted to do.
Firstly a user has reported that when she opens a shared spreadsheet on a network drive it crashes and displays this error "A problem caused the program to stop working correctly" and then it closes or you have to force it close. The whole office runs windows 7 and office 2013. All other users access the file fine. She used to be able to access the file.
My first troubleshooting steps:
1) Installed updates for PC and also office 2013
2)started the file via excel.exe /safe but the same error returned.
3) No add ins seem to be causing the issue
4) Turned of AV and tried opening the file but still no luck
5) started pc via a selective startup
6) repaired office
7) re installed office still no luck.
Then i thought it may be profile related. I logged in as my self and started the file and it worked! I then logged on as the user on my PC and it did not. So i thought i nailed it and created a brand new profile and transferred everything across. Then i tried again and the problem remained.
I then thought about and i copied the file and removed the shared access under the review tab at the top of the excel file and unticked allow sharing and saved. The user can now open the file. I put the sharing back on and the error appears.
I was thinking of just copying the spreadsheet to a new one and applying sharing but the spreadsheet is huge with lots of formatting and formulas and it would not look identical if i tried. I always hated this file.
Please help me work out why the user can not open the spreadsheet while it is shared and how can i repair that.
Thank you in advance.