Recent files in Excel point to cloud OneDrive instead of local OneDrive

%3CLINGO-SUB%20id%3D%22lingo-sub-61978%22%20slang%3D%22en-US%22%3ERecent%20files%20in%20Excel%20point%20to%20cloud%20OneDrive%20instead%20of%20local%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-61978%22%20slang%3D%22en-US%22%3E%3CDIV%3EWe%20have%20discovered%20an%20issue%20with%20one%20user%20using%20OneDrive.%20Microsoft%20Support%20could%20not%20figure%20out%20what%20the%20issue%20is%20and%20told%20us%20to%20consult%20a%20forum%20(LOL).%20Anyone%20have%20any%20ideas%20what%20would%20cause%20this%3F%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EThe%20user%20saves%20a%20file%20to%20the%20local%20folder%20for%20his%20One%20Drive%20setup%20(C%3A%5CUsers%5Cjsmith%5COneDrive%20for%20Business)%2C%26nbsp%3B%20When%20the%20user%20goes%20back%20into%20Excel%20and%20looks%20at%20the%20recents%2C%20it%20comes%20up%20with%20the%20link%20to%20the%20OneDrive%20in%20the%20cloud.%3C%2FDIV%3E%3CDIV%3EMultiple%20tests%20have%20been%20run%20with%20this%20and%20the%20results%20are%20the%20same.%26nbsp%3B%20We%20have%20not%20seen%20this%20behavior%20on%20other%20OneDrive%20users's%20machines.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-61978%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-112102%22%20slang%3D%22en-US%22%3ERe%3A%20Recent%20files%20in%20Excel%20point%20to%20cloud%20OneDrive%20instead%20of%20local%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-112102%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20under%20the%20impression%20that%20the%20file%20that%20is%20linked%20locally%20is%20not%20updated%20to%20the%20latest%20version.%3C%2FP%3E%3CP%3EThe%20fact%20that%2C%20disabling%20the%20Office%202016%20sync%2C%20the%20two%20files%20exhibit%20the%20same%20behavior%2C%20could%20very%20well%20confirm%20this%20hypothesis%2C%20IMHO.%3C%2FP%3E%3CP%3ECan%20you%20please%20verify%20that%20both%20files%20are%20in%20the%20latest%20Excel%20format%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-112042%22%20slang%3D%22en-US%22%3ERe%3A%20Recent%20files%20in%20Excel%20point%20to%20cloud%20OneDrive%20instead%20of%20local%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-112042%22%20slang%3D%22en-US%22%3E%3CP%3E...had%20to%20look...%20they%20are%20both%20xlsm.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20turned%20off%20%22let%20Office%202016%20sync%22%20and%20it's%20working%20the%20way%20I%20want%2Fexpect.%20if%20Onecloud%20and%20the%20apps%20work%20as%20they%26nbsp%3Bshould%2C%20that%20should%20be%20enough%20syncing.%20I%20had%20some%20errors%20reported%20when%20I%20had%20Office%202016%20handling%20the%20sync%2C%20so%20it's%20not%20perfect.%26nbsp%3BSometimes%20I%20have%20the%20files%20open%20on%20two%20computers%20so%20we'll%20see%20if%20this%20causes%20more%20problems%20than%20before.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-111959%22%20slang%3D%22en-US%22%3ERe%3A%20Recent%20files%20in%20Excel%20point%20to%20cloud%20OneDrive%20instead%20of%20local%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-111959%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20it%20be%20that%20the%20one%20locally%20linked%20is%20an%20XLS%20and%20the%20one%20linked%20to%20the%20cloud%20is%20an%20XLSX%3F%3C%2FP%3E%3CP%3EJust%20an%20idea...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-111879%22%20slang%3D%22en-US%22%3ERe%3A%20Recent%20files%20in%20Excel%20point%20to%20cloud%20OneDrive%20instead%20of%20local%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-111879%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20with%20two%20files%20now%2C%20both%20synced%20to%20OneDrive%20and%20the%20'recent'%20link%20for%20one%20of%20them%20is%20local%20and%20one%20is%20in%20the%20cloud%2C%20even%20though%20both%20were%20last%20opened%20from%20the%20local%20drive.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20lost%20some%20changes%20on%20one%20of%20these%20sheets%2C%26nbsp%3Band%20while%20trying%20to%20figure%20out%20what%20is%20happening%2C%20I%20would%20prefer%20to%20have%20it%20at%20least%20look%20like%20it%20is%20doing%20what%20I%20ask.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-62018%22%20slang%3D%22en-US%22%3ERe%3A%20Recent%20files%20in%20Excel%20point%20to%20cloud%20OneDrive%20instead%20of%20local%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-62018%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20the%20correct%20behaviour%20in%20Excel%2C%20Ppt%20and%20Word%20in%20recent%20builds.%20Office%202016%20now%20knows%20that%20these%20files%20are%20on%20OneDrive%20so%20kind%20of%20takes%20over%20the%20syncing%20to%20enable%20co-editing%20to%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FUse-Office-2016-to-sync-Office-files-that-I-open-8a409b0c-ebe1-4bfa-a08e-998389a9d823%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FUse-Office-2016-to-sync-Office-files-that-I-open-8a409b0c-ebe1-4bfa-a08e-998389a9d823%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor
We have discovered an issue with one user using OneDrive. Microsoft Support could not figure out what the issue is and told us to consult a forum (LOL). Anyone have any ideas what would cause this?
 
The user saves a file to the local folder for his One Drive setup (C:\Users\jsmith\OneDrive for Business),  When the user goes back into Excel and looks at the recents, it comes up with the link to the OneDrive in the cloud.
Multiple tests have been run with this and the results are the same.  We have not seen this behavior on other OneDrive users's machines.
 
 
5 Replies

This is the correct behaviour in Excel, Ppt and Word in recent builds. Office 2016 now knows that these files are on OneDrive so kind of takes over the syncing to enable co-editing to work.

 

See https://support.office.com/en-us/article/Use-Office-2016-to-sync-Office-files-that-I-open-8a409b0c-e...

 

I am working with two files now, both synced to OneDrive and the 'recent' link for one of them is local and one is in the cloud, even though both were last opened from the local drive. 

 

I've lost some changes on one of these sheets, and while trying to figure out what is happening, I would prefer to have it at least look like it is doing what I ask.

Could it be that the one locally linked is an XLS and the one linked to the cloud is an XLSX?

Just an idea...

...had to look... they are both xlsm.

 

I turned off "let Office 2016 sync" and it's working the way I want/expect. if Onecloud and the apps work as they should, that should be enough syncing. I had some errors reported when I had Office 2016 handling the sync, so it's not perfect. Sometimes I have the files open on two computers so we'll see if this causes more problems than before.

I am under the impression that the file that is linked locally is not updated to the latest version.

The fact that, disabling the Office 2016 sync, the two files exhibit the same behavior, could very well confirm this hypothesis, IMHO.

Can you please verify that both files are in the latest Excel format?