I have a really strange issue I'm hoping someone else can identify.

I have a spreadsheet with a formula which uses a Named Range:
Formula: copy to clipboard 
=IF(SelGroupCash=1,'Hidden - Cash'!BB123,AW123)


When I send this file to some users (using a file-sharing utility called FileLink), the formula changes to include the name of the workbook:
Formula: copy to clipboard 
=IF('Dashboard%20Current.xlsm'!SelGroupCash=1,'Hidden - Cash'!BB123,AW123)


What's even worse, is that other users are having the formula change to look at a local drive
Formula: copy to clipboard 
=IF('c:\users\ms44555\local\Dashboard%20Current.xlsm'!SelGroupCash=1,'Hidden - Cash'!BB123,AW123)


This breaks the formula as there is no file on the C:drive to reference.

Does anyone know what could possibly cause my formula to change? I am saving this file as a macro-enabled workbook. I'm using Excel 2010. Some of my users use 2007.

Thank you.