=[Book.xls]Sheet1!A1 and not c:\blah\=[Book.xls]Sheet1!A1

  • Thread starter Thread starter Gaijintendo
  • Start date Start date
G

Gaijintendo

I am linking to external sheets but as soon as I enter
[FileName.xls]SheetName!A1
it resolves it to something like
='Macintosh:Users:MyName:Desktop:[FileName.xls]SheetName'!A1
Which is fair enough - that IS what I am referring to - but I want it to
Stay Relative.

Why? Because I would like to use this file as a template, and plop it in
lots of different folders - and see the data be gathered from other files -
so basically - I don't want Excel to fix the links!

Any suggestions. I am working with Excel 2008 but I assume it is much the
same on PC versions of Excel.
 
Hi,

The hyperlinks should always update to where they reside.
Go ahead and drop the copies into other folders the links
should still work. Or have I got the wrong idea of what
you mean?

HTH
Martin
 

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

Another book.xls issue 4
Keeping linked sheets relative... help! 2
reference to an external file 6
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ 5
Book.Xlt v Book.xls ???? 7
import =[test.xls]Sheet1!A1 - help 4
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updat 2
Upload Data from Sheet1 on Local Machine to Sheet1 on LAN 2

Back
Top