Named Range reference changes when I send file to some users

**fb7894** · 04-01-2013, 01:04 PM

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:

=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:

=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:

=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.

**ragavan.sridar1** · 04-01-2013, 01:33 PM

i think the reason for this is because the file dashboard current is saved in your personal drive, that is why the users are getting this error.

See if you can add the "SelGroupCash=1" sheet in the same workbook.

hope this helps.

**FDibbins** · 04-01-2013, 01:39 PM

Hi and welcome to the forum

Sounds to me like "SelGroupCash" is a reference to a name in another workbook (file)?

**fb7894** · 04-01-2013, 01:42 PM

Thanks Raga and Fdib.

No, there are NO links in my original spreadsheet. When I click on Data menu item, the Edit Link is disabled. This is the strangest thing.

When I post the file to SharePoint, the users are able to open the file with no problems. But when sending via FileLink, the formula gets corrupted.