| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping linked sheets relative... help!
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keeping text format in linked cells | Excel Worksheet Functions | |||
| keeping rows together during column sorts of linked worksheets | Excel Worksheet Functions | |||
| Keeping Cells linked | Excel Discussion (Misc queries) | |||
| Keeping the same format in linked worksheets | Excel Worksheet Functions | |||
| How do I copy a formula with relative ref. keeping the same ref.? | Excel Discussion (Misc queries) | |||
Threaded Mode
