Easily search and replace text across multiple Excel spreadsheets! ExcelPipe will automatically replace text accros multiple Excel spreadsheets. Eg. If your company changes phone number or address, you can run ExcelPipe across your entire file server or web site to fix all affected spreadsheets in one hit. There is no limit to the number of spreadsheets that can be processed.
Use it for…

• Standardizing corporate name changes such as your organization’s phone number, address, web site or CEO
• Performing server consolidations where document links need updating
• Server renaming or replacement where document links need updating
• Updating documents to use Microsoft Namespace Server mappings
• Changing part numbers or SKUs across multiple files
• Translating documents
• and much more.

Features

• NEW! Now can search/replace inside Chart Titles and Defined Names
• Now can change the path of embedded OLE and DDE links to databases and other sources.
• Unicode search and replace
• Search-Only mode
• Search and replace with all Excel’s options such as Match Case, Whole Cell/Partial Cell etc, plus more.
• Files can be specified by folder (optionally including sub folders), by importing from a list file, or by pasting in a list of filenames
• Search and replace inside hyperlink addresses
• Search and replace UNC link paths
• Search and replace inside shapes
• Search and replace inside built in document properties and custom properties such as Title, Subject, Author, Company etc
• Search and replace inside headers and footers
• Search and replace inside VBA Code Modules – even if protected with a password.
• Search and replace inside Sheet Names e.g. Sheet1, Sheet2, Sheet3
• Works with Windows SharePoint Services document libraries
• Fully Unicode compliant – search and replace international character sets (unlike competing products)
• Allows replacements to be longer than 255 characters (Microsoft Excel limits this to 255)
• Control the spreadsheet types used – so you can process .xls,  or any custom spreadsheet type
• Can be automated or scheduled via the command line, and settings are saved in an easy-to-edit or generate XML format
• Handles password-protected spreadsheets – these get flagged for manual follow-up
• Read only documents can be processed or skipped
• Easy to install/uninstall
• The original file date and time stamp can be preserved
• Does not alter documents unless a change is made. In Search Only mode, no changes are made.
• All settings can be saved and re-loaded later, allowing you to manage multiple jobs.
• Full backup facility, and the ability to rollback if the results are not acceptable.
• Full audit trail on completion, logging the changed documents, unchanged documents and error documents.

Technical specifications

• Microsoft® Windows® 7 and x64, Vista®, Vista 64, 2008/2003 Server, XP, 2000
• All versions of Microsoft Excel (2010, 2007, 2003, XP, 2002, 2000) or Microsoft Office (2010, 2007, 2003, XP, 2002, 2000), but not Excel 97
• Hard Disk with 2 MB free disk space
• 32 MB RAM