ExcelPipe Find and Replace for Excel 8.5

Advertising
Software information
Platform:
Windows 7/8/Vista/XP/2000/Server
Publisher:
DataMystic
Price:
$99
File size:
11.20 Mb
Date added:
July 16, 2014
Screenshot:
Product page:
Description from the Publisher

Use ExcelPipe Find and Replace for Excel to migrate Microsoft Excel hyperlinks when you rename file servers, to translate files by applying massive search/replace lists, or find and replace your organization's name, address, website etc across thousands of worksheets - automatically.

ExcelPipe is designed as a hands-off tool requiring next to no user intervention, as you would expect for migrating large numbers of files. It copes with a myriad range of Microsoft Excel bugs, such as restarting Microsoft Excel every 1000 worksheets to avoid memory errors. It also copes with the largest variety of problem spreadsheets of any tool, ranging from password protected and corrupted spreadsheets to SharePoint locked spreadsheets.

  • Standardizing corporate name changes such as your organization's phone number, address, web site or CEO
  • Performing server consolidations where document links need updating
  • Migration of documents when a server is renamed or replaced and all Excel spreadsheet links need updating
  • Updating documents to use Microsoft Namespace Server mappings
  • Changing part numbers or SKUs across multiple files
  • Translating documents
  • Detecting which Microsoft Excel spreadsheets are password-protected (specify a blank password - these appear on the errors tab)

Features

  • Can update the connection strings of Query Tables and Pivot Tables - ADO, DAO, OLEDB and ODBC database queries, web queries etc.
  • 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, text boxes and tables
  • 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, Office 365 / Network Storage
  • 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.
Users reviews & testimonials

This software is not reviewed yet.

Advertising
Other downloads from this publisher

Jade is the world's best insulin dose calculator that predicts Hypos and blood sugar levels hours ahead. Designed for people with Type 1 diabetes and those using insulin. Regulated device.

Search and Replace multiple Microsoft Word documents. Change hyperlinks and UNC paths when servers get renamed, update names, addresses and phone numbers, translate with find/replace lists. Automatically handles passwords. Unicode compliant

PredictBGL is a the world's best insulin dose calculator that predicts Hypos and blood sugar levels hours ahead. Designed for people with Type 1 diabetes and those using insulin. Regulated device.

Fast text manipulation and data extraction engine. Fix websites, database data and electronic text with pattern match,convert DOS/Unix end of line characters,ASCII-EBCDIC,add/remove lines/columns,sort,split,join,database extracts,JScript/VBScript

TextPipe is the ultimate Webmaster tool for updating text. It handles an unlimited number of files and folders, and is unique in handling files of unlimited size. It performs one or more changes AT THE SAME TIME, and can search for MULTI-LINE text...