I have several excel workbooks that have cells which have vlookups that take numbers from a different workbook. When I originally open the workbook, everything is fine. Then, when I open the source document, instead of the range in the vlookup, it says REF!, and all of the cells go blank. Why is this happening and how can I fix it?
Thank you!
Bookmarks