How can I create cross-workbook references that arn't ten miles l.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a cell calculation that uses data from other workbooks
(several, actually). The problem with the way Excel references the other
workbooks is that is uses full file path for each workbook referenced, thus
making the cell formula HUGE. Also, the absolute reference makes moving the
primary workbook or its antecedents impossible without breaking the links and
having to rewrite them all, arrrrggg!! Is there anyway to get Excel to
recognize relative references, similar to how web pages are built?

Thanks.
 
If there is any way you can change the external references to become sheet
tabs in the document containing the references, they will then become
relative rather than absolute.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

References to external workbooks 4
How to create absolue path link to another workbook (Excel 2003) 1
How to create absolute link to cell in another workbook (Excel 2003) 1
Can I create a 3-D reference from multiple workbooks 2
Creating your own reference 4
How can I transfer formulas between 2 Excel workbooks? 4
Absolute reference when creating links to another workbook? 3
How do I call number values form one workbook to another workbook 3

Back
Top