Forum Discussion
indexing formula not updating its reference automatically
Are you working with multiple workbooks/files or different worksheets in the same file, as you mentioned "closing file", "file finder"...
The references don't update even if the other file is open in the background?
"Update Values" from Edit Links window also does not update the references?
I hope the Edit Links is set to Automatic (Default) value. Just checking, in case you missed it.
https://excelribbon.tips.net/T007556_Updating_Links.html
nimesht so there is one sheet that I manually create and then I have a macro that copies that sheet into several other workbooks, the work books consist of two sheets the first sheet is the sheet that has the info boxes in it, the second sheet is the data sheet that the macro updates, the indexing formula is in the first sheet of the workbook (one in each box that displays data) when the macro is run from the original workbook to update the other workbooks it copies the data fine. (This process copies cells opens another workbook and then pastes and closes the workbook) however when I then open one of the now updates workbooks I have to re reference the indexing formula as if I don’t the data won’t show up on the first sheet, the data in the first sheet references the second sheet all inside the same workbook.