Backup Excel personal.xlsb to OneDrive

I am using OneDrive for Business and I want to backup my Excel personal macro file; personal.xlsb.

I have tried the following methods without success.

1. Add folder to OneDrive - I cannot seem to locate this option.
2. Move personal.xlsb to My Documents and change the option File -> Options -> Advanced -> General -> At Startup open all files in. Excel opens the file but does not allow changes to be made to the file.
3. Move personal.xlsb to My Documents and change the option File -> Options -> Trust Center -> Trust Center Settings -> Trusted Locations -> change Excel default location: User StartUp. Excel does not even open the file.

Any suggestions on how to automatically sync this file to OneDrive?

2

1 Answer

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 for me.

Some links for reference.

• The Complete Guide to Creating Symbolic Links (aka Symlinks) on Windows - How to Geek
• Synchronizing any folder on your system with OneDrive - Microsoft
• Sync any folder in Windows to OneDrive
• How to Sync Any Folder to OneDrive in Windows 10

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy