Default to My Mac Instead of OneDrive
Good news. This has been fixed and will be available in the 16.12 update. If you get monthly updates, you should be able to update in April. To get the update sooner, you can opt into the Insiders program by going to Help > Check for updates and opt to get the Fast Insider updates.
Thanks – Steve K [MS Excel]
Location of the preferences plist file has changed with recent versions of 2016. Now you need to use:
/usr/bin/defaults write /Library/Preferences/com.microsoft.office DefaultsToLocalOpenSave -bool true
But still have the same problem with Excel and the Open dialog. Works for everything else.
Like I said in the last post, nothing going to change with only 47 votes.
Yep, inconsistent here. Excel version 15.33 (170228). Works with Save, but not with Open.
Need heaps more votes if they are even going to consider it.
Please give us a default option choice or change the default behavior . Kind of bothersome to have to always click on "On my Mac" every time I need to open a file in finder. Would prefer it to open straight into finder as it use to. Thank you.
The DefaultsToLocalOpenSave setting is for all office applications. It however is not consistent. For build 161019, Word's open and save default to local but for Powerpoint and Excel only save defaults to local.
Be sure all office apps are closed and paste the default write command all on a single line from defaults write through TRUE. What this command does it to write a new key (DefaultsToLocalOpenSave) to the office preference file and sets the value to true.
I have also tried "defaults write ~/Library/Group\ Containers/UBF8T346G9.Office/com.microsoft.officeprefs.plist " and it is not working as expected. Can the person suggesting this plist setting please describe how it is working for them?
Microsoft must include a preference setting for the default open/save location to be "On My Mac". I'm using 15.27 and this has still not yet been addressed!
The defaults write command didn't make any difference for me. :-(
(macOS Sierra 10.12.1b2)
There is a plist setting that should make Office apps default to the local drive. In terminal paste the following:
defaults write ~/Library/Group\ Containers/UBF8T346G9.Office/com.microsoft.officeprefs.plist DefaultsToLocalOpenSave -bool TRUE
Dan Batson commented
I like the idea of allowing the user to select their default save location.
Why can't I select my mac as the default when applications open? I don't use OneDrive and having to tell my mac each time that I want to save the file to the mac instead of OneDrive is a pain. FIX THIS!