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

alphonsis
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?

Thanks

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

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
\budgets\
replace with
\converted budgets\
? Often MS Excel stores links as relative paths.
Regards,

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