excelpipe hyperlink updates but does not make the change

Discuss WordPipe, ExcelPipe and PowerPointPipe. Get help with installation and running, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
darkstagg
Posts: 3
Joined: Tue Mar 27, 2007 12:50 pm

excelpipe hyperlink updates but does not make the change

Post 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.
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

Are you clicking the Search button by mistake instead of the Replace button?
darkstagg
Posts: 3
Joined: Tue Mar 27, 2007 12:50 pm

Hyperlink Problem with Excel

Post by darkstagg »

Nope I am definitely hitting the search button
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post 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).
darkstagg
Posts: 3
Joined: Tue Mar 27, 2007 12:50 pm

Mistyped that sorry

Post by darkstagg »

I am not hitting the search button I am hitting the replace button. Sorry.
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

Ok - please send us a sample file and your settings.
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post 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.
Post Reply