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

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

updating links in 2007 excel files

Postby 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: 2139
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Re: updating links in 2007 excel files

Postby 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, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Return to “WordPipe, ExcelPipe and PowerPointPipe Support”

Who is online

Users browsing this forum: No registered users and 1 guest