#### largeselection

##### Active Member

- Joined
- Aug 4, 2008

- Messages
- 356

So I'm encountering a weird issue so I'm wondering if someone can shed some light on it for me.

In a workbook, I can write a formula to reference a cell in a closed workbook like this:

='E:\Desktop\[Performance.xlsx]Data'!$B$158

The thing that is weird is that it only works some of the time...

So I get a #REF error, but if I open the workbook that it is referring to then I get the result of the formula. The weird thing is that I have 20 different workbooks which I reference and that formula works exactly as expected for 17 of them when they are closed. There are 3 that for some reason the workbook has to be open for the formula to work.

I would have thought it would be all or none. So either all of those formulas which reference all 20 worksbooks would #REF errors or none of them would be.

Any ideas why this would be happening?

I've checked the formula a bunch of times so I don't think it's incorrectly written (especially since it works correctly when the file is open).

Thanks for any ideas.