excel 3013. New installation running Win 7.
I save a worksheet, to my desktop. Then the next day I reopen the worksheet and it appears blank. No grid lines, no text. But if I select the correct cell (they are there) I can see the text or numbers in the bar at the top.
I looks like I set the text color to white but changing the font color has no effect. The sheet remains white letters on a field of snow.
It’s done this to a couple of sheets. It has saved stuff properly before.
What format of file did you save it as? (.xls, .xlsx?)
Have you tried setting the fill to No Fill, and the font colour to Automatic?
Is it possible to copy and paste the values into a new sheet - Paste Special, Values? That might be the simplest and least frustrating way of recovering the information, but you’ll lose any formatting you’ve set up.
I selected the entire sheet and tried to format the cells. It indicated that the borders outlining the cells was not selected but changing that and the font color and the fill had no effect.
Saving the file the default format is ‘excel workbook’. I saved the new version as that and as a excel 97-2003 workbook. Opening either of those files gives me the same “blank” looking opening.
There’s your problem - that version isn’t due out for another 998 years. Beta software can be buggy.
Seriously though, it sounds like the install might be a bit screwed - have you tried uninstalling and reinstalling it?
Have you tried opening any other sheets with it (ie ones saved from a different install)? What happens if you try to open that sheet on another PC?
