data loss

  1. S

    File error: data may have been lost

    I've been working on an Excel file with no problems. Then yesterday I opened it and got the error in the subject line. Certain - but not all - of the formulas in the workbook now simply contain "=#N/A". I fixed the formulas and re-saved it. I opened the file again today and got the same...
  2. M

    Data Loss when Excel is Reopened - #N/A in place of formulas

    When I reopened a large excel file, I received an error message that data was lost. In the file many formulas were converted to #N/A. Any idea how this happened? What can I do to prevent this from happening again? Thanks.

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top