Excel workbooks have blank pages and loses data.

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have a windows 2000 machine with office 2000 pro. The problem occurs
with a number of spreedsheets (3) on the PC but basically, when you
open the spreedsheet, pages that did have data in suddenly turn up
blank. The machine appears to be fine. There are no obvious problems.
There are no viruses and the disks do not have any issues. Office 2000
has been removed and reinstalled twice with the cleanup utility used
inbetween. I've tired it on it's own and service packed with 1, 2 and
3 and it appear to make no difference what so ever.

I've run out of ideas. Has anyone seen this behaviour before?
 
I'm afraid I have no real good help but just to make sure :
Are the sheets protected. If so : Is it possible that the formulas in the
cell are made "invisible" ?
(See : Format / Cell )

Are the cells actually empty or are they maybe formatted as textcolor =
backgroundcolor.

I know : Not likely but .....

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
And just to add more mud to the water:

Maybe the cells have conditional formatting to hide them.
(under: Format|conditional formatting)

And any chance you have macros "helping" you.

Try closing excel
and reopen it safe mode:
windows start button|Run
Excel /safe

Now open your workbook. Macros will be disabled.

===
If you hit ctrl-End, do you go far to the bottom right? Or do you stay in A1?

If you stay in A1, then those other cells are empty. If you go to the bottom
right corner, then those cells have something (or used to have something) in
them.

===

And my real bet. Watch your users edit the workbook. My bet is that they did
something bad.

(I'd like to blame xl for my errors, but no one will listen!)
 
Back
Top