Regional Healthcare Network: Server Migration with ExcelPipe

The Challenge

A regional healthcare network operating 14 hospitals and 60 outpatient clinics was migrating its IT infrastructure to new servers as part of a data centre consolidation. During the planning phase, the IT team discovered that more than 12,000 Excel spreadsheets across the organisation contained hardcoded references to the legacy infrastructure — ODBC connection strings pointing to old database servers, UNC file paths referencing decommissioned file shares, hyperlinks to internal intranet pages that would move, and embedded data queries tied to specific server names. These spreadsheets powered critical compliance reporting, patient volume tracking, financial reconciliation, pharmacy inventory management, and quality metrics dashboards required by regulatory agencies. Any disruption to these reports during the migration weekend would violate healthcare compliance requirements and potentially affect patient care coordination across facilities. The migration window was limited to a single weekend to minimise operational impact, making manual editing of 12,000 files impossible.

The Solution

The healthcare network deployed ExcelPipe to perform batch find-and-replace operations across all 12,000 spreadsheets in a single automated run. ExcelPipe was configured with replacement lists covering old server names, database connection strings, UNC paths, intranet URLs, and shared drive mappings. The tool processed spreadsheets directly on network shares without requiring Microsoft Excel to be installed on the processing server, which was critical for the locked-down healthcare IT environment. ExcelPipe handled workbooks containing external data connections, pivot table sources, named ranges with path references, and VBA macros referencing server names — updating all reference types consistently. The IT team ran a validation pass on a test subset first, confirmed all connections resolved correctly against the new servers, then executed the full batch during the Saturday night migration window. Detailed logs documented every change for the compliance audit trail, and the entire 12,000-file processing completed in under 2 hours.

Results

Products Used

• ExcelPipe — Batch find-and-replace across 12,000 Excel spreadsheets including data connections and UNC paths
• WordPipe — Complementary updates to Word-based policy documents referencing the same servers

Why ExcelPipe for Healthcare?

• Updates data connections — ODBC strings, pivot table sources, and external data queries all updated in place
• Handles VBA references — Server names in macro code updated alongside cell content
• No Excel required — Processes .xls and .xlsx files without Microsoft Excel installed
• Network share support — Operates directly on files across multiple network locations
• Compliance audit trail — Detailed logs satisfy healthcare regulatory documentation requirements
• Preserves workbook integrity — Formatting, formulas, charts, and protection settings remain intact