Forum Discussion
XLOOKUP and VLOOKUP not refreshing unless I type the formula again
Is that for this specific file or for any one; and is this for XLOOKUP only or for any other formula?
- AlexMorphSep 15, 2021Copper Contributor
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.
- SergeiBaklanSep 18, 2021Diamond Contributor
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.