We have files that utitlize vlookups or sumif formulas when we save an
offline copy the formulas do not work after. I have found many times
that if I change the value I am referring to in the formula to a text
format, it saves them, but sometimes it ...