updating links in 2007 excel files

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

Moderators: DataMystic Support, Moderators

Post Reply
Posts: 1
Joined: Fri Apr 25, 2008 4:55 am

updating links in 2007 excel files

Post by alphonsis » Fri Apr 25, 2008 5:01 am

I'm looking to update the links in our excel spreadsheets to point to the newly converted files.

='L:\financials\budgets\Project Sheet M ''08\[Services Exp M ''08.xls]600'!E32

to become

='L:\financials\converted budgets\Project Sheet M ''08\[Services Exp M ''08.xlsx]600'!E32

I've tried various permutations of the search functions but the program doesn't seem to find the string.

I saw an older post from 2004 that says this is impossible because of where the data is stored. Is this still the case?


User avatar
DataMystic Support
Site Admin
Posts: 2235
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Re: updating links in 2007 excel files

Post by DataMystic Support » Mon Apr 28, 2008 9:49 am

That's certainly not the case - and I can't see the post that mentions that.

Did you try just searching for
replace with
\converted budgets\
? Often MS Excel stores links as relative paths.

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads

Post Reply