Prevent User from Opening Workbook Reference

[Ottsel]

I'm not completely sure how to phrase this request, so if there is a thread with the solution to this I apologies for asking.

Now, I have a Summary workbook that takes a value from another Data workbook using a formula reference.
Example: ='D:\Data\Schedule\[Work Flow.xlsm]Flow'!$U$9

So whatever is typed within Data workbook will reflect within the Summary workbook, but I'm finding that other users who open the Summary and click the referenced cell by mistake will be prompted to open the Data workbook, which is what I'm attempting to prevent. There is no need to open it, and at times it'll corrupt the cells within the summary workbook.

Is there a setting of some sort where even if they click the cell containing the cell reference it won't let them open the workbook containing the value?

 

[Micron]

You're saying that is what happens, or you think that is what will happen?
There is no prompt for me to open the source workbook, nor is there any attempt to do so just by clicking the cell with the path.

 

[Ottsel]

You're saying that is what happens, or you think that is what will happen?
There is no prompt for me to open the source workbook, nor is there any attempt to do so just by clicking the cell with the path.

That's what happens.

So, I click the cell with the referenced formula and receive this popup:

then you click OK and the workbook that cell is referencing will open. I'm trying to prevent this from occurring all together.

 

[Micron]

Doesn't happen to me. Can only guess that it's an option setting. I have this in a cell
='C:\Users\Micron\Documents\Excel\[AccessForum1.xlsx]Sheet1'!$I$8
When I enter/click the cell all that happens is that I see the path in the formula bar. I protected the source sheet to see if it made a difference (no). I inserted a link to the source workbook in that cell, and while it does open it, I don't get what you get. We're using same version as well.
Sorry, out of ideas at the moment.