Page 1 of 1

excelpipe hyperlink updates but does not make the change

Posted: Tue Mar 27, 2007 1:06 pm
by darkstagg

I saw some other people are having this problem but no answer yet. The replace process says it finds everything and I check and it makes the change but the file does not receive the changes. for example
search and replace this \\bob\serverspace to r:\serverspace.

everything I have read says I should be able to do this in the excel spreadsheet. what am I doing wrong.

Posted: Wed Mar 28, 2007 3:42 pm
by DataMystic Support
Are you clicking the Search button by mistake instead of the Replace button?

Hyperlink Problem with Excel

Posted: Fri Mar 30, 2007 7:39 am
by darkstagg
Nope I am definitely hitting the search button

Posted: Fri Mar 30, 2007 7:46 am
by DataMystic Support
That would be the problem - you need to hit the Replace button, not the Search button.

If you actually did hit the Replace button, please email us a sample document and your settings (use File\Save As).

Mistyped that sorry

Posted: Fri Mar 30, 2007 9:58 am
by darkstagg
I am not hitting the search button I am hitting the replace button. Sorry.

Posted: Fri Mar 30, 2007 10:06 am
by DataMystic Support
Ok - please send us a sample file and your settings.

Posted: Fri Apr 13, 2007 11:02 am
by DataMystic Support
We've just updated all the office products, this bug has been found and corrected.

What's New in ExcelPipe v3.9.3

Now updates hyperlink Screen Tips as well when the 'Hyperlink addresses'
search location is chosen.
Office 2007 file extension of .XLS* now supported.
Import now accepts just columns A & B and assumes defaults.
Invalid Search Locations are now corrected and you have the option to
continue running the job.
Fixed bug with hyperlinks not being updated due to TextToDisplay property not
supported on older versions of Excel.
Fixed bug with Prompt on Replace always replacing.