Hi,

I've got a couple hundred links to folders in an excel spreadsheet. The
folders are all moving to another drive. Is there a way I can do a
Find&Replace but within the hyperlinks?

For example, on every link I would want to change
"\\fs_users\Everyone\USER\Paper Archive\" to "C:\Documents and
Settings\USER\Desktop\Paper Archive\"

Is this possible in Excel 2000? If not, maybe in a newer version?

Thanks,
Sean

From the Find replace window .. Replace Tab

Select Lookin formulas
--
If this post helps click Yes
---------------
Jacob Skaria


"Sean Carter" wrote:

Hi,

I've got a couple hundred links to folders in an excel spreadsheet. The
folders are all moving to another drive. Is there a way I can do a
Find&Replace but within the hyperlinks?

For example, on every link I would want to change
"\\fs_users\Everyone\USER\Paper Archive\" to "C:\Documents and
Settings\USER\Desktop\Paper Archive\"

Is this possible in Excel 2000? If not, maybe in a newer version?

Thanks,
Sean

Oops...I took this as formulas..sorry
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

From the Find replace window .. Replace Tab

Select Lookin formulas
--
If this post helps click Yes
---------------
Jacob Skaria


"Sean Carter" wrote:

Hi,

I've got a couple hundred links to folders in an excel spreadsheet. The
folders are all moving to another drive. Is there a way I can do a
Find&Replace but within the hyperlinks?

For example, on every link I would want to change
"\\fs_users\Everyone\USER\Paper Archive\" to "C:\Documents and
Settings\USER\Desktop\Paper Archive\"

Is this possible in Excel 2000? If not, maybe in a newer version?

Thanks,
Sean

Hi Jacob,

Sorry, I should have specified I am using Office 2000. When I click on the
replace button in the Find window, the option to search within formulas
disappears. Will I need to do this in a newer version?

Thanks,

"Jacob Skaria" wrote:

From the Find replace window .. Replace Tab

Select Lookin formulas
--
If this post helps click Yes
---------------
Jacob Skaria


"Sean Carter" wrote:

Hi,

I've got a couple hundred links to folders in an excel spreadsheet. The
folders are all moving to another drive. Is there a way I can do a
Find&Replace but within the hyperlinks?

For example, on every link I would want to change
"\\fs_users\Everyone\USER\Paper Archive\" to "C:\Documents and
Settings\USER\Desktop\Paper Archive\"

Is this possible in Excel 2000? If not, maybe in a newer version?

Thanks,
Sean