Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink in Excel spreadsheet
Hello, I have a about 1000 cells in a worksheet that are hyperlinked. The
hyperlink path changed on all to a file path that is not recognized. How do I change the hyperlink to the correct file path without going into to each cell and editing the path? The path is the same for all, just a different file name. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink in Excel spreadsheet
Hi,
Click the Microsoft Office Button , click Prepare, and then click Properties. In the Document Information Panel, click Document Properties, and then click Advanced Properties. Click the Summary tab. In the Hyperlink base box, type the path that you want to use. "Theresa" wrote: Hello, I have a about 1000 cells in a worksheet that are hyperlinked. The hyperlink path changed on all to a file path that is not recognized. How do I change the hyperlink to the correct file path without going into to each cell and editing the path? The path is the same for all, just a different file name. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink in Excel spreadsheet
Thanks, I tried that, but it doesn't change the hyperlink path.
"Eduardo" wrote: Hi, Click the Microsoft Office Button , click Prepare, and then click Properties. In the Document Information Panel, click Document Properties, and then click Advanced Properties. Click the Summary tab. In the Hyperlink base box, type the path that you want to use. "Theresa" wrote: Hello, I have a about 1000 cells in a worksheet that are hyperlinked. The hyperlink path changed on all to a file path that is not recognized. How do I change the hyperlink to the correct file path without going into to each cell and editing the path? The path is the same for all, just a different file name. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink in Excel spreadsheet
Changing this hyperlink base may stop the links from being changed again,
though. Saved from a previous post: If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But the good news is David McRitchie has done most of it for you: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Theresa wrote: Thanks, I tried that, but it doesn't change the hyperlink path. "Eduardo" wrote: Hi, Click the Microsoft Office Button , click Prepare, and then click Properties. In the Document Information Panel, click Document Properties, and then click Advanced Properties. Click the Summary tab. In the Hyperlink base box, type the path that you want to use. "Theresa" wrote: Hello, I have a about 1000 cells in a worksheet that are hyperlinked. The hyperlink path changed on all to a file path that is not recognized. How do I change the hyperlink to the correct file path without going into to each cell and editing the path? The path is the same for all, just a different file name. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink in Excel spreadsheet
I got the macro to work but it duplicates the new path in the hyperlink. Any
ideas? "Dave Peterson" wrote: Changing this hyperlink base may stop the links from being changed again, though. Saved from a previous post: If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But the good news is David McRitchie has done most of it for you: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Theresa wrote: Thanks, I tried that, but it doesn't change the hyperlink path. "Eduardo" wrote: Hi, Click the Microsoft Office Button , click Prepare, and then click Properties. In the Document Information Panel, click Document Properties, and then click Advanced Properties. Click the Summary tab. In the Hyperlink base box, type the path that you want to use. "Theresa" wrote: Hello, I have a about 1000 cells in a worksheet that are hyperlinked. The hyperlink path changed on all to a file path that is not recognized. How do I change the hyperlink to the correct file path without going into to each cell and editing the path? The path is the same for all, just a different file name. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink in Excel spreadsheet
Share the before version of the hyperlink.
Share the code you used. Share the after version of the hyperlink. Theresa wrote: I got the macro to work but it duplicates the new path in the hyperlink. Any ideas? "Dave Peterson" wrote: Changing this hyperlink base may stop the links from being changed again, though. Saved from a previous post: If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But the good news is David McRitchie has done most of it for you: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Theresa wrote: Thanks, I tried that, but it doesn't change the hyperlink path. "Eduardo" wrote: Hi, Click the Microsoft Office Button , click Prepare, and then click Properties. In the Document Information Panel, click Document Properties, and then click Advanced Properties. Click the Summary tab. In the Hyperlink base box, type the path that you want to use. "Theresa" wrote: Hello, I have a about 1000 cells in a worksheet that are hyperlinked. The hyperlink path changed on all to a file path that is not recognized. How do I change the hyperlink to the correct file path without going into to each cell and editing the path? The path is the same for all, just a different file name. -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink in Excel spreadsheet
ps. Share the version of excel you're using, too.
Theresa wrote: I got the macro to work but it duplicates the new path in the hyperlink. Any ideas? "Dave Peterson" wrote: Changing this hyperlink base may stop the links from being changed again, though. Saved from a previous post: If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But the good news is David McRitchie has done most of it for you: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Theresa wrote: Thanks, I tried that, but it doesn't change the hyperlink path. "Eduardo" wrote: Hi, Click the Microsoft Office Button , click Prepare, and then click Properties. In the Document Information Panel, click Document Properties, and then click Advanced Properties. Click the Summary tab. In the Hyperlink base box, type the path that you want to use. "Theresa" wrote: Hello, I have a about 1000 cells in a worksheet that are hyperlinked. The hyperlink path changed on all to a file path that is not recognized. How do I change the hyperlink to the correct file path without going into to each cell and editing the path? The path is the same for all, just a different file name. -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink in Excel spreadsheet
I tried it again and changed my destination path and it worked. Thanks for
your help. "Dave Peterson" wrote: ps. Share the version of excel you're using, too. Theresa wrote: I got the macro to work but it duplicates the new path in the hyperlink. Any ideas? "Dave Peterson" wrote: Changing this hyperlink base may stop the links from being changed again, though. Saved from a previous post: If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But the good news is David McRitchie has done most of it for you: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Theresa wrote: Thanks, I tried that, but it doesn't change the hyperlink path. "Eduardo" wrote: Hi, Click the Microsoft Office Button , click Prepare, and then click Properties. In the Document Information Panel, click Document Properties, and then click Advanced Properties. Click the Summary tab. In the Hyperlink base box, type the path that you want to use. "Theresa" wrote: Hello, I have a about 1000 cells in a worksheet that are hyperlinked. The hyperlink path changed on all to a file path that is not recognized. How do I change the hyperlink to the correct file path without going into to each cell and editing the path? The path is the same for all, just a different file name. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add a hyperlink (to a Word doc) to an excel spreadsheet? | Excel Worksheet Functions | |||
Update a hyperlink in excel spreadsheet | Excel Worksheet Functions | |||
sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
How to hyperlink pdf files in excel spreadsheet | Excel Discussion (Misc queries) | |||
My hyperlink in an excel spreadsheet will not save. | Excel Discussion (Misc queries) |