Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Keep hyperlinks uon archive
I use a spreadsheet to track documents on projects and link the number to each actual documet for quick retrieval. The project I'm setting up will be of many years duration so the early portions will be archived. I want to maintain the links when the sheet gets moved to archive. The spreadsheet will be in a common folder with the documents. Will the links move with the folder or is there a step that can be performed prior to the move, or a set-up protocol at the inception of the spreadsheet? TIA -- zxc |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
Keep hyperlinks uon archive
It may depend on your Excel version (which you didn't mention - it
always helps to know). However, I *think* that unless you have specified a Hyperlink Base in File Properties, hyperlinks to files in the same folder will be relative in Excel 2002 and later. So moving the workbook containing the links and the files to which the links point from one folder to another should preserve the integrity of the links in those circumstances. It should be reasonably easy to try a test in your environment to confirm that. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Archive | Excel Discussion (Misc queries) | |||
Adding Hyperlinks to "Archive" | Excel Discussion (Misc queries) | |||
Archive for ng? | Excel Worksheet Functions | |||
Archive | Excel Discussion (Misc queries) | |||
archive | New Users to Excel |