2 users pulling Excel sheet from Sharepoint; Formulas working correctly for one user, not for the other.

[Erin2466]

I have an Excel sheet that is pulled from SharePoint. The sheet is read-only and the formulas are locked to all users (I created the formulas). For most users, the formulas work as expected (#N/A's appear as the formula results until the data is entered). For a couple of us now, the formulas calculate with incorrect data as soon as the sheet is opened. The cells where the VLOOKUPS point to remain blank, so I am having a hard time understanding how actual data is being returned. When the data is entered, the users that had #N/A's at the beginning are receiving the correct data. The users that had results at the beginning are continuing to get the wrong results when data is finally entered into the cells.

I have compared my spreadsheet to a co-worker's by us both pulling the sheet from SharePoint, clicking on the same buttons, etc. and we are still receiving different results, yet the formulas are exactly the same. Is it an Excel memory issue? I have tried just about everything I can think of, Googled the issue, and am not getting anywhere. I need to try and resolve this as soon as possible.

Here is one of the formulas that I am working with. When the sheet opens, L3, L5 & L7 are all blank and should return #N/A.:
=IF(ISERROR(VLOOKUP(L7,'J:\Display Tools\[DISPLAY MASTER DATABASE.xlsx]MASTER DATABASE'!$D:$G,2,FALSE)),VLOOKUP(CONCATENATE($L$3,$L$5),'J:\Display Tools\[DISPLAY MASTER DATABASE.xlsx]COMPLETION TIMELINE'!$A:$T,18,FALSE), VLOOKUP(L7,'J:\Display Tools\[DISPLAY MASTER DATABASE.xlsx]MASTER DATABASE'!$D:$G,2,FALSE))

I would appreciate any help.