excelpipe hyperlink updates but does not make the change

[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.

[DataMystic Support]

Are you clicking the Search button by mistake instead of the Replace button?

[darkstagg]

Nope I am definitely hitting the search button

[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).

[darkstagg]

I am not hitting the search button I am hitting the replace button. Sorry.

[DataMystic Support]

Ok - please send us a sample file and your settings.

[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.