We use cookies on this website. By using this site, you agree that we may store and access cookies on your device Read More Got it!
File Repair 5 minute read

Data Disappears in Excel – How to get it back

Priyanka Chauhan
Written By
Priyanka Chauhan
Alexis Llontop
Approved By
Alexis Llontop
Updated on
August 1st, 2022

Summary: You may face the issue of ‘Excel spreadsheet data disappeared’ after changing Excel file properties and formatting rows and columns. This blog discusses the possible reasons for data disappearance and the solutions to fix the issue. Also, it mentions an Excel file repair tool to retrieve the data from the file. Sometimes, while editing or formatting a cell in an Excel spreadsheet, the data may go missing or disappear. Let’s discuss in detail the reasons that may cause the ‘Excel data disappeared’ issue along with the solutions.

Free Download for Windows

Contents

  • Probable Reasons of Data Disappearing in MS Excel and Solutions Thereof
  • What Else You Can Do to Resolve the ‘Excel Data Disappeared’ Issue?
  • Conclusion

Probable Reasons of Data Disappearing in MS Excel and Solutions Thereof

Reason 1 – Unsaved Data

While entering data in an Excel spreadsheet, it is important to save the data at frequent intervals. Doing so prevents any unsaved data from disappearing if you lose power or accidentally click ‘No’ when prompted to save the file. Unfortunately, such a situation is quite common as users often close the file without saving the recently made changes to a spreadsheet.

Solution – Use the ‘AutoSave’ Feature

With the AutoSave feature enabled in Excel, data won’t be lost in the event of power failure or abruptly closing the Excel program. By default, Excel automatically saves the information in a spreadsheet after every 10 minutes. You can reduce the limit to a few seconds to reduce the chances of Excel file data lost after being saved.

Change excel autosave internal

Reason 2 – Changing Excel Format

You can save an Excel file in various formats, like spreadsheet, text, webpage, and more. However, at times, saving the spreadsheet in a different format may lead to missing data. For example, when you save a workbook to a text file format, all formulas and calculations applied to the data will be lost.

Solution – Adjust a Spreadsheet for the Changed Format 

If you’re changing the format of a spreadsheet, make space for the rows and columns. Also, remove all calculations before saving the file.

Note: If the sheet is shared on multiple computers, then save the file in compatibility mode.

Reason 3 – Merging Cells

You can combine two or more cells data to make one large cell. This technique is primarily used to fit the text of a title in a sheet. If there is data in two or more cells, then only the data in the top-left cell is displayed and the data in all other cells is deleted. If the other merged cells have been populated with data after merging, the data is not featured and it does not appear even after remerging the cells.

Solution – Merge Cells inside One Column

To merge cells without data loss, combine all the cells you want to merge within a column and do the following:

  • Select the cells to be combined.
  • Ensure that column width is wide enough to fit the contents of a cell.
  • In the spreadsheet, under the Editing group, click ‘Fill,’ and then click ‘Justify.’
excel-fill-option
  • Under Alignment, click on the ‘Merge & Center’ option to center align the text. Or, click on ‘Merge Cells’.

Note: This solution works for text only. You cannot use it to merge formulas or any numerical values. If you need to combine two or more cells with formula into a single cell, try using the Excel CONCAT function.

Reason 4 – Cell Formatting

Cells and text in the cells can be displayed in different colors to make the spreadsheet simple to create and infer. You may experience data loss when you try to modify the data or change the color or size of the data. Though the information may exist, the data may show an error due to the following reasons:  

  • White-colored text will not show in a white-colored cell
  • Large font-sized data may not appear in small-sized cell
  • Calculations may show (#VALUE) error after cell-formatting

Solution – Check and Clear Formatting

Make sure to use dark-colored text on a white-colored cell. Also, resize the cell to fit the text size. Check if numbers in a cell are entered as text. If so, you need to apply a number format to the text-formatted numbers. Read more about it, from here.

What Else You Can Do to Resolve the ‘Excel Data Disappeared’ Issue?

If you can’t recover the missing Excel file data, try to repair or extract the data from the file using the built-in Excel repair tool. Follow the below steps to use the tool:

  • Open MS Excel, click File > Open > Computer > Browse.
  • On the ‘Open’ window, select the file you want to repair and then click on the Open dropdown.
  • Select Open and Repair.
Open and repair

Use the ‘Repair’ option to repair the file and recover as much data as you can from the repaired file. If this doesn’t work, use the ‘Extract’ option to recover the data.

If you fail to retrieve the disappeared data from that file using the above-listed steps, opt for an Excel repair tool, like Stellar Repair for Excel. This software has a proven track record of repairing corrupt or damaged Excel files and recover all the data.

free download

The software helps:

  • Fix all corruption errors. It helps in getting back the data which has disappeared.
  • Repair a single as well as multiple Excel files.
  • Recover all components of XLS/XLSX files – tables, chart sheet, cell comment, image and more.
  • Preserve the worksheet properties and cell formatting.
  • Support the latest Excel 2019 and earlier versions.

The Excel repair software repairs the Excel file in these simple steps:

  • Launch and open the software.
  • Select the corrupt Excel file by using the ‘Browse’ option. If the file location is not available, then find the Excel file using the ‘Search’ option.
Browse and Search
  • Click ‘Repair’ to scan the corrupt file.
Scan corrupt file
  • Once the repair process is complete, verify the components of Excel file and check if the available preview shows complete data that disappeared from Excel.
Disappeared from excel
  • Save file at default location or preferred location.
Default location

The Excel file with all the restored data will be saved at the selected location.

Conclusion

It is better to repair the affected Excel file than suffer the loss when data or text disappears in Excel. A professional software ensures that users get back all the data in the form of a new Excel file. Stellar Repair for Excel software repairs the corrupt file without modifying the original content and file format. The software’s easy-to-use user interface lets you perform the functions without formal software training and technical expertise.

About The Author

Priyanka

Priyanka is a technology expert working for key technology domains that revolve around Data Recovery and related software's. She got expertise on related subjects like SQL Database, Access Database, QuickBooks, and Microsoft Excel. Loves to write on different technology and data recovery subjects on regular basis. Technology freak who always found exploring neo-tech subjects, when not writing, research is something that keeps her going in life.

Best Selling Products

Stellar Repair for Excel

Stellar Repair for Excel

Stellar Repair for Excel software provid

Read More
Stellar Toolkit for File Repair

Stellar Toolkit for File Repair

Microsoft office file repair toolkit to

Read More
Stellar Repair for QuickBooks ® Software

Stellar Repair for QuickBooks ® Software

The most advanced tool to repair severel

Read More
Stellar Repair for Access

Stellar Repair for Access

Powerful tool, widely trusted by users &

Read More

14 comments

  1. Katheryn Nez says:
    January 24, 2021 at 5:09 am

    Recovering data by using tools is quite obvious nowadays. But Recovering data formatting too is incredible for me. Good job Stellar!

    Reply
    1. Eric Simson says:
      January 28, 2021 at 3:50 am

      Hi Katheryn,
      Thank you so much for your appreciation. We always try to do our best.

      Reply
  2. Plastische chirurgie Hamburg says:
    June 7, 2020 at 4:03 am

    It’s like you read my thoughts! You appear to have good knowledge of Excel, and the post you wrote seems like a handy e-book on retrieving Excel data.

    An excellent read. I will certainly be back.

    Reply
  3. 카지노사이트 says:
    June 2, 2020 at 10:23 pm

    You actually mentioned it adequately!|
    Incredible

    Reply
  4. John says:
    August 31, 2019 at 5:53 am

    OMG!

    I have recovered my lost data again.

    Reply
  5. Janice J. Hilliard says:
    December 26, 2018 at 6:31 am

    All of a sudden, my Excel file version 2016 have unviewable data. When I open the file, only half data is viewable. When I scroll down the page data disappears. I already tried Excel repair utility but nothing happened.

    Please suggest time & efforts saving solution.

    Reply
    1. Eric Simson says:
      December 26, 2018 at 9:12 am

      To recover the Excel file data you can try professional Excel file repair tool i.e. Stellar Repair for Excel tool. It repairs corrupt or inaccessible MS Excel spreadsheet without modifying data. It will save your time & efforts.

      Reply
  6. Robert H. Jones says:
    November 29, 2018 at 4:39 am

    Due to power cut, I have lost my organization products information within couple of seconds. Then I used Stellar repair for excel tool to recover my lost data. This tool helps to recover every piece of cells and their formatting.

    Reply
  7. Faye Reid says:
    May 19, 2018 at 11:30 am

    Yesterday I found that all text disappeared in Excel 2010 after saving the file. I never deleted a single text from excel.

    Ohh God, Why Is This Happening?

    Reply
    1. Eric Simson says:
      May 20, 2018 at 4:55 am

      Don’t Panic!

      Just try free demo of Stellar Repair for Excel software & share feedback with us.

      Reply
  8. Susan Briley says:
    February 28, 2018 at 3:20 pm

    I had the same problem. Suddenly my charts disappeared when I hit save. Turns out – I had previously printed something to pdf so my printer was not the default printer in excel. Once I hit Print and my printer popped up – voila! My charts all came back!

    I also read that if your printer is offline, then your charts will disappear as well.

    Reply
    1. Eric Simson says:
      March 1, 2018 at 4:30 am

      Hi Susan,

      Can you take a print as an Administrator on that PC?

      Reply
  9. Harriet Swanson says:
    February 26, 2018 at 11:10 am

    I have tried an array of tricks mentioned above but the data in my spreadsheet is not showing.

    Can I run software to ensure its credibility?

    Reply
    1. Priyanka Chauhan says:
      February 27, 2018 at 3:39 am

      Hello Harriet,

      Yes, Stellar Repair for Excel software repairs the corrupt Excel file without hampering the original file format. It preserves the cell formatting and workbook properties.

      Reply

Leave a comment Cancel reply

Your email address will not be published. Required fields are marked *

Image Captcha
Refresh Image Captcha

Enter Captcha Here :

Table of Contents    arrow

  1. Probable Reasons of Data Disappearing in MS Excel and Solutions Thereof
  2. What Else You Can Do to Resolve the ‘Excel Data Disappeared’ Issue?
  3. Conclusion

Categories

offer banner

Related Posts

related post
File Repair

How to Fix the #Value! Error in Excel?

Stellar Author Monika Dadool January 25, 2023 Read More
related post
File Repair

[2023 Fix]: An Unexpected Error has Occurred. Changes to your Data cannot be Saved

Stellar Author Monika Dadool January 24, 2023 Read More
related post
File Repair

How to Fix Excel Run-Time Error 1004?

Stellar Author Monika Dadool September 28, 2022 Read More

Free Trial for 60 Days

Stellar Official Website

Stellar Data Recovery Inc.
48 Bridge Street Metuchen,
New Jersey 08840,
United States

ALSO AVAILABLE AT

Partner Logo

About

  • About us
  • Career
  • ISMS Policy
  • Privacy Policy
  • Terms of Use
  • License Policy
  • Refund Policy
  • End User License Agreement

RESOURCES

  • Blog
  • Articles
  • Product Videos
  • Knowledge Base
  • Case Studies
  • Whitepapers
  • Software Catalog

NEWS & EVENTS

  • News
  • Events

PARTNERS

  • Affiliates
  • Resellers
  • Distributors

Useful Links

  • Contact Us
  • Support
  • Special Offers
  • Student Discounts
  • Awards & Reviews
  • Downloads
  • Store
  • Sitemap
Follow Us

tw in yt

Stellar & Stellar Data Recovery are Registered Trademarks of Stellar Information Technology Pvt. Ltd. © Copyright 2023 Stellar Information Technology Pvt. Ltd. All Trademarks Acknowledged.

Hippa Logo tuv footer partner logo DMCA.com Protection Status