What's New in ExcelPipe

ExcelPipe is here, and has many new time-saving features to help you work smarter.

to download the full version upgrade Frequently Asked Questions (FAQ), Online manual Product Updates (What is this?) Sign up for the DataMystic Newsletter ExcelPipe Discussion Forums For Resellers and Affiliates

Major New Features

• Highlight color can now be set. Your color is matched to Excel 2003's standard 56 colors, or the actual color used with Excel 2007 and 2010.
• Status dialog now opens file on double-click of subsidiary search/replace phrases. Right-clicking on a filename or phrase now gives a menu to open the file, or its containing folder.
• Now can alter the Connection strings of Query Tables and Pivot Tables - ADO, DAO, OLEDB and ODBC database queries, Web queries etc.

As always, ExcelPipe will read filters from ALL old versions without any changes being required.

Registered Users / Current Customers

Login and download the upgrade, and/or see if you are entitled to an upgrade

Related Applications You May Need

TextPipe - search and replace text files, web sites and more
WordPipe - search and replace Microsoft Word documents
DataPipe - search and replace database records, including Microsoft Access and SQL Server
PowerPointPipe - search and replace Microsoft PowerPoint presentations

Detailed Changes Log

What's New in ExcelPipe v5.6 - February 8, 2012
===============================================

* Highlight color can now be set. Your color is matched to Excel 2003's 
standard 56 colors, or the actual color used with Excel 2007 and 2010.
* Status dialog now opens file on double-click of subsidiary search/replace 
phrases. Right-clicking on a filename or phrase now gives a menu to open the 
file, or its containing folder.
* Now can alter the Connection strings of Query Tables and Pivot Tables - ADO, 
DAO, OLEDB and ODBC database queries, Web queries etc.


What's New in ExcelPipe v5.5 - February 2, 2012
===============================================

* Highlight color can now be set (to Excel's range of 56 standard colors).


What's New in ExcelPipe v5.4 - January 24, 2012
===============================================

* Now handles shapes that include tables.
* When Microsoft Excel is restarted, ExcelPipe now re-applies the visibility 
settings to show or hide Microsoft Excel.
* Now skips ~*.* temporary files and .lnk files.


What's New in ExcelPipe v5.3.4 - October 18, 2011
=================================================

* Added application link to help file for correct import file format.


What's New in ExcelPipe v5.3.3 - September 15, 2011
===================================================

* Fixed GUI issue with selecting a cell to edit.
* Fixed protection passwords not working.


What's New in ExcelPipe v5.3.2 - September 8, 2011
==================================================

* Added .xlsx to list of default file types - not sure how this was missed!


What's New in ExcelPipe v5.3.1 - August 15, 2011
================================================

* Now handles Unprotecting and Reprotecting sheets with blank passwords.
* Now handles search-only mode on protected sheets.
* Fixed 'Prevent overlap' replace mode.


What's New in ExcelPipe v5.3 - July 22, 2011
============================================

* New option to prevent overlapping of subsequent search replaces. This is very 
handy when the replace terms appear in subsequent search terms and two 
replacements would have occurred.
* When 'Disable AddIns' is NOT checked, ExcelPipe also keeps any workbooks 
open, preventing #NAME? errors after the search/replace has occurred.
* Improved installer to not require Admin user.


What's New in ExcelPipe v5.2.1 - July 5, 2011
=============================================

* Fixed search grid being disabled.


What's New in ExcelPipe v5.2 - July 1, 2011
===========================================

* New option to disable AddIns - previously AddIns were always disabled, but 
this new option allows them to remain enabled so that they can assist with 
the replacement process if required.


What's New in ExcelPipe v5.1.1 - May 3, 2011
============================================

* New help options and hints for connecting to SharePoint.


What's New in ExcelPipe v5.1 - May 2, 2011
==========================================

* Passwords are now stored encrypted.


What's New in ExcelPipe v5.0.8 - March 16, 2011
===============================================

* Search/replace now continues even if there is an error getting the document 
protection type under Office 2007/2010.


What's New in ExcelPipe v5.0.7 - February 9, 2011
=================================================

* Search-Only mode now works in protected sheets.


What's New in ExcelPipe v5.0.6 - January 28, 2011
=================================================

* Defined Names search now searches both Names and Values (previously it just 
searched Names).
* Progress timer is now disabled while opening a file - so Microsoft Excel will 
not be terminated when opening a large file.


What's New in ExcelPipe v5.0.5 - January 27, 2011
=================================================

* Fixed string list error when using List of files.


What's New in ExcelPipe v5.0.4 - January 26, 2011
=================================================

* More Unicode improvements.


What's New in ExcelPipe v5.0.3 - December 24, 2010
==================================================

* Modified file scanning method.


What's New in ExcelPipe v5.0.2 - December 22, 2010
==================================================

* OLE and DDE links are now included in the Link Report.


What's New in ExcelPipe v5.0.1 - December 13, 2010
==================================================

* Limit to the number of import errors shown.
* Fixed issue with read-only detection of Unicode filenames.


What's New in ExcelPipe v5.0 - December 10, 2010
================================================

* Fixed more issues with SharePoint and File Locking.


What's New in ExcelPipe v4.9.3 - December 8, 2010
=================================================

* Now detects Show Repairs dialog for corrupted documents, and closes it.
* The row number column is now resizable - allowing row numbers larger than 100 
to be displayed.
* Link Reports now ignore empty hyperlinks, making it easier to identify 
unchanged links.
* Errors on final Save are now trapped to prevent errors with File Locking and 
SharePoint.
* Fixed bug where the timer that checks if Microsoft Excel is still responding 
did not re-trigger after the first failure of Microsoft Excel.


What's New in ExcelPipe v4.9.2 - October 22, 2010
=================================================

* Hidden Rows and Columns can now be search/replaced even if the Last cell in 
the worksheet is hidden. In this case the first 1000 rows and 1000 columns 
are checked.


What's New in ExcelPipe v4.9.1 - October 14, 2010
=================================================

* Protected sheets are now skipped if Options\Protection Password is blank and 
you are using Excel 2007 or later. Excel 2003 and earlier handle this fine.


What's New in ExcelPipe v4.9 - August 27, 2010
==============================================

* Now can restart at a specified file.
* Protected documents are now skipped if Options\Protection Password is blank - 
this prevents errors with Excel 2007 that cannot be handled automatically.
* OLE Links are now included in the Hyperlink report.
* Hyperlink report is now available in the Save Report option for output types 
CSV, TAB and HTML. Previously it was only available for XML.
* Perl and EasyPattern matches are now allowed inside Code Modules and Sheet 
Names.
* Unicode filename support.


What's New in ExcelPipe v4.8.2 - August 20, 2010
================================================

* Protected sheets are now skipped if Options\Protection Password is blank - 
this prevents errors with Excel 2007 that cannot be handled automatically.


What's New in ExcelPipe v4.8.1 - August 17, 2010
================================================

* Hyperlink report is now available in the Save Report option for output types 
CSV, TAB and HTML. Previously it was only available for XML.


What's New in ExcelPipe v4.8 - August 16, 2010
==============================================

* New option to Accept All Revisions before replacing - these can prevent 
phrases from being found.
* OLE Links are now included in the Hyperlink report.


What's New in ExcelPipe v4.7.4 - June 7, 2010
=============================================

* Now shows error dialog if the default save location (in My Documents) cannot 
be written to, and exits gracefully.
* Standardized open/save dialogs now used throughout.


What's New in ExcelPipe v4.7.3 - May 21, 2010
=============================================

* Fixed prompt on replace displaying even non-matching terms.


What's New in ExcelPipe v4.7.2 - May 12, 2010
=============================================

* New option to ignore Prompting if the replacement is identical to the found 
text. Makes for far easier searching.
* Improved GUI - Check/Uncheck all search locations working properly, grid rows 
behave as expected etc.


What's New in ExcelPipe v4.7.1 - May 10, 2010
=============================================

* Protected documents are now not flagged as having the search text.


What's New in ExcelPipe v4.7 - April 9, 2009
============================================

* Workaround for horrendous Microsoft Excel bug where text boxes with more than 
255 characters do not get processed.
* New Check All/Uncheck All buttons to set the Look In locations.
* New Insert row button. 
* Better install under Vista/Windows 7 - no admin required to install or run.


What's New in ExcelPipe v4.6.15 - February 18, 2010
===================================================

* Microsoft Excel now kept visible better if 'Keep Visible' option checked.
* File associations now just for .xls and .xlsx files.
* 'Prompt on Replace' option now displays the Confirmation dialog even if the 
found text and its replacement are identical - making search-only far easier.


What's New in ExcelPipe v4.6.14 - September 2, 2009
===================================================

* Now opens .XLA files correctly (containing code modules only).
* Now typing 'excelpipe' in Windows' Run dialog will start ExcelPipe.


What's New in ExcelPipe v4.6.13 - August 31, 2009
=================================================

* Better display of multi-line items
* Now handles replacements in formulae better


What's New in ExcelPipe v4.6.12 - August 1, 2009
================================================

* Fixed minor bug.


What's New in ExcelPipe v4.6.11 - July 31, 2009
===============================================

* Improved handling of Microsoft Excel restarts.


What's New in ExcelPipe v4.6.10 - June 9, 2009
==============================================

* Fixed connection to help file.
* Fixed installer not copying files.
* Fixed settings not being saved in My Documents folder.


What's New in ExcelPipe v4.6.9 - May 27, 2009
=============================================

* Now closes all open documents prior to processing each file.
* Now can recover from an incorrect worksheet password - ExcelPipe skips the 
sheets it can't process and continues with the rest.
* Logs now include a sequential file number.
* 'Microsoft Excel Update Links' dialog now suppressed.


What's New in ExcelPipe v4.6.8 - May 15, 2009
=============================================

* Now searches inside each shape contained with a grouped shape e.g. for 
Links/OLE/DDE etc.


What's New in ExcelPipe v4.6.7 - April 28, 2009
===============================================

* Improved the internal method by which the password is used for Code Modules.


What's New in ExcelPipe v4.6.6 - April 28, 2009
===============================================

* Backup files now get the same date as the original file.
* Fixed problem where two sets of changes were made.
* Backup Files and Keep File Date option now work with Unicode filenames.


What's New in ExcelPipe v4.6.5 - April 27, 2009
===============================================

* Fixed bug in Code Module search.


What's New in ExcelPipe v4.6.4 - April 23, 2009
===============================================

* Now can search/replace Sheet Names (e.g. Sheet1, Sheet2, Sheet3).


What's New in ExcelPipe v4.6.3 - April 22, 2009
===============================================

* Fixed title of Cancel button in status window.
* Installer will now force a reboot if redemption.dll is in use.


What's New in ExcelPipe v4.6.2 - April 21, 2009
===============================================

* New Edit Menu with Cut/Copy/Paste/Select All
* Now recommends the use of TextPipe Pro if .CSV or .TAB files are processed, 
as it is much faster and more capable with text files.
* Code Module searches now include all possible modules. A VBProject protection 
password can be opened using the Unprotect Password field.


What's New in ExcelPipe v4.6.1 - February 12, 2009
==================================================

* Now offers 'Yes to All' for fixing longer search phrases.


What's New in ExcelPipe v4.6 - February 6, 2009
===============================================

* Now handles search phrases longer than 255 characters, which Microsoft Excel 
does not support.


What's New in ExcelPipe v4.5.1 - October 8, 2008
================================================

* Now handles sheets that are protected with no password - and re-protects them 
afterwards as well.


What's New in ExcelPipe v4.5 - October 2, 2008
==============================================

* Added ability to search/replace inside Code Modules.
* Added option to keep Microsoft Excel visible while running to aid debugging.
* Added button to import the file list from Microsoft Excel's current list of 
open files.
* Added ability to perform search only from command line using /GS.
* Fixed /REPORT= command line option not working.


What's New in ExcelPipe v4.4.3 - July 17, 2008
==============================================

* Added missing Link Report.
* Fixed error that occurred if job was cancelled and the status form closed 
prior to the processing thread finishing.


What's New in ExcelPipe v4.4.2 - June 20, 2008
==============================================

* Fixed processing error with hidden rows/columns.


What's New in ExcelPipe v4.4.1 - June 19, 2008
==============================================

* Now makes changes in formulae properly.
* Now detects hidden rows and columns at the edge of the visible range of 
cells.


What's New in ExcelPipe v4.4 - June 17, 2008
============================================

* New link report for reporting hyperlinks found or changed.
* Now can search and replace inside hidden rows and columns.
* Better reporting of the number of cells actually changed.


What's New in ExcelPipe v4.3.2 - March 14, 2008
===============================================

* Resolved problem with unprotecting a document marking the document as 
changed.


What's New in ExcelPipe v4.3.1 - March 11, 2008
===============================================

* Now handles unprotect passwords in conjunction with OLE links properly.


What's New in ExcelPipe v4.3 - February 15, 2008
================================================

* New option to specify the unprotect password for sheets and workbooks.


What's New in ExcelPipe v4.2 - October 1, 2007
==============================================

* New Highlight option when a replacement is made, to make locating changes 
easy (note: does not work for all search types).
* New [Clear All] button below search/replace grid.
* Removed legacy behavior where contents of search/replace grid were appended 
to imported search/replace lists, leading to confusing results.


What's New in ExcelPipe v4.1.1 - September 5, 2007
==================================================

* Now prevents the Header or Footer text from being set to a value longer than 
255 characters, which Microsoft Excel doesn't support.


What's New in ExcelPipe v4.1 - August 8, 2007
=============================================

* Now forces a Microsoft Excel restart when particular error messages are 
returned.
* If errors occur during Import, you can now cancel the Import.
* Fixed bug with /G command line invocation, and with /Q.


What's New in ExcelPipe v3.9.7 - August 1, 2007
===============================================

* AutoRun macros are now disabled to prevent them interfering with document 
processing.
* New warning message if backup files have not been deleted or restored at the 
end of a job.
* Longer timeout while waiting for Microsoft Excel to respond. Timeout disabled 
while showing the 'Cancel Job' confirmation window.
* Fixed bug with Microsoft Excel being terminated at the wrong time.
* New translations, better form resizing, fixed detection of options changing.


What's New in ExcelPipe v3.9.6 - June 27, 2007
==============================================

* Fixed Match Case and Match Entire Cell settings not being retained.
* Removed incorrect warning for search terms with spaces when 'Entire Cell' 
option was checked.


What's New in ExcelPipe v3.9.5 - June 21, 2007
==============================================

* Now integrates with Windows Explorer right click menus - 'ExcelPipe this 
file/folder'.
* Now allows a list of files to process on the command line.
* Previous settings are now saved under Documents rather than Registry.
* New installer languages.
* New Japanese and Chinese translations.


What's New in ExcelPipe v3.9.4
==============================

* Fixed incorrect warning for hyperlink longer than 255 characters.


What's New in ExcelPipe v3.9.3
==============================

* Now updates hyperlink Screen Tips as well when the 'Hyperlink addresses' 
search location is chosen.
* Office 2007 file extension of .XLS* now supported.
* Import assumes defaults if just columns A & B present.
* Invalid Search Locations are now corrected and you have the option to 
continue running the job.
* Fixed bug with hyperlinks not being updated due to TextToDisplay property not 
supported on older versions of Excel.
* Fixed bug with Prompt on Replace always replacing.


What's New in ExcelPipe v3.9.2
==============================

* Now can optionally handle read-only files.
* Now warns you if you apply EasyPattern wildcards or Perl regex wildcards to 
search locations that do not support them.


What's New in ExcelPipe v3.9.1
==============================

* Now allows files to be drag and dropped.
* Vista installation support.
* New Troubleshooting Guide links.


What's New in ExcelPipe v3.9
============================

* Improved speed when making massive numbers of hyperlinks changes (e.g. 
18000).
* Hyperlink changes now automatically check for equivalence between %20 and 
spaces.


What's New in ExcelPipe v3.8.4
==============================

* Fixed assertion failure.


What's New in ExcelPipe v3.8.3
==============================

* New status message when exporting or importing data
* Added Half Width/Full Width option for Japanese text.
* Increased search/replace speed.
* Removed Arabic options - causing problems with English versions.
* New Options Menu item to remove leading and trailing blanks from search and 
replace terms.
* Status displays now resume if you cancel out of Aborting the job.


What's New in ExcelPipe v3.8.1
==============================

* Status window now shows seconds elapsed and scans in progress to improve 
feedback to user.
* Improved timeout detection.


What's New in ExcelPipe v3.8
============================

* Auto Recovery is now disabled to prevent them interfering with document 
processing.
* New search types of EasyPattern wildcards and Perl regex wildcards. These can 
be used to apply sophisticated pattern matching, replacing and reformatting 
inside Hyperlink Addresses, Shapes, Headers, Footers, Built in/Custom 
Properties, Links (OLE/DDE), Chart Titles and Defined Names.
* Prompt on Replace for the search locations above.
* Processing can now be paused and resumed.
* Updated Excel/CSV/Tab import and export.
* Backed-out Windows Vista installation support. Too cumbersome for users.


What's New in ExcelPipe v3.7
============================

* Now can search multiple locations with one search row.
* New option to process longest 'Find What' strings first - perfect for 
translators.
* New option to Allow Alerts from Microsoft Excel.
* Fixed bug with EXE location not being saved, and with prompt for save not 
occurring when the settings have been changed.
* Fixed bug with replace strings longer than 255 characters missing some 
characters.
* Fixed bug where MS Word was restarted, not MS Excel.


What's New in ExcelPipe v3.6.5
==============================

* Fixed division by zero when 'Restart after XX documents' was zero.


What's New in ExcelPipe v3.6.4
==============================

* Was only finding in Values, now finds in Formulae as well.
* Now processes files with Unicode filenames.
* List of Files now supports Unicode filenames.
* Up/Down arrows now work outside of the Grid control.


What's New in ExcelPipe v3.6.3
==============================

* Determination of whether a replacement occurred is now correct.
* Removed the 'file exists' check.


What's New in ExcelPipe v3.6.2
==============================

* Status dialog now correctly shows Unicode search/replace strings.
* Changed install to support Windows Vista - Test files and Sample are now 
stored under Application Data\DataMystic\ExcelPipe. Default install location 
is now Program Files\DataMystic\ExcelPipe.
* Changed the 'file exists' check to work better on LANs.


What's New in ExcelPipe v3.6.1
==============================

* New button to copy selected rows.
* Status dialog can now save a report as a Web Page, CSV or Tab data.


What's New in ExcelPipe v3.6 B
==============================

* New option to restart Microsoft Excel automatically after a given number of 
documents. This helps to eliminate Microsoft Excel errors.
* Now checks if Microsoft Excel is not responding, and shows a helpful message 
to the end user. Microsoft Excel can be restarted automatically if it is 
unresponsive for a given number of seconds.
* New option to specify the path to the Microsoft Excel executable (.exe) file. 
This is used if Microsoft Excel cannot be restarted automatically after a 
failure.
* New option to process a list of files pasted in.
* Now allows replacements longer than 255 characters (working around a 
Microsoft Excel limitation).
* Backup files can now be restored or removed at the end of the job.
* Multi-line values can now be edited in the grid.
* Up/Down arrows now work correctly in fields other than the grid.
* Error messages reworked to always show the filename first.
* Status dialog can now copy filenames without messages - very useful for 
generating lists of files to reprocess.
* Fixed error with 'Search' button causing a Replace.
* Fixed error with 'Cells' search location not working.


What's New in ExcelPipe v3.6
============================

* New 'File\Send To...' menu item to email settings
* New Help panel to assist new users
* New Half width/Full width option for use with Japanese and other Unicode 
text.
* Import from a .XLS replace list now handles trailing spaces and the values 
Yes/No/True/False/1/0 for Boolean fields.


What's New in ExcelPipe v3.5
============================

* Now can replace inside Chart Titles.
* Now can replace inside Defined Names.
* Now detects multiple copies of ExcelPipe running - and warns against it, as 
it can lead to document corruption.
* Now shows Unicode search strings in the status dialog.
* Now warns if no rows are selected when options are clicked on.


What's New in ExcelPipe v3.4
============================

* New option to update an ISO-9001 revision number field by a pre-defined 
amount.
* Now can display the clipboard contents - very useful when using '^c' to 
replace search text with the current clipboard contents.
* New XML file format - makes it easier to automate ExcelPipe and share replace 
lists with WordPipe and PowerPointPipe.
* Search/replace rows are now restored when the application restarts.
* Now warns against erroneous backslashes (\) instead of forward slashes (/) 
when searching inside hyperlink addresses.
* New Options tab.
* Read-Only files are now added to the files tab.


What's New in ExcelPipe v3.3
============================

* New warning message if the search/replace list filename is blank.
* New method of connecting to Microsoft Excel allows it to be manually started 
if required.
* New warning if no files were processed.
* Better detection of changes being made or not.


What's New in ExcelPipe v3.2
============================

* Now can change the path of embedded OLE and DDE links to databases and other 
sources.


What's New in ExcelPipe v3.1.1
==============================

* Now works with an independent copy of Excel to avoid interfering with other 
applications.


What's New in ExcelPipe v3.1
============================

* Now shows the number of changes made or search terms found, both for the 
entire job, for each file, and for each search or replace term.
* EXPORT and IMPORT of replacements list to any common file format (xls, csv, 
txt), in Unicode format.
* New column for the row number - makes the grid easier to work with.


What's New in ExcelPipe v2.9
============================

* New Backup mode.
* Now supports drag and drop of rows.
* Now supports Up/Down/Tab/Shift+Tab in grid.
* Automatically extends the grid when you Tab or Down Arrow past the end.
* Fix for 'Search By Rows/Columns' settings - now removed - Excel does not 
support this.


What's New in ExcelPipe v2.8
============================

* Now there is only a single message if the search strings contain leading or 
trailing whitespace.
* Now correctly loads Unicode data from an Excel search/replace list.
* Now correctly finds and replaces Unicode in hyperlinks, shapes, headers, 
footers and document properties.
* Now handles loading a Tab or CSV search/replace list where the replacement is 
blank.
* Now handles European installations of Excel.


What's New in ExcelPipe v2.7
============================

* Now includes text files for you to play with.
* When run in non-interactive mode from the command line, ExcelPipe now 
suppresses warning messages for intervention-free execution.
* Updated help files.


What's New in ExcelPipe v2.6
============================

* Now can import a list of the files to process.
* Fixed problem with password-protected files stopping the processing.


What's New in ExcelPipe v2.5
============================

* Now can perform Unicode search and replace.
* New Search-Only function, very useful to locate matches.
* New-style Tips of the Day dialog.
* New User Interface for easier editing, with row copying and moving.
* Double-clicking on filenames in the results window now opens the file.
* Double-clicking on the start folder now opens it in Explorer.


What's New in ExcelPipe v2.4.1
==============================

* Now displays the correct error message if a corrupted spreadsheet cannot be 
opened.


What's New in ExcelPipe v2.4
============================

* Now can search and replace inside the built in document properties such as 
Title, Subject, Author, Company etc, and inside custom document properties 
defined by the user.
* Now can search and replace inside the header and footer of each worksheet.
* New status window options to copy the log to the clipboard.
* Now checks to see if MS Excel is still functioning and opens a fresh copy if 
not.
* Now displays the number of changes made to each document.
* Now disables many of MS Excel's alert dialog boxes.
* Fixed display of wrong error message if MS Excel was opened with open 
spreadsheets.


What's New in ExcelPipe v2.3
============================

* Now can search inside shapes.


What's New in ExcelPipe v2.2
============================

* Now can search inside hyperlink addresses.
* Interface now takes advantage of WordPipe-style interface improvements.
* Removed prompting if the search string is not found.


What's New in ExcelPipe v2.1
============================

* Initial release!

See http://www.datamystic.com for more details on ExcelPipe