Sonia has attended:
Excel Intermediate course
Hyperlinks
I can add 10 hyperlinks from one file to different cells at any one time. Does anyone know how I can bookmark the folders so that every time I insert a new hyperlink it goes back to the last place i.e. the last file, so I don't have to keep opening the same folders to get back to the folder contacting the required files.
RE: Hyperlinks
Hi Sonia
Thanks for your post.
I am checking this with a few colleagues to see if we can find a way that will help you here.
I too insert hyperlinks in Excel and I usually find that Excel will look in the same folder where my spreadsheet is saved.
If you are using the same spreadsheet you may want to save your links in the same folder.
Regards
Jacob
RE: Hyperlinks
Hi folks. In Excel 2010 click the File tab, then the Info option. On the right of the screen click "Show All Properties". A list of fields will be revealed, one of which is "Hyperlink Base". Try clicking in there, adding the folder path you want your hyperlinks to default to and see if that does that trick.
Hope this helps,
Anthony
RE: Hyperlinks
Hi Anthony,
Thanks for your suggestion.
I've had a go adding in a folder path but it doesn't seem to make any difference when I try to add a new hyperlink to the document.
What I really want it to do is remember the last folder I opened when adding a new hyperlink so I don't have to keep opening x amount of folders to find the same folder over and over again.
Is this possible?
Sonia
