Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Disable "save as" defaulting to OneDrive, but do not disable OneDrive - possible?

Iron Contributor

Today I had hundreds of users, including me being admin, being furious beyond imagination for following change which the last "slow ring" office brought along:

You open a document from a network drive, my documents or desktop.

You click "save as", and instead of defaulting to the path where the original document came from it defaults to onedrive. Every time. The amount of tickets from users missing their files they just saved is enormous.

Since Winword 2.0 and Excel 3.0, both from 1991 where I used them the first time, the default of "save as" was always where the original file opened came from.

How can we restore this original behaviour? We do NOT want to be Save-AS defaulting to a fixed place, like "my documents", we want the original behaviour, which we had over 30 years now, back. Can this be achieved? If you know please tell. We have to keep OneDrive, as optional save to place, just not as the default for any document.

To us this is the single worst most expensive and time consuming change ever Microsoft has done to Office. On top it is a data protection law issue.

4 Replies
I would experiment with the settings on the Save tab of Excel's Options dialog. See if changing those get you where you want to be.
best response confirmed by Joachim_Otahal (Iron Contributor)
Solution

mjeannez21_0-1700060693140.png

Have the "Save to Computer by default" checked. That worked for me because I also spent way to much time stressing about this. 


@Joachim_Otahal 

Thank you, that combination of options does make it behave like before.
Now if only Microsoft, specifically some parts of it, would stop actively working against its customers where as other parts of Microsoft are working towards customers (hello kernel group, I talk about you!).

Not we only have to check the registry what got changed and GPO it.

@Joachim_Otahal 

It is this key:
PreferCloudSaveLocations
located here:
Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Common\General
The key works reversed to the options setting (set to 0 to check the box, set to 1 to uncheck it)

1 best response

Accepted Solutions
best response confirmed by Joachim_Otahal (Iron Contributor)
Solution

mjeannez21_0-1700060693140.png

Have the "Save to Computer by default" checked. That worked for me because I also spent way to much time stressing about this. 


@Joachim_Otahal 

View solution in original post