Hyperlinks in Excel not working

  Ray5776 15:31 24 Mar 07
Locked

Hello everyone, can someone help on this one please.
I have set up an Excel spreadsheet to list invoices and payments made and the dates etc.
This works fine but I have also tried to insert hyper links so that if I click on the date in row 1 then the relevant invoice appears on the screen.
I had this working perfectly about 2 weeks ago but I am now getting a message (cannot open the specified file) with some of them. Any clues on this, it does not happen with every file just some of them.

Ray

  VoG II 15:40 24 Mar 07

I assume that the hyperlink is to an external document, not to a location within your workbook.

If you hover the cursor over the hyperlink a Tooltip should give you the full path to the document. Does the document still exist in that location?

  Simsy 15:43 24 Mar 07

perhaps moved or renamed the files? This would cause this to happen.

Put your cursor over the link(s), right click and choose "Edit Hyperlink"... in the box that appears make sure that the path is correct, and the name is spelt correctly.

Apologies if this is not the cause of the problem.

Regards,

Simsy

  Ray5776 16:19 24 Mar 07

Hi again,
I use a usb stick for this (backed up to HDD)

On the stick I have one folder only nothing else.
When I open this I have two subfolders (Invoices) and
(Spreadsheet).

If I hover over the link I do get the path and when I look in invoices the file is there and I can open it.

Looking in edit hyperlink the path appears correct but I still get the message.

I have also noticed that the format of the date on the non working links differs from that of those that do i.e. working links xx.xx.xx non working xx.mar.xx
if you see what I mean here.

There appears to be only seven links at the moment that do not work all in March but I would like to sort this to avoid future problems

  Ray5776 16:29 24 Mar 07

VoG,

It seems to me that if all the invoice files could be stored in the workbook then that would be the ideal solution.

Ray

  VoG II 16:39 24 Mar 07

In Excel 2003 and earlier you can do this (I haven't worked it out in Excel 2007 yet!).

Insert > Object > Create from File, Browse to find the file, click OK, tick Display as Icon and Link to file.

You could do this on a separate sheet, then include hyperlinks to the cells on that sheet containing the invoices.

  VoG II 16:41 24 Mar 07

Actually, it is exactly the same in Excel 2007.

  Ray5776 14:33 25 Mar 07

Hi again,
I am trying to import the "Folder" containing the invoices into sheet 2 of the workbook. Have been unable to do this and think that I would have to import each "File" individually and set up new hyperlinks, a somewhat tedious process.

For the moment I will leave the invoices in their current location and repair the non functional links
(only 7) and see if there are any further problems unless someone has any other ideas.

Thanks Ray

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…