I work with multiple Workbooks/files that are set up the same. I have to pull some data from those workbooks to a Master workbook
I am working in Excel 365.
Example of folders/files: Alabama126, Alabama365, Georgia222, Tennessee576
Before I could put a formula in cell A1 to pull information from a cell in ALABAMA126 and copy that formula across my spreadsheet. Then just change "ALABAMA126" in the formula to one of the other such as "Tennessee576" and it would pull information from that file without me having to open up that file. WELL for whatever reason when I try to do that.. it wants me to open up the file before it will update the formula and give me the correct data.
What is not set up correctly or what am I doing wrong?
I am working in Excel 365.
Example of folders/files: Alabama126, Alabama365, Georgia222, Tennessee576
Before I could put a formula in cell A1 to pull information from a cell in ALABAMA126 and copy that formula across my spreadsheet. Then just change "ALABAMA126" in the formula to one of the other such as "Tennessee576" and it would pull information from that file without me having to open up that file. WELL for whatever reason when I try to do that.. it wants me to open up the file before it will update the formula and give me the correct data.
What is not set up correctly or what am I doing wrong?