I am having trouble automatically updating the data in my file. Despite feeling confident that I have selected all the correct options, the updates are not happening as expected.
options excel
I have a sheet with my data :
sheet with my data
and a second sheet that retrieves my data (This sheet is used to link two data tables)
my data
At creation, everything is correct, but as soon as I generate my file with the new data, my columns do not update automatically.
I know that simply “validating” my formula recalculates it correctly, but I would like it to be done automatically upon opening.
Could you please assist me with this issue?
Thank you.
I have checked the Excel options and F9 or ctrl + shift + enter
options
o change
Céline HON is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.