Keep in touch and stay productive with Teams and Officeeven when you're working remotely. Managing files and folders can often be easier when you work outside SharePoint, using Open with Explorer, but rather than use the Open with Explorer command, a better option is to sync your SharePoint files or move or copy files in SharePoint. With Open with Explorer File Exploreryou can copy and move multiple files and folders between folder as you would on your desktop.
Once you're done with File Explorer, you can then use any supported browser with SharePoint.
Not using a browser that supports ActiveX controls. Open with Explorer works only in Internet Explorer 10 or For Windows 10, Edge is the default, but Internet Explorer 11 is also installed.
You can use Internet Explorer to do your file transfers, and then go back to using your preferred browser if not IE. Internet Explorer has ActiveX controls or Add-ons are blocked. You're using bit version of Internet Explorer. ActiveX controls are a bit only technology. They don't run in the bit version of Internet Explorer. In Internet Explorer 11, there is only one browser and it automatically switches to bit for ActiveX controls.
However, if you're using the bit Internet Explorer 10, switch to the bit version. The SharePoint add-ons aren't installed. You should have these add-ons installed and enabled:. By default, it's on and running in Windows.
If it isn't running, you may have problems using Open with Explorer. The WebClient is part of Internet Explorer. To check the WebClient, follow these steps. In the Services dialog, find WebClient. If you can't find it, click Name to sort the list alphabetically.
Check under Status to make sure it say's Running. If not, right-click WebClientand select Start. Only the latest or published versions of documents are copied or moved.
For more info, see Why doesn't sync or Open with Explorer copy or move my versioning info? File Explorer is the Windows file management system you use on the desktop. You can open SharePoint libraries in File Explorer, and move or copy files and folders from your desktop folders to SharePoint.
You can also open multiple SharePoint libraries in File Explorer, and copy or move between folders between them. For more info, see Set up a library to require check-out of files. In SharePoint, open the document library with the file or folders you want to move or copy. You can ignore or close this library window. You may get a pop-up asking if you'd rather sync the library. This is up to you. When you open a library in File Explorer, the folder on your desktop is temporary.
If you use sync, you'll get a persistent folder that stays in sync with the document library.Keep in touch and stay productive with Teams and Officeeven when you're working remotely.
Open in Explorer or View with File Explorer in SharePoint
Learn More. Learn how to collaborate with Office Tech support scams are an industry-wide issue where scammers trick you into paying for unnecessary technical support services.
You can help protect yourself from scammers by verifying that the contact is a Microsoft Agent or Microsoft Employee and that the phone number is an official Microsoft global customer service number. If I open Excel and open a document residing at the following URL and save changes etc and go back into it is saved.
When I actually open the document from sharepoint it is in fact updated. However, the document in my synced files on my computer is not updated. It is as if sharepoint is not registered the update going via the office app directly i. From your description, there may be two issues: One is that the modified date doesn't update when you edit and save the Excel file.
Another one is that the changes can't be synced to the local synced Excel file after you modify the Excel file and save it to the SharePoint Online library. You may edit another Excel file of the library in the Excel client, and check the modified date and the content. To see if the issue only happens to Excel files, please try editing other format files e. And then Select Open in Excel Online and share the outcome.
Subscribe to RSS
Open the synced Excel file and edit it, and see if it could be synced to the SharePoint Online file. Please click the Sync in the library and check if the changes could be sync to the local synced Excel file. You may edit other format files using the Office client, and check if it could be synced to the local.
Did this solve your problem? Yes No. Sorry this didn't help. Shun I had exactly the same issue. A ticket was raised and wait and behold the answer from MS was "Give it 15mins so the versions are the same".
Bullcr4p to put it politely. Download a copy of the file and then re-upload it to the library overwriting the existing file. Re-index the library and you should be ok.
Tried it with another excel sheet in a different sharepoint folder and it performed as I would expect in all scenarios. Unable to use a different PC. But 3 month old machine running windows 10, officeoffice Using Edge and Chrome browser so cannot use the open in explorer Sharepoint function. Very odd MS would release a new browser that effectively reduces SP functionality but that is another story This time I went into another sharepoint excel file and choose to update by opening excel locally.
Once saved it did save the changes on the server I could open it online and changes are there but did not change the modifed date in sharepoint nor sync to the file locally. If I repeating the procedure but editing in excel online it behaved as I would expect i. So the issue seems to be down to editing documents in the desktop office applications and how that then behaves with SP and subsequent local syncing?!I have 3 users that are trying to open reports that are excel files kept in Sharepoint.
Each of them is on a Windows 7 achine using IE9. When they click on the file, or check it out, it opens an old cached version. I have cleared all history, cookies files etc. I have also reset to default settings, and even gone as far as to set the broswer to pull a new copy of the site everytime it opens it. I was able to make a work around by having them use Google Chrome, but the preferred method is IE. I am lost at this point. It sounds like this should have already been addressed through some of the troubleshooting steps you've taken, but the behavior you're describing makes me think that the BLOB cache may be involved.
Here are a couple of blog posts I've written that may be of some assistance:. In short: verify that Excel documents aren't specified for caching in the BlobCache element of the web. If they are, remove them or adjust the max-age attribute. That would at least help you narrow down whether the problem is on the client side or server side. If the user opens the document but you don't see any communication happening between the client and server, for example, then it's reasonable to suspect that something like client-side caching potentially through the BLOB cache and max-age settings on the server is in-play.
If you see requests for the document taking place, though, and bytes are getting transferred across the wire This works, but the user still sees the old data if they try to open it from the site again.
Others see then new correct data. Please also note, if there is any pending or failed uploads in Windows Upload Center, the users will only see the local cached version when they tried to open office files on Sharepoint. To continue this discussion, please ask a new question.
Get answers from your peers along with millions of IT pros who visit Spiceworks. Popular Topics in Microsoft SharePoint. Spiceworks Help Desk. The help desk software for IT. Track users' IT needs, easily, and with only the features you need.
Thai Pepper. Phillip Feb 21, at UTC. I'm experiencing something similar, so if you've got the answer, you're helping TWO people! I hope that helps. We have a user with a similar issue. The work around until we resolve this: -Download Doc.
This topic has been locked by an administrator and is no longer open for commenting. Read these nextA colleague has been working on a document synced live with a Sharepoint site. He saved his changes yesterday, came in today and they aren't there, instead the document is a version from earlier. I inspected the document, looked in "history" and found various savepoints, one from this morning when he initially opened it and then a number from yesterday including the last save he did.
The last save does, thankfully, contain the new changes, but why were these not present when first opening. Any idea why? Co-authoring is enabled by default if both users open the document from the SharePoint site and have a compatible Office Application. So your first problem may just be a result of using Office The second issue may be the use of Windows Explorer to open the file.
I'm still not clear on your use of the term "synced" since that implies the use of the OneDrive for Business sync engine to establish a local "synced" copy of the file. It that is opened co-authoring won't work because the file is being opened from a different location by each user. But I'm not sure if co-authoring will work if you don't open the document through the web UI.
As I said, I suspect what you have experienced is two users who opened the same file for editing, but where co-authoring didn't get enabled. So when the one author saved his modifications it saved, but then the next author saved his changes over that version. So you get two versions in SharePoint. One with the changes and one without. Since the one without was saved later it is the current version. That's the way it has always worked except in cases of co-authoring.
This article gives an overview of co-authoring. When it works its great, but it is also fairly touchy and version sensitive. Thanks for your response. I've just been doing some reading about co-authoring.
I have no idea if it is enabled in all honesty as I'm not the administrator for our Sharepoint Site however my experience of other subsites suggests it is because I've collaborated on documents with colleagues before and the changes have saved simulatenously.
Is there a way to check? From what I understand the document in question has been edited by 2 users before at the same time - suggesting that co-authoring is enabled here too is this done by default?Keep in touch and stay productive with Teams and Officeeven when you're working remotely.
You might consider syncing your document library with your computer to work with documents. Syncing creates a local folder on your desktop machine where you can open and edit files easily. Some problems occur because of differences in versions of SharePoint server and Office. If you can't get it to work, try downloading the file and seeing if you can open it locally. In SharePoint Online, select the file, and click Download on the command bar, or click the ellipses In SharePoint Serverselect a file, click More on the command bar, and click Downloador right-click the document, and then click Download.
For SharePoint Serverselect a file, click the ellipse ForSharePoint Serverclick the down arrow on a file, click Send toand then click Download a copy.
In your browser, click Saveand then Open folder to open the folder where the file is located. Right-click the file in the desktop folder, and then click Open With. Choose the app you want to use. If the file hasn't been assigned, it will pop up a dialog to select one.
If the app isn't on the list, click Choose another app. Close the app and try double clicking the file to see if it opens the correct app. To get the version of Office you're using, see What version of Office am I using? If you use these programs, update them to or If you no longer use them, uninstall them. If the file opened previously, but now doesn't, there could be a problem with a corrupt file, or the format is not compatible with any of your apps.
I use something similar to the following to get the information from these reports:. This normally works fine and brings back the correct results however sometimes it'll bring old values through even though nobody has changed the reports on SharePoint. I don't have any prior experience to working with SharePoint other than this so was wondering if there is some automatic caching or something similar?
If so is there a way to turn it off as we only want the latest results, perhaps something in the connection string used in Excel? Essentially, you can use the program in your start menu "Microsoft Office Upload Center" to set cached files to be removed as soon as you close them on the profile used to run these reports.
It will slow you down slightly opening other documents but sounds like the extra time might be worth the extra accuracy. Office Document Cache settings. Learn more. Sometimes returns old possibly cached? Asked 5 years, 4 months ago. Active 5 years, 3 months ago. Viewed 2k times. I use something similar to the following to get the information from these reports: ActiveCell.
John Saunders k 23 23 gold badges silver badges bronze badges. CustomNet CustomNet 2 2 gold badges 8 8 silver badges 30 30 bronze badges. Just out of interest, is versioning enabled on your Sharepoint library and particularly, Major and Minor versions?OneDrive Sync Client Making Files Read-only
The reason I ask this is because we have a library where Major and Minor versions are enabled, and only certain people can see the minor version. This sometimes leads to situations where different people can see different versions of the same document, leading to confusion. Hi Mark, thanks for your suggestion but no we do not use versioning here, we just overwrite the current file.
Active Oldest Votes. The link below should help to understand SharePoint's cache process. Dave Excel Dave Excel 2 2 silver badges 5 5 bronze badges.
Thanks for your answer, I'll be trying this for today. I've had a read over the link you posted and not sure if this will ensure the latest numbers from the reports on SharePoint. It says "The Office Document Cache is used by the Microsoft Office Upload Center to give you a way to see the state of files you're uploading to a server". However I am not the one who uploads the files to SharePoint so I'm just making sure this solution will work for me? I'm mostly concerned with whoever is trying to use that data connection because the setting should be associated with their own profile and the connection is running from their machine.
How did this help? I am logged in to Excel which is associated with SharePoint so that's where the credentials are coming from. Also I'm not sure this is working as I am not the one uploading the documents to SharePoint just trying to grab the figures from them.
Sign up or log in Sign up using Google. Sign up using Facebook.Keep in touch and stay productive with Teams and Officeeven when you're working remotely.
Which version of SharePoint am I using?
When looking for help online, you often need to know the version of SharePoint you're using. This topic can help you find that out. Some functionality is introduced gradually to organizations that have set up the targeted release options in Office This means that you may not yet see this feature or it may look different than what is described in the help articles.
If you got here from another topic, after you find which version of SharePoint you're using, click the previous button in your browser to return to that topic.
While SharePoint does not have a version button or about box with version info, there are a few distinctive features on each version. Unfortunately you won't always see these features if an administrator and site designer has heavily customized the site. If you don't see anything here that looks familiar, ask your manager, administrator, or IT department. If you do see something that looks like your SharePoint environment, click the details below it for more information about that version.
SharePoint Online provides several types of sites you can create from the home page. Here are some of the site types, and how to identify them. At the top of the page is Create site and Create News post. The body typically shows News from sites and Frequent sites. Here's how to identify them. A Team site is connected to an Office Group. For more on that, see What is a SharePoint Team site. A communication site isn't connected with a group, though you can use groups for permissions.
For more info, see What is a SharePoint communication site. SharePoint Online is updated frequently, so Office or SharePoint Online standalone will typically be the latest version.