|
Connect using Native Tools to Avoid CorruptionTo search and replace Microsoft Excel spreadsheets and workbooks, a tool is required that connects natively to MS Excel to avoid data corruption and loss of information. Ability to Search Huge Numbers of SpreadsheetsThe ability to search huge numbers of spreadsheets is essential for any document migration, server renaming or link rectification process. Also, the process should not rely on loading the entire list of search files into memory at the start, as
Restart capabilityAlthough Excel has been around for a number of years, it still has memory leaks that mean that over time it becomes slower, less responsive and eventually hangs when processing large numbers of spreadsheets. Restart capability is an essential component of any tool that is used to mass-replace across Excel spreadsheets. RecommendationWe recommend the search and replace tool by DataMystic called ExcelPipe Search and Replace for Microsoft Excel.
ExcelPipe supports both perl regular expressions and EasyPattern regular expressions.
|