Data refresh question

[HeRoseInThree]

I have a spreadsheet that has my driver's names (and other data) and another spreadsheet that I use that data for.

When a driver is removed from the driver data spreadsheet, I receive an error on the other sheet...

The formula works well until I remove a driver.

The formula I use:
='[N&I Driver Data.xlsx]Driver Data'!D53
If I remove the driver in D53 I receive a #REF ! error

ANY help would be appreciated!!!

 

[Tom Urtis]

I don't know what you mean by "How did you insert the code: "picture"?".

You can enclose formulas or code to make the text mono font by selecting the line(s) and clicking the CODE icon at the far right of the menu bar above each post, or you can manually type

 and

before and after (respectively) the start and end of what you want to format as code.