Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Mass find/replace tool for Excel documents

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tammy - 14 Mar 2008 16:39 GMT
Hello,

Not sure if this is where I should be, but I am referring to Excel docs, so
I'll start here. I received this email today, and was wondering if anyone had
any suggestions:

"Wondering if anyone had any recommendations for a mass find/replace tool
for use with Excel documents.  Many of our departments have dozens if not
hundreds of Excel documents that are linked to other spreadsheets on the
server.  The AD migration has changed the G:\ drive mapping, and now these
links need to be updated.  Rather than update each spreadsheet manually, we’d
like to run some type of find/replace on the department’s G:\ drive to update
all the links in one shot.  

We found a tool called “ExcelPipe” which seems to work fairly well, but it’s
pricey and the company is inconveniently located in Australia.  I’ve found
several shareware/freeware tools, but they seemed either unreliable or
lacking features."

Any suggestions? Do you need any further information?

Thanks!
Gary''s Student - 14 Mar 2008 18:09 GMT
Why do the documents need to be changed at all?

The whole point of using G:\ in links is that you only need to re-map the
network drive definition on the computer instead of  doing mass edits to
files.  If you had used something like:

\\Server57s\FINANCE\Statements\1stqtr.xls

Then each reference would have to be changed.
Signature

Gary''s Student - gsnu200773

> Hello,
>
[quoted text clipped - 18 lines]
>
> Thanks!
Tammy - 14 Mar 2008 18:39 GMT
Hi Gary"s Student - thank you for replying to my post.

"G:\" is the new drive location - it replaced previous drives (K: & P:, for
example), which no longer exists. However, there have been new folders
created to meet specific purposes on the new G: drive. Therefore, if a link
used to be
"K:\OfficeDeptFolder\filename, it's now something like
"G:\MAX-filer\CouldBeAnotherFolderName\OfficeDeptFolder\filename"

Based on your response, I'm not sure if I'm explaining this correctly...what
else should I provide?

> Why do the documents need to be changed at all?
>
[quoted text clipped - 28 lines]
> >
> > Thanks!

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.