Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Linked Workbooks Sent as Attachments
Posted by Mason on May 10, 2001 10:52 AM
I have a spreadsheet that has different cells linked to other cells in other sheets in different workbooks. I sent one worksheet as an attachment to a colleague who changed some of the data. When she sent it back, the links in the formula bar read C:Attach/ instead of C:MyExcelFiles. I can go in manually to each cell and type in the correct path in the formula bar, but my question is: Do I need to in the future send her all linked files and have her put them in a folder with the same name as the one on my computer? Or is there another way. Thanks very much.

Re: Linked Workbooks Sent as Attachments
Posted by Dave Hawley on May 10, 2001 11:30 AM
Hi mason
Go to Edit>links and select Change Source.
Dave
OzGrid Business Applications

Re: Linked Workbooks Sent as Attachments
Posted by Mason on May 10, 2001 12:38 PM
Thank you very much, Dave, this really helps me a lot!
Mason

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.