Almost every time I try and save an Excel document, the document saves, but lines 13 and 14 always vanish. Does anyone know what is happening?
I think we need more details. That would be a very high-profile problem if it happened to everyone.
Is this happening only to one particular Excel document or any you create?
Do they get deleted or are they just hidden? You can tell if they’re hidden because the row labels will go …10, 11, 12, 15, 16…)
I’m guessing that you have picked up a macro virus somewhere.
Disable macros and see if the problem goes away.
It doesn’t happen every single time, but oftens say if I am saving a spreadsheet with detailed info in several columns say rows 1-50, I save it to desktop, reopen it, and everything is there, except rows 13 & 14, which have gone from being full of info to completely blank- the lines are there, just blank. I have no other computer issues of any kind so I don’t think its a virus, just this one glitch. I thought it may be a common excel problem or windows related problem.
Try saving it as a .csv, then open that up as a new spreadsheet and see if the problem persists. This will get rid of many kinds of “funkiness”.
I just wanted to point out that’s exactly what a “macro virus” is. It wouldn’t affect anything else on your system, just Microsoft Office products (that allow macros). I would second the recommendation of disabling macros in Excel and see if that helps.
Wow, I had no idea Microsoft’s reputation was that bad.
Huh? Did I use a wrong term?
No, no. Just the thought that someone could think that such a potentially disastrous problem could be “common” is kind of funny. “Well, you know how crappy Microsoft’s stuff is … I bet everyone has this problem!”
BTW, I second the macro virus theory, even if it’s not technically a virus. Have you gone through any macros associated with this document to make sure there isn’t a line in there to do this on purpose? When I worked for the bank, some folks would unwittingly repurpose spreadsheets (it was 1-2-3 back then, but still), not realizing that sometimes they did things without asking upon open or close. It’s worth checking.
Unfortunaltey, my total knowledge of Excel is how to fill in or change lines on a spreadsheet someone else sent me . I thought on the off chance it might something easy, but since its not, I’ll have to get someone who knows of them to assist. Thanks though.