At one point in one of my macros, I open another Excel File, change a formula
in the current file to link to a range in the opened excel file, then close
the opened excel file.
When I close the file the current files formula has a reference error if I
recaluclate, but until It works if the file is open.
Is there an option I need to change?

Thank You,