Search and replace Microsoft Excel hyperlinks when you rename file servers and look in UNC link paths, shapes, text boxes and tables, headers and footers, sheet names and more.
- ExcelPipe
- Version :7.5
- License :Trial
- OS :Windows All
- Publisher :DataMystic
ExcelPipe Description
ExcelPipe is a professional software application designed specifically for helping you search and modify content from Microsoft Excel files, such as hyperlinks and UNC paths.
Multi-tabbed layout
The tool employs a multi-tabbed GUI in order to help you quickly define the actions that you want to trigger, specify the files to process, as well as configure a set of additional parameters related to backups and passwords.
Files can be imported in the working environment using the built-in browse button or drag-and-drop support.
Defining actions
ExcelPipe gives you the possibility to load a search/replace list from a user-defined file format (XLS, XLSX, CSV or TAB) or manually enter the search/replace values directly in the main window. You may add multiple entries in the list, remove or delete the duplicate rows, and delete all rows with just a single click.
What’s more, you can opt for normal or wildcard search type and look in cells, hyperlinks and addresses, shapes and text boxes, headers, footers, built-in and custom properties, links (OLE and DDE), chart titles, defined names, code modules, and sheet names.
You can make the application distinguish between uppercase and lowercase letters, search for occurrences that are whole words and not part of a larger word, display the found text before a replacement is made, and highlight the replacement with a custom color in order to make it easier to locate.
Processing files
ExcelPipe allows you to include subfolders and scan for files based on several filters, namely start folder, file types (e.g. ODS, XL), as well as start and end date. You may get filenames from a text file or build up a list with the files that you want to process by importing data from the currently opened files in Microsoft Excel and adding SharePoint URLs.
Several configuration parameters
If the files are protected, you may specify the password for opening them. You can make the utility keep the original file date, send alerts, process read-only files and hidden rows and columns, keep Excel visible while changes are being made, and prevent overlap of search/replace tasks. Last but not least, you are given the freedom to pick the Excel version and restart Microsoft Excel automatically if it becomes unresponsive.
An overall efficient tool
All in all, ExcelPipe comes with a decent feature pack for helping you migrate Microsoft Excel hyperlinks and UNC paths when servers are renamed, as well as update contact details such as names, addresses and phone numbers.