Forum Discussion
indexing formula not updating its reference automatically
hi, I have an excel sheet that uses an indexing formula to find info on the second sheet of the workbook. this second sheet is updated every so often by using another macro from another workbook....
sebastian358 Did you check if the Calculations Options is set to Automatic for the sheet where the formulas are not getting updated?
Manual calculation is preferred when the sheet is heavy with formulas and references from other workbooks/sheets etc. as it can take time to evaluate the formulas each time the file is saved, opened etc.
You can use F9 to re-evaluate the workbook of Shift+F9 for the sheet (the buttons next to the dropdown selected).
Use Like if this post helped to solve your issue and Mark as Best Response if the request can be closed.