Have been working on formulas for few days in Workbook1 that use IndexMatch to pull product data from another Workbook (Sourcebook) without any #REF! error issue, even if the source book was closed, using:
Now for some strange reason I’m getting #REF! errors in Workbook1 cells when I edit any formula in a Workbook1 cell that relates to the Sourcebook when its closed.
Can anyone suggest why I could do this previously without #REF error, but not now!!
Excel Formula:
INDEX('C:\Users\Me\Documents\SourceBook,MATCH(E8,'C:\Users\Me\Documents\SourceBook,0),1)………
Can anyone suggest why I could do this previously without #REF error, but not now!!