Corrupted sheet - What the cause?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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>
 
Back
Top