I need the sheet to reference another file and update accordingly. I have
entered the destination of the file required and cells to be referenced etc.
This works fine if both files are open at the same time.

However, when I open the main file, it asks me if I want to update, and I
have to choose yes as it is referencing daily reports over a month, so I need
it to update automatically. When I choose yes, the fields error and don't
populate correctly, even though the destination in the formula is still
correct. What am I doing wrong?

Thanks in advance