Forum Discussion
XLOOKUP and VLOOKUP not refreshing unless I type the formula again
Hi there, As explained in the title my main issue is that my xlookup and vlookup formulas aren't refreshing when I change the source data. The only way to have it showing new results instead of o...
SergeiBaklan , thanks for taking the time.
It is for this document and all other that have been build from this one. (It is a sales dashboard that looks at a report to pull the relevant data. Each document made from a the original one will have a dashboard with different criteria but same xlookup and same source copied in a tab in all these docs)
I only have the issue for 4 columns whereas other columns seems to be refreshing when the data on the source tab is modified.
If that is for the specific cells in the specific file it's hard to say something without the file. Perhaps you may reproduce on sample file or share main one removing all sensitive information from it.