Hyperlinks

Resolved · High Priority · Version 2010

Wed 17 Aug 2011, 16:35 Delegate 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.

Fri 19 Aug 2011, 10:51 Trainer Jacob said...

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

Mon 22 Aug 2011, 11:40 Trainer Anthony said...

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

Wed 24 Aug 2011, 10:28 Delegate 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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips