N/APosted on - 01/06/2012
I have an Excel spreadsheet that requires a large number of cells to be filled with important data's. My problem is, every time I save my job progress, the important data's in the cells are missing. Is there a way to fix it? I am new in using Excel so I am in need of your help. My Excel 2007 is running in my Windows Vista Home Premium. And also, if you can send any help on using Excel and can help me in filling cells with important data's without having any issues, please do so. Thanks a lot!
Data is Missing when Saving in Excel
Are you sure that indeed the data is lost or is it the formatting that is making the text disappear. You will need to check that you have formatted the cells properly so that no data is hidden. If the data that you have in the cells is long such that is makes something like phrases or sentences, then using very small cells may hide the data and therefore you may end up thinking that the data is lost. You will therefore need to expand the cells and see what happens.
Also check the format that you are saving the data in. If you are using excel 2007 or excel 2010, then I will recommend that you save in the compatibility format to eliminate any problems associated with saving the files in a format that is not compatible to other versions of excel.