Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hyperlinks
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Hyperlinks
Resolved · High Priority · Version 2010
Reply Wed 17 Aug 2011, 16:35Delegate Sonia said...
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.
For upcoming training course dates see: Pricing & availability
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
Reply Wed 24 Aug 2011, 10:28Delegate Sonia said...
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
|