Excel 2013 displays old data but has sums for new data - table visually corrupted??

I have an Office 365 subscription and am using Excel 2013.  Today I encountered an egregious bug in Excel that I need assistance with.

My workbook has 9 worksheets in it.  One worksheet is now corrupted.  In this worksheet I have about 110 rows of data with various calculations.  This workbook was created in June 2015.  The corrupted worksheet was just created today.  All other worksheets are correct and uncorrupted.

Today, I spent about 3 hours working in the workbook back and forth between two worksheets.  One of those worksheets is perfectly fine.  The other worksheet, the one I created today, became corrupted upon clicking <save> in Excel.  I didn't close the workbook, I just saved it.

The corruption is truly bizarre.  It's as though all the new data and changes are there, but I just can't see it.  There are sums in the worksheet that reflect all of my changes correctly, even though the cells those sums are adding up don't appear on the worksheet.  Visually it's as if I never made the changes, but mathematically the sums have values that prove I did make the changes.

Todays modifications to my workbook consisted of:

  1. copying data from an old workbook and pasting it into a new blank worksheet in my current workbook. 
  2. splitting the information within the new worksheet into two adjacent columns: moving some items from the original column over to the new column (to categorize it)
  3. Adding sums to the bottom of both columns
  4. adding additional data into new rows in both columns
  5. formatting various sub-sections of the data with borders, currency formats, and text color changes
  6. Clicking save

When I saved the workbook something bizarre happened.  Suddenly the new worksheet "looks" like it did nearly 3 hours ago, shortly after I pasted the data from the old workbook into it. The new column has been added (just the empty column, nothing moved from the original column into it) but none of the new rows or their data exist in the worksheet.  None of the formatting changes exist, either.

The kicker is that about 2 hours into my work I added sums at the bottom of both columns (the preexisting column and the new column).  None of the work I did before adding those sums is displayed.  None of the work I did after adding those sums is displayed.  However, the sums still show the correct values reflecting all of the work I did leading up to clicking save.  ???

The other worksheet I edited has references to those cells containing the sums in the corrupted worksheet, and that other worksheet is correct.

The sums are AS IF all the new data were in the new worksheet and correctly separated into the two columns.  It's as though all my work exists despite me not being able to see it, and somehow I'm looking at a 3 hour old screen print of my worksheet.  ???????  How can this be? 

September 7th, 2015 3:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics