Forum Discussion
VLOOKUP Not Updating The Values Automatically
I've already tried all of them & they are enabled as it is. Let me share my details for you to troubleshoot further.
Excel Version - Microsoft 365 16.0.16130.20394
OS Version - 10.0.19044 Build 19044 Microsoft Windows 10 Enterprise
Storage Medium - Virtual (14.1GB)
Data connections - Not sure of this, please can you elaborate?
I will wait for a response from your end.
Regards,
Rohit
If data connections have been disabled and Excel is always asking you to enable content, it may prevent the automatic update of the data.
You can try enabling all data connections from the Trust Center settings and make sure that your data connections are set to refresh automatically.
To do this, go to the Data tab, click on "Connections," and make sure that your data connections are set to refresh automatically.
You can also manually refresh the connections from this menu.
If you have already tried these and the other steps before and the issue still persists, I'm at my wits end there too.
I would recommend reaching out to Microsoft Support for further assistance.
Ok
Yes there is a excel bug and updating vlookup does not work automatically.
Office 365 has some "great" goals and returns alot of money to microsoft but does not fulfill simple things like some refreshes, calculations and delivers ide bugs and others(to be short). I work in engineering field and excel has helped me spend some extra time for solving small problems like refreshing multiple vlookups in multiple sheets and without external links or such.
Everything was on autocalculation. Nothing on forums worked (so help and assistance=0, sorry microsoft!)
Simple solution:
Use old find and replace
search for "VLOOKUP" in all workbook and replace it with "VLOOKUP" after setting the search type to formula.
That's all.
Good one Microsoft!
Maybe it will change in OFFICE 366 (Can't wait!)
