(Msg. 1) Posted: Wed Aug 06, 2008 4:42 pm
Post subject: Keeping linked sheets relative... help! Add to elertz Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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.
(Msg. 2) Posted: Wed Aug 06, 2008 11:18 pm
Post subject: RE: Keeping linked sheets relative... help! Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
It occurs to me I can use INDIRECT and have the sheet name and filename
generated on the fly...
"Gaijintendo" wrote:
> 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.
(Msg. 3) Posted: Thu Aug 07, 2008 9:38 am
Post subject: Re: Keeping linked sheets relative... help! Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Aug 7, 1:18 am, Gaijintendo <Gaijinte....TakeThisOut@discussions.microsoft.com>
wrote:
> It occurs to me I can use INDIRECT and have the sheet name and filename
> generated on the fly...
>
This would be much better since Excel stores the complete path of the
filename and it is not dynamic, even on a Mac, which has a better
filing system than that available. (I assume this hasn't changed with
v2008) With your first post, the answer would be to Change Link Source
with each new file combo that you make, which might prove tiresome. If
you can make INDIRECT get the names correct for you, that would likely
be a lot smoother.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office