| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
link to files in this folder
Tools, Options, General, Web Options, File, UNcheck "Update Links on save"
Graham Y wrote: I have 12 monthly folders each containing 4 sheets & a summary sheet, is there anyway I can set up the links in my summary sheet, to look at the files in this folder? I just tried it with two files. Both open shows just the file name, Close the linked to file and I get the full path, So I thought I'd try the old DOS . to mean this directory, but all Excel did was put the full path back in. I was hoping to have a 'template' folder which I can just copy and rename each month without going in to the summary and re-pointing all the links. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I link an Excel worksheet to a folder? | Excel Discussion (Misc queries) | |||
| Opening a folder by clicking on a link | Excel Discussion (Misc queries) | |||
| Copying all files in a folder to new folder | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
| How do I link a FOLDER to an excel cell/row? | Excel Discussion (Misc queries) | |||
Threaded Mode
