SOLVED
Home

Excel personal.xlsb to OneDrive

%3CLINGO-SUB%20id%3D%22lingo-sub-846816%22%20slang%3D%22en-US%22%3EExcel%20personal.xlsb%20to%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-846816%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20%3CSTRONG%3EOneDrive%20for%20Business%3C%2FSTRONG%3Eand%20I%20want%20to%20%3CEM%3Ebackup%3C%2FEM%3Emy%20Excel%20personal%20macro%20file%3B%20%3CSTRONG%3Epersonal.xlsb%3C%2FSTRONG%3E.%20I%20have%20tried%20many%20methods%20and%20did%20a%20fair%20amount%20of%20searching%20but%20cannot%20seem%20to%20figure%20this%20out.%20Any%20suggestions%20on%20how%20to%20automatically%20sync%20this%20file%20to%20OneDrive%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-846816%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853391%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20personal.xlsb%20to%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853391%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20appears%20that%20this%20is%20possible%20by%20using%20the%26nbsp%3B%3CU%3E%3CFONT%20face%3D%22courier%20new%2Ccourier%22%3E%3CSTRONG%3Emklink%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FU%3E%20statement.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3Emklink%20%2Fj%20%22C%3A%5CUsers%5C%7BUserName%7D%5COneDrive%5CBackup%5CXLSTART%5C%22%20%22C%3A%5CUsers%5C%7BUserName%7D%5CAppData%5CRoaming%5CMicrosoft%5CExcel%5CXLSTART%5C%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%20is%20that%20Excel%20puts%20a%20lock%20on%20%3CU%3E%3CSTRONG%3Epersonal.xlsb%3C%2FSTRONG%3E%3C%2FU%3E%20and%20will%20not%20sync%20it%20until%20Excel%20is%20closed.%20so%20far%20that%20is%20acceptable%20to%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am using OneDrive for Business and I want to backup my Excel personal macro file; personal.xlsb. I have tried many methods and did a fair amount of searching but cannot seem to figure this out. Any suggestions on how to automatically sync this file to OneDrive?

1 Reply
Highlighted
Solution

It appears that this is possible by using the mklink statement.

mklink /j "C:\Users\{UserName}\OneDrive\Backup\XLSTART\" "C:\Users\{UserName}\AppData\Roaming\Microsoft\Excel\XLSTART\"

 

Problem is that Excel puts a lock on personal.xlsb and will not sync it until Excel is closed. so far that is acceptable to me.

Related Conversations
Power Query Union Tablas sin Campos en Comun
Exemilenio in Excel on
0 Replies
Multiple drop down list
sure19 in Excel on
1 Replies
Insert empty row between last names
LMesi1110 in Excel on
0 Replies
Office 365 Excel Freezes
jmanderson42 in Excel on
0 Replies