Aug 08 2023 02:21 AM
I have a huge excel book where I created an inventory for my crafting products
One sheet has in upper left corner a 1 and a 2 under it, with a line to the right with an adjacent minus or plus box that toggles. I tried to get rid of it and received a popup message that said I couldn't edit it in a merged cell. I un-merged and when I clicked that, all my data disappeared on this sheet, 400+ rows at least. I tried to recover it and probably made it worse by all the clicking around incorrectly. I searched in File Versions to try and pick up the entire book before this error happened, but there was no file recent enough to have all the recent data I added to the book. I left my computer on for now. I don't know what to do next to get my sheet back. I do have a back-up on an external drive if all else fails but I have never recovered anything before from it, so not familiar with the procedure. I will be so grateful for any suggestions on what to click next.
Sincerely, Judith
Aug 08 2023 04:17 AM
Does Undo (Ctrl+Z) help? Or did you close the workbook?
Aug 09 2023 01:00 PM
Aug 09 2023 01:33 PM
I'm very sorry but I fear you're out of luck...