It seems obvious: when you open a file in an app through the File > Open menu item, you would like to have the same location chosen when you choose File > Save for a new file or File > Save As (Option ...
Microsoft 365 apps like Word and Excel offer direct access to OneDrive and, if available, to SharePoint. Using the File menu, you can save your documents directly to OneDrive via the “Save as” option.