Share via

How to open a saved excel document on my desktop

Anonymous
2024-01-11T03:14:53+00:00

I am doing monthly expense reports on excel. When I start a new month, I save a copy to one drive, turn off auto save, delete data and then resave under new month name, then turn on the auto save again. I am able to open the previous month and minimize it so I can refer back to it. However, I am now unable to open the month of May; even though it’s saved to my documents. 1. How can I open the month of May ? Is there a simpler way to do this process on making new sheets with same headings but new data? Thanks so much

Microsoft 365 and Office | Excel | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Anonymous
    2024-01-11T05:39:12+00:00

    Hello Noel,

    I'm Ibhadighi and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

    Let's tackle this step by step with simple solutions:

    Opening the May Excel Document:

    1. Go to your Documents folder where the May file is saved.
    2. Normally, just double-clicking the file should open it in Excel. If this doesn't work, there might be an issue with the file itself or the association of Excel files on your computer.
    3. If double-clicking doesn't work, try opening Excel first. Then, go to File > Open > Browse, navigate to your Documents folder, and select the May file.
    4. Ensure the file has an Excel format like .xlsx or .xls.

    Simplifying Your Monthly Expense Report Process:

    1. Instead of manually deleting data, consider creating a template with your headings and standard formats. Save this as an Excel Template (.xltx file). Each month, you can open this template, which will automatically create a new workbook for you to fill in.
    2. Another method is to duplicate the sheet within your existing workbook:
      • Right-click on the tab of the existing month.
      • Select Move or Copy.
      • Check Create a copy and select (new book).
      • Click OK.
      • This creates a new workbook with the duplicated sheet. You can then clear the data and save it with the new month's name.
    3. If you frequently perform the same steps, you could consider learning basic Excel macros to automate some of these tasks, such as clearing data fields and saving files with a new name.

    Remember, regular backups (like saving to OneDrive) are great to prevent data loss. If you encounter issues with Excel files regularly, it might also be worth investigating if there's a deeper problem with your Excel installation or your computer's settings.

    I hope this helps.

    Best Regards, Ibhadighi

    3 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful