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