Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced workbook linking
Here's the problem:
How do I link between workbooks without linking as in 'HD/documents/anotherfolder/excelfiles/analysis', but by going to the folder that holds all the files where I link to. Here's the situation: I have a folder called 'folderA', and in this folder there is 'folder 1' and 'folder 2', both have some excel files 'folder1file1.xls' and 'folder2file2.xls'. When I get a value from 'folder1file1.xls' and put it into 'folder1file2.xls' the doc ref becomes something like: 'HD/documents/anotherfolder/excelfiles/folderA/Folder1/folder1file1.xls' which is ok if you do not move the files. But what happens is that if you copy those to another computer and put them eg on the desktop, you need to relink all the files. For 2 files ok, but I have a lot of files and it takes ages to do so. Is there a way to 'go back' and say that this link needs to go down 1 folder (to folderA) and then up 1 folder (to folder1) where it will find the file? I need this since I want to show people my multiple excel files in my multiple folders. Thanks for any suggestions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbook linking cells not working within a workbook | Excel Discussion (Misc queries) | |||
Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
Linking Master Workbook & subordinate workbook | Excel Discussion (Misc queries) | |||
Linking to workbook | Excel Worksheet Functions | |||
HOW TO EDIT THE UPDATE CHANGES ON ADVANCED TAB IN SHARE WORKBOOK | Excel Worksheet Functions |