What's new in ExcelPipe 8.8.3
Jan 11, 2021
- Fixed issue with ribbon disappearing.
New in ExcelPipe 8.8.1 (Nov 27, 2020)
- Fixed memory issues with x64 registered versions.
New in ExcelPipe 8.7 (Sep 25, 2020)
- License manager now handles key renewal.
- Updated ribbon controls.
New in ExcelPipe 8.4 (Sep 26, 2019)
- Improved error handling in license manager.
New in ExcelPipe 8.3 (Apr 17, 2019)
- Retaining last access date now works in Search/Replace mode.
New in ExcelPipe 8.2 (Mar 12, 2019)
- Fixed error on closing running process before end.
- Added results of Data Sources search/replace to the Hyperlink report.
New in ExcelPipe 8.1 (Mar 6, 2019)
- Updated editing grid to be more user-friendly.
- Fixed error where evaluation files were deleted if backup mode was selected
- and the status window was closed without choosing to restore or delete the
- backup files.
New in ExcelPipe 7.9 (Nov 15, 2018)
- Updated license manager code.
New in ExcelPipe 7.8 (Jul 8, 2018)
- New! Data Sources can now be updated (Office 2016+).
New in ExcelPipe 7.7 (Jun 19, 2018)
- Updated status tab warning about MS Excel already running to only display
- when no ExcelPipe job is running.
- Added cleared error messages for EasyPattern and Perl Regex errors.
- Removed logging warnings.
New in ExcelPipe 7.6 (Jul 28, 2017)
- Fixed error with non-recognized languages.
New in ExcelPipe 7.5 (Oct 18, 2016)
New in ExcelPipe 7.4 (Aug 17, 2016)
- New warning display if MS Excel is currently running, with a button kill it.
- Removed numbering from status dialog tabs as this was confusing.
- Look In field now shows count of number of locations selected.
- Fixed SharePoint URL dialog not allowing https:// links.
New in ExcelPipe 7.3.1 (Aug 17, 2016)
- Rebuild to remove Look In list not showing correct values.
New in ExcelPipe 7.3 (Aug 17, 2016)
- Rebuild to remove PROGRAMMING ERROR bug.
New in ExcelPipe 7.2.1 (Aug 17, 2016)
- Rebuild to remove PROGRAMMING ERROR bug.
New in ExcelPipe 7.2 (Aug 17, 2016)
- Now can find and replace Excel images in Microsoft Excel or OpenOffice spreadsheets (*.ods)
- Enhanced and improved user interface.
- Updated internal libraries for pattern matching.
New in ExcelPipe 7.1.1 (Jul 8, 2016)
- Fixed SaveAs issue in evaluation version.
New in ExcelPipe 7.1 (Apr 26, 2016)
- Can now use macros in the replacement text: @inputFilename@ or @filename@
- @fullInputFilename, @inputPath, @inputExtension
- @clipboard
- @time, @date, @datetime
- @_year, @_month, @_day
- @_hour, @_minute, @_second
- @randomdigit, @randomletter
- @ENV_varname
- Can now specify which property should be modified or replaced by preceding it
- with [fieldname] eg
New in ExcelPipe 7.0 (Mar 11, 2016)
- Now allows the subaddress (anchor) part of hyperlinks to be modified.
- New slow down warning when all Search Locations checked.
- New checks if the hyperlink change does not get saved if the hyperlink is
- invalid or the destination cannot be found)
- Separated the restart controls into a new tab.
New in ExcelPipe 6.9.4 (Jan 22, 2016)
- Added Excel import messages regarding ending at the first blank "Find What" cell.
New in ExcelPipe 6.9.3 (Jan 14, 2016)
- Fixed Activate error with "Options\Keep Microsoft Word visible while changes
- are being made."
New in ExcelPipe 6.9.2 (Jan 14, 2016)
- Fixed handling of updates to Pivot Table caches
- Fixed loading of highlight color data from Import file
- Updated button enable/disable for grid
New in ExcelPipe 6.9.1 (Jul 28, 2015)
- Fixed "List index out of bounds" error on run.
New in ExcelPipe 6.9 (Jul 28, 2015)
- Fixed settings error on startup.
New in ExcelPipe 6.8 (Mar 12, 2015)
- Fixed intermittent XML loading/saving error on x64 systems.
- Fixed error with /I= command line option not loading the search-replace list.
New in ExcelPipe 6.7 (Nov 25, 2014)
- Fixed Save from removing leading and trailing whitespace.
- Fixed Recent settings from not appearing in the Recent files history.
New in ExcelPipe 6.6 (Oct 24, 2014)
- Search items can now be sorted by clicking on the Find what column header.
- Fixed issues with Lite Editions.
- Improved detection and display of non-English code pages.
- Updated to EasyPattern v2.9 and Perl regex libraries.
- Incremental search when the search grid is selected.
New in ExcelPipe 6.5 (Oct 24, 2014)
- Fixed synchronization bug that caused ExcelPipe to hang.
- New Ribbon interface.
New in ExcelPipe 6.4 (Jul 15, 2014)
- Files To Process can now set the Start or End date for files to be included.
- New! Now attach directly to SharePoint sites (evaluation, and SharePoint
- Edition only).
- Fixed problem with invalid EasyPattern/Perl regex search locations being
- removed, and then not being processed against valid search locations such as
- hyperlinks.
New in ExcelPipe 6.3 (Mar 7, 2014)
- Now can handle search and replace inside embedded tables.
New in ExcelPipe 6.2.1 (Feb 28, 2014)
- Restart control now restarts on the next file AFTER the restart filename making it easier to skip problem files without having to guess which file is next.
New in ExcelPipe 6.2 (Nov 13, 2013)
- Now shows '(more pending)' next to the file count if more files remain to be
- counted, so users aren't misled that only 1000 files will be processed.
New in ExcelPipe 6.1 (Sep 3, 2013)
- Options\Import Search/Replace List and Actions Tab\Load A Search/Replace List
- From This File now work with multi-line Tab and CSV data.
- Added new option to Preserve Last Access dates - perfect for compliance with
- corporate data retention policies.
New in ExcelPipe 6.0.5 (Aug 7, 2013)
- Fixed range check error on loading replace highlight color fields from import
- files.
New in ExcelPipe 6.0.4 (Jul 31, 2013)
- Improved installer for floating version.
- Better error messages when Microsoft Excel is not available to load external
- .xls search/replace lists.
- Better detection of missing Microsoft Excel object or mis-matching bitness
- (x32/x64) between ExcelPipe and Microsoft Excel.
New in ExcelPipe 6.0.3 (Jun 8, 2013)
- Fixed problem with evaluation where it crashed if you gave it more than 20
- documents to process, and it also restricted the evaluation to only one file.
New in ExcelPipe 6.0.2 (May 13, 2013)
- Fixed search terms not found.
New in ExcelPipe 6.0.1 (May 2, 2013)
- Fixed doubling of search terms every time ExcelPipe is closed.
- Fixed various installer problems.
New in ExcelPipe 6.0 (May 1, 2013)
New in ExcelPipe 5.8 (Apr 24, 2013)
- The files to be processed are now gathered in parallel with document
- processing - so processing starts far more quickly, especially for large sets
- of files.
- Improved handling of Unicode filenames.
New in ExcelPipe 5.7.1 (Sep 19, 2012)
- When importing a list from .xls, .tab or .csv, ExcelPipe now assumes a
- highlight color of yellow if the highlight color column is missing.
- Updated sample import files.
New in ExcelPipe 5.7 (Aug 28, 2012)
- Now supports Open Document Calc file type .odt.
- Fixed bug where the Replacement Text for subsequent replacements is altered incorrectly when Prompt on Replace is checked, and [Replace (File)] or [Replace (Job)] is pressed in response to a replacement.
New in ExcelPipe 5.6 (Feb 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.
New in ExcelPipe 5.5 (Feb 2, 2012)
- Highlight color can now be set (to Excel's range of 56 standard colors).
New in ExcelPipe 5.4 (Jan 26, 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.
New in ExcelPipe 5.3.4 (Nov 4, 2011)
- Added application link to help file for correct import file format.
New in ExcelPipe 5.3.3 (Sep 15, 2011)
- Fixed GUI issue with selecting a cell to edit.
- Fixed protection passwords not working.
New in ExcelPipe 5.3.2 (Sep 8, 2011)
- Added .xlsx to list of default file types - not sure how this was missed!
New in ExcelPipe 5.3.1 (Aug 16, 2011)
- Now handles Unprotecting and Reprotecting sheets with blank passwords.
- Now handles search-only mode on protected sheets.
- Fixed 'Prevent overlap' replace mode.
New in ExcelPipe 5.3 (Jul 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.
New in ExcelPipe 5.2.1 (Jul 19, 2011)
- Fixed search grid being disabled.
New in ExcelPipe 5.2 (Jul 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.
New in ExcelPipe 5.1.1 (May 3, 2011)
- New help options and hints for connecting to SharePoint.
New in ExcelPipe 5.1 (May 2, 2011)
- Passwords are now stored encrypted.
New in ExcelPipe 5.0.8 (Mar 16, 2011)
- Search/replace now continues even if there is an error getting the document protection type under Office 2007/2010.
New in ExcelPipe 5.0.7 (Feb 12, 2011)
- Search-Only mode now works in protected sheets.
New in ExcelPipe 5.0.6 (Jan 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
New in ExcelPipe 5.0.5 (Jan 28, 2011)
- Fixed string list error when using List of files.
New in ExcelPipe 5.0.4 (Jan 27, 2011)
- Fixed string list error when using List of files.
- More Unicode improvements.
New in ExcelPipe 5.0.3 (Jan 27, 2011)
- Modified file scanning method.
New in ExcelPipe 5.0.2 (Jan 27, 2011)
- OLE and DDE links are now included in the Link Report.
New in ExcelPipe 5.0.1 (Jan 27, 2011)
- Limit to the number of import errors shown.
- Fixed issue with read-only detection of Unicode filenames.
New in ExcelPipe 4.9.3 (Dec 8, 2010)
- Errors on final Save are now trapped to prevent errors with File Locking and SharePoint.
New in ExcelPipe 4.9.2 (Oct 24, 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.
New in ExcelPipe 4.9.1 (Oct 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.
New in ExcelPipe 4.9 (Aug 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.
New in ExcelPipe 4.8.2 (Aug 20, 2010)
- Protected sheets are now skipped if Options\Protection Password is blank -
- this prevents errors with Excel 2007 that cannot be handled automatically.
New in ExcelPipe 4.8.1 (Aug 20, 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.
New in ExcelPipe 4.8 (Aug 17, 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.
New in ExcelPipe 4.7.4 (Jun 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.
New in ExcelPipe 4.7.3 (May 21, 2010)
- Fixed prompt on replace displaying even non-matching terms.
New in ExcelPipe 4.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.
New in ExcelPipe 4.7.1 (May 10, 2010)
- Protected documents are now not flagged as having the search text.
New in ExcelPipe 4.7 (Apr 9, 2010)
- Workaround for horrendous Microsoft Excel bug where text boxes with more than
- 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.
New in ExcelPipe 4.6.15 (Feb 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.
New in ExcelPipe 4.6.14 (Sep 2, 2009)
- Now opens .XLA files correctly (containing code modules only).
- Now typing 'excelpipe' in Windows' Run dialog will start ExcelPipe.
New in ExcelPipe 4.6.13 (Aug 31, 2009)
- Better display of multi-line items
- Now handles replacements in formulae better
New in ExcelPipe 4.6.12 (Aug 31, 2009)
New in ExcelPipe 4.6.11 (Jul 31, 2009)
- Improved handling of Microsoft Excel restarts.
New in ExcelPipe 4.6.10 (Jun 10, 2009)
- Fixed connection to help file.
- Fixed installer not copying files.
- Fixed settings not being saved in My Documents folder.
New in ExcelPipe 4.6.9 (Jun 10, 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.
New in ExcelPipe 4.6.8 (May 15, 2009)
- Now searches inside each shape contained with a grouped shape e.g. for
- Links/OLE/DDE etc.
New in ExcelPipe 4.6.7 (Apr 28, 2009)
- Improved the internal method by which the password is used for Code Modules.
New in ExcelPipe 4.6.5 (Apr 27, 2009)
- Fixed bug in Code Module search.
New in ExcelPipe 4.6.4 (Apr 23, 2009)
- Now can search/replace Sheet Names (e.g. Sheet1, Sheet2, Sheet3).
New in ExcelPipe 4.6.3 (Apr 22, 2009)
- Fixed title of Cancel button in status window.
- Installer will now force a reboot if redemption.dll is in use.
New in ExcelPipe 4.6.2 (Apr 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.
New in ExcelPipe 4.6.1 (Feb 11, 2009)
- Now offers 'Yes to All' for fixing longer search phrases
New in ExcelPipe 4.6 (Feb 6, 2009)
- Now handles search phrases longer than 255 characters, which Microsoft
- Excel does not support.
New in ExcelPipe 4.5.1 (Oct 9, 2008)
- Now handles sheets that are protected with no password - and re-protects them afterwards as well.
New in ExcelPipe 4.5 (Oct 3, 2008)
- Added ability to search/replace inside Code Modules and much more
New in ExcelPipe 4.4.3 (Jul 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.
New in ExcelPipe 4.4.2 (Jun 21, 2008)
- Fixed processing error with hidden rows/columns
New in ExcelPipe 4.4.1 (Jun 19, 2008)
- Now makes changes in formulae properly.
- Now detects hidden rows and columns at the edge of the visible range of cells.
New in ExcelPipe 4.4 (Jun 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.
New in ExcelPipe 4.3.1 (Mar 11, 2008)
- Now handles unprotect passwords in conjunction with OLE links properly.
New in ExcelPipe 4.3 (Feb 15, 2008)
- New option to specify the unprotect password for sheets and workbooks.
New in ExcelPipe 4.1 (Aug 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.
New in ExcelPipe 3.9.7b (Aug 7, 2007)
- Fixed bug with /G command line invocation, and with /Q.
- Now forces a Microsoft Excel restart when particular error messages are returned.
New in ExcelPipe 3.9.7a (Aug 6, 2007)
- Fixed bug with /G command line invocation.
New in ExcelPipe 3.9.7 (Jul 26, 2007)
- Fixed Match Case and Match Whole Words Only settings not being retained.
- Removed incorrect warning for search terms with spaces when 'Entire Cell' option was checked.
New in ExcelPipe 3.9.7 (Jul 20, 2007)
- New warning message if backup files have not been deleted or restored at the end of a job.
New in ExcelPipe 3.9.4 (Apr 20, 2007)
- Fixed incorrect warning for hyperlink longer than 255 characters
New in ExcelPipe 3.9.1 (Mar 22, 2007)
- Now allows files to be drag and dropped.
- Vista installation support.
- New Troubleshooting Guide links.
New in ExcelPipe 3.9 (Mar 9, 2007)
- Improved speed for Hyperlink changes;
- Hyperlink changes now automatically check for equivalence between and space
New in ExcelPipe 3.8.3 (Dec 15, 2006)
- Increased search/replace speed,
- new Options Menu item to remove leading and trailing blanks from search and replace terms.
New in ExcelPipe 3.8.1 (Nov 27, 2006)
- New restart control and monitoring for large document runs,
- handles Unicode filenames and more,
- fixed false positivies for Excel not responding
New in ExcelPipe 3.6.4 (Sep 15, 2006)
- New restart control and monitoring for large document runs, handles Unicode filenames and more
New in ExcelPipe 3.6.4 (Sep 15, 2006)
- New restart control and monitoring for large document runs, handles Unicode filenames and more
New in ExcelPipe 3.6 (Aug 25, 2006)
- New restart control and monitoring for large document runs
New in ExcelPipe 3.4 (May 10, 2006)
- New option to update an ISO-9001 revision number field by a pre-defined amount, XMl file format for easy sharing, rows restored on re-load and more.