Navigator Utilities

Updates

Special thanks ...

... to the many navigator utilities users who have provided feedback on features and bugs. Navigator utilities is being constantly updated and improved. All comments, suggestions and bug reports are greatly appreciated. Contact us at web1@robbo.com.au.

V2.18 Updates 24 June 2008

Fixed a problem relating to unprotecting sheets where Navigator still tries to break the password even though the correct password has been entered.

V2.17 Updates 03 January 2008

Fixed a problem requiring administrator access to install.

V2.16 Updates 16 December 2007

Fixed a problem which sometimes caused the dialogs to flash and disappear when used for the first time in each Excel session.

V2.15 Updates 10 July 2007

Sheet Navigator now remembers the sort option last used.

V2.14 Updates 26 June 2007

Improvements to speed of names Navigator.

V2.13 Updates 28 May 2007

Fixed bug in Links Navigator preventing display of very long cell formulas.

V2.12 Updates 31 January 2007

Removed minor bugs.

V2.11.6 Updates 7 December 2006

Removed minor bugs from Names Utility.

V2.11.5 Updates 20 June 2006

Improved Names Navigator functionality. When viewing Names on very large workbooks, the Name Navigator can take considerable time to find the references. Setting the Display of Dependents to None can considerably improve speed when scrolling through Names.

V2.11.4 Updates 6 March 2006

Option added to allow removal of individual Navigator Utilities from memory to free up space.

V2.11.3 Updates 4 March 2006

Names Navigator - Added ability to repair corrupt or invalid Names. Names imported from 123 spreadsheets are often invalid and unable to be deleted. When deleting invalid names, option is provided to fix all invalid Names.

Links navigator - ability to find links where the path name includes forward slashes, such as URLs.

V2.11.2 New display options 23 January 2006

New option to allow user to decide where dialogs appear - the default being the centre of the window with the option to select the right hand side of the window, or simply remember the previous position.
Added ability to find links for Picture Objects.

V2.10 New Trace Navigator 20 July 2005

New Trace Navigator added for finding your way through dependents and precedents of a cell. A useful audit tool extending on the functionality of the standard Excel audit toolbar but providing lists of precedents and dependents and keeping track of your trace history so you never get lost!

V2.03 Minor fix 3 June 2005

Fix display of zoom percentage slider on Sheet Navigator.
Fix to Names Navigator to remove error dialog.

V2.02 Minor fix 17 May 2005

Fix problem loading Navigator Utilities at Excel startup which caused Start pane to flicker.

V2.01 Minor fix 25 April 2005

Fix problem loading Navigator Utilities with shortcut keys.
Fix a problem preventing Navigator running on Excel 97.
Change initial focus on entry to Names Navigator so that Names can be easily selected with the keyboard.

V2.00 New Object Navigator 16 November 2004

New Object Navigator added for finding your way through objects of all types, such as shapes, buttons, charts, comments, images, etc.

New installation routine provided for easy installation and removal of Navigator Utilities.

Faster loading of Navigator utilities when Excel loads - only used utilities are actually loaded into memory.

V1.76 Fix to Shortcut Options 28 August 2004

Fix for problem in v1.75 which prevented Excel from loading in some situations.

V1.75 Fix to Shortcut Options 18 August 2004

Fix shortcut options which did not work properly.

V1.74 Improvements 26 June 2004

Minor improvements to dialogs and password breaking feature.

V1.73 Improvements 15 June 2004

Minor improvements to error messages.

V1.72 Find/Replace Navigator update 29 April 2004

Fix to Find/Replace which would not find a reference on active sheet in some circumstances.

V1.71 Improvements 8 March 2004

Improvement to Sheet Navigator: additional sorting options, and minor improvements.

V1.70 Improvements 23 February 2004

Improvement to Sheet Navigator password breaking feature, and minor improvements.

V1.69 Improvements 19 January 2004

Improvement to Links Navigator to allow for files and path names which include an apostrophe.

V1.67 Speed improvements 7 September 2003

Improvements have been made to prevent unnecessary calculations which would sometimes slow down Navigator when working with very large and complex workbooks.

V1.66 Find/Replace Navigator updates - improvements 26 September 2003

Additional feature to allow find and replacing through all open workbooks in addition to the active worksheet or workbook.

V1.65 Find/Replace Navigator updates - improvements 11 September 2003

Small improvements have been made to the operation of the Find/Replace feature.

V1.64 Sheet Navigator updates - new features 5 September 2003

New features have been added to the Sheet Navigator - see the "Other..." button. You can now add/remove gridlines and/or row & column headers for selected sheet(s) - for both the display and also the print page setup. Also, a quick page setup footer feature has been added to easily add the file name and date to the footer of workbook pages for all selected sheets.

V1.63 Link Navigator updates - improvements 13 August 2003

Improvements to Link Navigator to allow for multiple selecting of source workbooks for updating, opening and closing. The speed of source updating has been greatly improves and an option added to the Multiple File function to allow for password protected files to be ignored.

V1.62 Sheet Navigator updates - copying/moving sheets 17 June 2003

Additional feature added to Sheet Navigator to allow for easy copying and moving of sheets within the workbook and to other open or new workbooks.

V1.61 Duplicating sheets and deleting Names 11 June 2003

Additional feature added to Sheet Navigator to allow for easy duplicating of selected sheets with just one click.
Multiple deletion of selected Names in one go has been enabled in Names Navigator.

V1.60.4 Find/Replace Navigator updates 21 May 2003

The Find Navigator has been significantly enhanced to include Replace functionality and additional options.

V1.59 Link Navigator updates 8 April 2003

Added delete option to Link Navigator. Select link references to be deleted from the list box, then click delete.

V1.58 Names Navigator updates 29 March 2003

Improvements to the Names Navigator providing additional filtering options.

V1.57 Link Navigator updates 07 March 2003

Minor bug fix.

V1.56 Link Navigator updates 02 March 2003

Improvements to the Link Utilities - now searches all charts for links to other workbooks.

V1.55 Option to change Shortcut Keys 23 February 2003

Navigator Utilities are provided with default shortcut keys. These default shortcut keys may conflict with the shortcut keys used by other Excel add-ins. The shortcuts for the Navigator Utilities may be changed, or eliminated, by editing the values using the Options found on the main navigator menu.

Note that the default shortcut for Navigator Names has been changed to Ctrl-M in this version.

V1.54 Introduces Multiple Link Updates 21 February 2003

Multiple Link Updates is used when you want to update links in many workbooks in a single run. This may be required when you move a number of workbooks from one server to another or from your c: drive to a server, and all the links are broken.

You can also produce a report of all files with links.

It is selected by clicking the "Multiple Change" button at the bottom of the Navigator Link dialog. Select which workbooks you want to update by selecting from either open workbooks, or by selecting files from a directory (with or without its sub-directories).

Then enter a string representing the path which is to be replaced, and enter the required replacement string.

A report is produced listing all workbooks updated and the link source workbooks before and after the change.

Note that if open workbooks are selected, the workbooks are NOT saved. If workbooks from a directory are selected, the workbooks will be opened, modified and then saved.

If workbooks are open password protected, you will be requested to enter the password. If you not enter the correct password, the file will be skipped. If a workbook to be modified has sheets that are protected, they will be unprotected except if a password is required, in which case you will be requested to enter the password. If you do not enter the correct password, the file will be skipped.

[ Home ]