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

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

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