Lost Links

[Guest]

Hello everyone,

I experienced a problem that caused me to have to rename a copied version of a spreadsheet to its original name. Upon doing so, I seem to have lost all the links I had established to several hundred .doc files. Is there a way to re-establish hyperlinks to files with out having to do so manually?

 

[Dave Peterson]

Depends on what's left.

If you had a nice friendly name in the cell and the real name/address in the
hyperlink, then I think you're out of luck.

If the value in the cell was the name of the document (with the full path), then
you could recreate the links.

If the cell was the name of the document w/o the path, but the path was always
the same, you could recreate the links.

By the way, I don't recall any problem I've had when I used the worksheet
formula =hyperlink() to create the hyperlink.

Maybe you could use that (in helper cells) when/if you have to recreate them.