ReplaceMagic.Excel is used by IT staff to fix broken links in your Excel documents when server gets renamed, to change header/footer when for example contact details are changed, by translators and other people who need to do massive search/replace in Excel documents.
ReplaceMagic allows you to make scans and search&replace anywhere on your network where you have access from computer where ReplaceMagic is installed but also on your SharePoint.
To use ReplaceMagic, create list of search/replace pairs and specify where in the document it should be found. Then you tell it which folders to process and it is it - it can not be more simple! Use it for...
Performing server consolidations where document links need updating
Server renaming or replacement where document links need updating
... and more
Supported File Formats
- .xls, .xlt, .xlw, .xla – Excel 97–2003 binary formats
- .xlsx, .xltx – Excel 2007–2019 and Microsoft 365
- .xlsm, .xltm – macro-enabled workbooks
- .xlsb – Excel binary workbook format
- All formats: Office 2000–2019 and Microsoft 365
Document Areas Processed
- Hyperlinks and hyperlink display text
- OLE object links
- External link sources (Edit Links)
- Excel Connections and Power Queries
- Pivot table data sources
- VBA macro file path references
- Headers and footers
- Text cell content
Common Use Cases
- Fix broken external data source links after server migration (Edit Links shows red broken references)
- Repair Power Query source paths after storage restructuring
- Update hyperlinks in Excel workbooks after SharePoint or network drive migration
- Fix OLE object references to charts or files embedded in Excel
- Update VBA macro paths referencing old server names
- Repair Pivot table external data connections after database server rename
Key Features
- Processes old .xls and modern .xlsx and .xlsm formats
- Handles Excel-specific link types not available in other editions: link sources, connections, Power Queries, Pivots
- Excel link source path limit: 253 characters (old format), 2000 characters (new format) — replacements respecting these limits
- Multi-threaded parallel processing of large Excel libraries
- Native SharePoint support: repairs links in Excel files stored on SharePoint Online and on-premises
- Search and replace inside the headers and footers of multiple sections
- Search and replace inside hyperlinks and hyperlink addresses
- Search and replace UNC link paths
- Search Only mode - very handy for detecting where replaces would occur
- Search and replace international character sets
- Handles any number of sub folders
- Handles documents with password for open or modify
- Easy to install/uninstall
- The original file date and time stamp will be preserved.
Supported extensions:
Microsoft Excel-Document (*.xls,*.xlt,*.xlw,*.xla,*.xlsx,*.xlsm,*.xlsb,*.xltx,*.xltm)
Supported Excel versions: 2000-2013 and most of the features in 2016/2019/Office 365
Requirements: ReplaceMagic needs .NET 4.8.0 or higher so any OS supporting that will work for ReplaceMagic
