I run into a common issue: I need to access large files. These files cannot be opened two at one time without crashing Excel. I need to use the address function to access specific sheets within that file. So, when I jump from one file to the other, the formula REFs out. Is there any way to call in the data without having the file open? Yes, I could hard code everything but I need the file to be more dynamic.

I am not 100% sure how linked files work in Excel. Does anyone know a good website that I can review? Thanks


Thank you all!