Cannot figure out how to find and replace excel links

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

Cannot figure out how to find and replace excel links

Post by tbryant »

I have a word document with a number of inline shapes linked to an excel document; i.e. a table that is linked to the excel file c:\BlahBlah\Arizona.xls, coordinates: Table1!R2C1:R19C9 (Table1 being the name of the worksheet within the excel file, found in the grid co-ordinates A2:I19). If I search for the string Table1!R2C1:R19C9, I cannot seem to locate it (in order to ultimately change the co-ordinates).

I am using word 2002. It seems as though I have tried all the possible search locations selected, as well as "inside field codes" selected.

Is what I am seeking to do possible?
User avatar
DataMystic Support
Site Admin
Posts: 2229
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Post by DataMystic Support »

No, it's not possible because the search location is inside an OLE link, not inside any 'normal' kind of field.

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads
Post Reply