How to get AutoSave to save to the correct file path rather than a default file location on OneDrive.

Joe Studer 0 Reputation points
2024-07-16T16:55:21.8+00:00

AutoSave had been working fine until recently. Now when I open an Excel document, AutoSave is turned off. When I turn on AutoSave, it saves a duplicate to the "default local file location" which is [OneDrive/Documents]. When I change the "default local file location" using File/Options/Save this appears to just change the "default local file location" of all of my Excel files. How do I get AutoSave to save to the correct file path like it had been before? The correct file path is also on OneDrive.

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,346 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
    2024-07-17T06:10:10.07+00:00

    Hi @Joe Studer

    Now when I open an Excel document, AutoSave is turned off.

    Are you using Microsoft 365 Apps?

    How did you open the Excel workbooks?

    I suggest you follow the instructions from article "How do I turn on AutoSave?", do not open files from File Explorer or recent files list via the Taskbar directly.

    • Go to File then Open.
    • Select your OneDrive cloud iconOneDrive personal, work or school account. Office Open dialog showing OneDrive folder
    • Choose your sub-folder location from the list that appears.
    • Select the file you need to open.

    If these steps do not work, I suggest you remove the OneDrive service, and then add OneDrive Service back to have a check.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.