Forum Discussion
David13752230
Aug 13, 2021Copper Contributor
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...
BryanJohnson_ZA
Jan 15, 2024Copper Contributor
I ran across a similar problem today (1/15/2024) where my Vlookup formulas were being replaced with the function results on saving the workbook. A long story short I first needed to upgrade the Excel version from latest version of Excel (From XLS to XLSX) . Secondly the auto save function would enable, giving a message to delete emended OLX, (Which were saved in hidden sheets). After updating to the latest version of XL, deleting the hidden sheets and being able to enable the autosave function the problem disappeared.
Hope this helps.
- BryanJohnson_ZAJan 15, 2024Copper ContributorI forgot to add, this problem was only experienced when using Sharepoint (and opening the file in App), however when downloaded the file to the local drive there was no problem with the Vlookup function being replaced by its result.