Page 1 of 1

excelpipe hyperlink updates but does not make the change

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

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.