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?
Thanks for weighing in Richard.
We have the entire site colleciton set as Local Intranet for all users. So that should not be the problem when other users can save Excel files back to this library, but this one user cannot. Verified that her settings were the same as mine (I can save to the library).
Am certain that the issue is with Excel and will require a repair to MS Office on the user’s machine. Due to spring break, that just hasn’t happened yet.
Seen this in many cases over the years and haven’t managed to focus on it. I believe it is related to whether or not the site is trusted or in intranet. Try adding it to “Trusted Sites” possibly. This is probably something that should be done through active directory rather than an individual basis.
The problem isn’t opening vs. downloading the document. The issue is that Excel is not saving the document back to SharePoint for the user, but it is saving it for Robin.
Also, it’s generally not recommended to set the entire web application to Permissive. Instead, you should add the appropriate MIME type for the document to allow SharePoint to open it in the browser. A script to add a MIME type can be found at this link: http://howtosharepoint.blogspot.com/2011/04/open-pdf-files-in-browser.html
- Central Admin > Application Management > Manage Web Applications
- Single-click the row of your web application
- Click General Settings in the ribbon
- Scroll down to Browser File Handling and change Permissive to Strict
Thanks Paul. I’m thinking that it’s something with her Excel install. From what I was able to find out from the tech on my campus, not all campuses are installing things exactly the same way. (No wonder I get weird calls/emails).
I’m also wondering if they actually removed Office 2010 before installing Office 2013. I’ve seen weird stuff left behind when they don’t. and strange issues caused by the older Office version files left behind.
