Forum Discussion

Meagan Agnew's avatar
Meagan Agnew
Copper Contributor
Sep 19, 2018

Need help with #N/A throughout workbook

I've been using an excel sheet for my business since Nov of last year. I store it on the one drive. Today I was updating it, and my laptop was having wifi driver issues. I saved and rebooted. When I reopened the sheet, it was showing #N/A in 99% of the cells I have a formula in. They're essentially unrelated, some are simple sum, some are very basic =x-y*(.05) and others are referencing a different sheet in the book. Other sheets also have random cells with this "error". It also doesn't display the formula, so I can't even see what it thinks the issue is. I had an older version of the book saved to my computer, and that one doesn't have this problem.

I've contacted support and they basically played around with stuff like an excel beginner would, then referred me to the forum. Then she claimed this isn't a technical issue, and it must be related to my wifi driver....

I'm praying someone can help me because this is 9 months of data that I cannot enter over again.

I'm using 2013 home and student I believe. 

excel
Formulas and Functions
  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Sep 19, 2018

    Hi Meagan Agnew

     

    Sorry to hear about your issue (we've all been there before) but you are in luck! OneDrive saves your various file versions as you work on it.

     

    Essentially you should be able to restore the file to the very last (working) version or an earlier one that was saved.

     

    Check out the Microsoft instructions below:

    https://support.office.com/en-us/article/restore-a-previous-version-of-a-file-in-onedrive-159cad6d-d76e-4981-88ef-de6e96c93893

     

    If you get stuck, please let me know and I'll walk you through it in more detail.

     

    Cheers

    Damien

    • Meagan Agnew's avatar
      Meagan Agnew
      Copper Contributor
      Sep 19, 2018

      Well that got rid of the weird issue, thank you so much!!

      BUT what on earth caused this and how do I keep it from happening again?

      • Damien_Rosario's avatar
        Damien_Rosario
        Silver Contributor
        Sep 26, 2018
        Hi Meagan

        Sorry for the delayed response.

        Not sure what has caused the issue but I wouldn't worry about it unless it becomes a regular issue.

        It's a really great result and a good lesson for everyone to be smart about their storage like you were.

        All the best and have a great week ahead!

        Cheers

        Damien

Resources