cindybowen
2 years agoNew Contributor
Save offline copy in excel addin
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 is not always the case. Has anyone else had this issue and what is the work around?