Corrupted sheet - What the cause?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 20 Nov 2007 15:08 GMT

Hi, my Excel sheet got corrupted and lost its reference to a range- therefore
my Vlookup did not work.
After opening it in Open-repair mode all was fine (and I was told athat the
reference to the range was repaired)
Is there a reason for the sheet to get corrupted ? How can I minimize it? Is
there a way to find out it is corrupted before just noticing that the
calculations are wrong?

Many thanks,
Dan

Reply to this Message

JLGWhiz - 20 Nov 2007 16:22 GMT

Hard to say exactly what corrupts a file. Power spike, magnetic object to
close to the hard drive, FAT malfunction. Could be a lot of different
things, including gremlins. <g>

> Hi, my Excel sheet got corrupted and lost its reference to a range- therefore
> my Vlookup did not work.
[quoted text clipped - 6 lines]
> Many thanks,
> Dan

Reply to this Message

Dan - 20 Nov 2007 17:16 GMT

the file was not closed then corrupted, it was working fine then got corrupted.

> Hard to say exactly what corrupts a file. Power spike, magnetic object to
> close to the hard drive, FAT malfunction. Could be a lot of different
[quoted text clipped - 10 lines]
> > Many thanks,
> > Dan

Reply to this Message