Forum Discussion
vlookup functions are replaced with result on save
I have a file from a client saved in .xls format (I don't know which version of Excel) that has many vlookup functions in the file. Once I enter data in the file and save, all of the cells containin...
Could there be an active add-in that causes this? The workbook itself does not remove formulas upon save:
If you open the attached version, are the formulas still present?
(Remark: the workbook contains a lot of non-functional code)
- Opening the attached version, the formulas are still present, and are still present after saving it again. This lead to another test. I downloaded the attached version to my computer, uploading it onto the server, and the behavior returns. Same is true in reverse for my original file. If I copy the file onto my machine's hard drive, the formulas don't disappear anymore. I've never seen this happen before and not sure if an add-in is at fault or something else. But at least I now have more information on when it happens and when it doesn't.
