Hey guys,
I have a file with a lot of linked data, which can't find any data via the Vlookup function when the source files are closed. It works perfectly until I decide I want to sort the data in a different way, which is when I get #REF! errors all over the place. However, when I open the source files it all works again.
Does anyone know what the cause of this might be and how I can fix it? I double checked the code to the source like a 100 times and I don't think that's what's wrong.
I have a file with a lot of linked data, which can't find any data via the Vlookup function when the source files are closed. It works perfectly until I decide I want to sort the data in a different way, which is when I get #REF! errors all over the place. However, when I open the source files it all works again.
Does anyone know what the cause of this might be and how I can fix it? I double checked the code to the source like a 100 times and I don't think that's what's wrong.