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.

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.

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.

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

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

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

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

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