Corrupted sheet - What the cause?
 

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

Corrupted sheet - What the cause?
 

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

"Dan" wrote:

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

Corrupted sheet - What the cause?
 

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

"JLGWhiz" wrote:

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

"Dan" wrote:

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