Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

Links Broken when file transfered to another's box

Posted by Bill Thale on June 11, 2001 5:01 PM

I have formulas that rely on data in another spreadsheet.

The formulas are using full naming, i.e.,

=SUMIF('\\Thale\c\[TEST.xls]East'!$C$1:$Z$1,EOMONTH($C$3,0),'\\Thale\c\[TEST.xls]East'!E15:AB15).

This works on the original machine, but when transferred to another machine the formulas come up #value#. If I then open the links, it finds the file and opens it.

What's up with that.

Re: Links Broken when file transfered to another's box

Posted by Beb O. on June 11, 2001 6:39 PM

That is weird. In the Links dialog box, do you have the link specified with UNC or with local mapping? If it's local, respecify it with UNC by going to Network Neighborhood and finding the file. I work with heavily linked worksheets and by keeping everything UNC I have no problems.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.