Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

Linking

Posted by Dave Papenfuse on February 14, 2002 8:12 AM

When I link to another spreadsheet an absolute address is returned. I would like to be able to have a relative cell referenced so that when I past eht link to other cells it will correspond to additional cells in the linked spreadshee. Now I have to strip the "$" out of the linked cell reference before copying it to other cells.
Does any one have any ideas?

Thanks,
Dave

Re: Linking

Posted by Chris D on February 14, 2002 2:49 PM

if you have loads of these links to do, maybe you could move the sheet from spreadsheet 2 into your working spreadsheet so it's not an external link when you do it, then, when finished, move it back

I tested it and it seems to work...

HTH
Chris

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.