Forum Discussion
Helsy49Mildura
Sep 10, 2022Copper Contributor
Excel spreadsheet
I have lost the first 200 lines of my spreadsheet and can't recover it. Is it recoverable?
GeorgieAnne
Sep 11, 2022Iron Contributor
Hello Helsy49Mildura When you say "lost" what does that mean? The data in rows 1 to 200 are not visible in the worksheet? Check if they are any filtering going on. If the Row numbers are blue filtering is active. Un-filter and you will get your data back. Also check the font color, check the number formatting, check if the formula is not returning a space or a empty string, is there a pane frozen at row 201... among the things you need to check. The cells in rows 1 to 200 are empty in the worksheet? Do you have a recent backup? You should always save your workbook and make a backup of it in two or three places. Yes give us a better description of what "lost" means. Also if you can take a snipit of the cells that you know are "lost" and have the cell selector in one of the cells you want us to see. Hope this helps Georgie