Have a user who is having issues with an Excel spreadsheet in a document library. Every time she tries to open this spreadsheet, she is given a dialogue box to open or Save. If she opens, makes her changes, and saves the file, it’s saving it to the document download directory, not the SharePoint document library. she has to re-upload the file to the document library every time she updates a form.
I can go open the exact same file, make my change, and save it and the changes are automatically saved in the document library.
We are both running Office 2013. Both running Internet Explorer 10.
Has anyone else seen this issue and if so, how did you resolve it?
Robin, I’m grasping at straws here with a rough comparison for a similar issue.
The user was on Office 2010, IE11 and was constantly encountering issues with saving back to the doc library from where she opened the file. The work-around was to manual check out the file then open to edit, then save and check back in. The final cure was an upgrade to Office 2013 on her PC.
Other things to check would be if IE is set with the SP2013 site in trusted sites and compatibility view settings if available in that version of IE.
Is there a reason why your org is not using IE11?
Otherwise, good luck!
one thing i forgot to add … you mentioned her having 2010 – have you upgraded all of office or only excel? (including fringe Office products like Infopath/SP Designer cause issues) and then there is the .. have u restarted after updates/changes – most times people overlook that while having a session of IE or an instance of Office running.
Robin
check local Excel settings Options–>Save –> eyeball difference in settings – she likely has different settings from yours – hope that helps.
Verified settings with user… her Save settings are the same as my own. We were able, today, however, to select a location and choose the document library folder where she needed the document to go, which we didn’t get the option to do yesterday.
She has to open the file, save as to desktop then upload the file to the document library. Still don’t know why she doesn’t get the option to save to SharePoint, like I do.
?width=721
It is most probably related to excel settings on that local machine. Can you please verify the option when file opens from SharePoint where it is storing.
Also try to run the repair option for the office 2013 on the client machine. sometime this will trick to resolve the issues.