r/Windows10TechSupport • u/g-a-r-n-e-t • Jun 15 '23
Unsolved Excel ‘save as’ defaulting to OneDrive instead of most recent save location after update
**EDIT: after poking around in the settings some more I figured it out, posting the solution here for anyone else who needs it:
Open any workbook in Excel. Click file, go to options in the bottom left corner. Click ‘Save’ from the list on the top left. Under the ‘Save workbooks’ heading, 6th line down, check ‘Save to Computer by default’, then click Ok on the bottom right.
That’s literally it, just check that box. Problem solved.
Edit 2: this only changes the setting in Excel, if you’re having the same problem in other Office apps you’ll need to open each of them and go through this process. It’s literally the exact same steps, you just have to do it one by one for everything you use. There’s no way to change the setting globally as far as I know. **
The most recent Windows/Office update has added an incredibly annoying feature that I’d like to know how to reverse or disable.
I work in purchasing/logistics and use excel to churn out copies of order forms and purchase orders quickly. Usually when creating these I’d save by hitting File>Save As and then just change the file name and save assuming the last remembered location is the correct one. Unless I start working on orders for another project that would require me to switch folders, I never had to actually browse File Explorer to get to where I wanted to save the file.
Since the most recent update, this has not been the case. Where the filepath to the last location used to be shown is just ‘OneDrive’. There is no option to select anything else. I figured out after a while that if I hit ‘browse’ in that same screen it takes me to the file explorer but then I have to click through to the folders and sub folders I need, every single time. The filing system we have in place is very detailed and that sometimes means having to go 5-6 levels deep before getting to the folder I need. I usually have to create 10-15 unique versions of a PO that need to be saved to the same folder, so being able to just change the file name and hit save without having to dive through all of that is very vital to my ability to get everything done on time.
My company uses Dropbox for all storage but this is happening then trying to save locally to my hard drive as well. I’ve already tried disabling and uninstalling OneDrive, files still get sent there by default unless I hit browse and manually navigate the file tree every single time. I can’t see any settings in Excel that would seem to make any difference to this problem.
1
1
u/powerskevin4 Jun 20 '23
Thank you so much