New Tools for Microsoft® Excel®2007
Power Utility Pak Version 7 (PUP v7) is a useful collection of add-ins that brings significant new functionality to Excel 2007. When PUP is installed, you can do things with Excel that you never thought were possible. Regardless of your experience level, you'll find features in PUP that can make your job easier. PUP v7 augments Excel with about 70 new commands and 53 new worksheet functions. The product is designed to work seamlessly with Excel.
PUP v7 takes advantage of the new Ribbon user interface in Excel 2007, so accessing the PUP tools is easier than ever. Click the image below for a larger view of the PUP v7 Ribbon.
Use the menu on the left to find out more about PUP v7. Better yet, take a few minutes and download a free (and fully functional) 30-day trial. Installation is easy, so you'll be up and running in a few minutes.
Requirements
|
Other Versions of PUP
|
FeaturesPUP v7 augments Excel with about 70 new commands and 53 new worksheet functions. The product is designed to work seamlessly with Excel. For example, the Ribbon commands and dialog boxes work just like those built into Excel. Use the links on the left to view the complete features list, with screen shots. |
Free DownloadClick the link below to download a free 30-day Trial Version of PUP v7. The Trial Version is fully-functional, and does not display any nag messages. |
Pricing
|
UpgradeOne of the benefits of purchasing Power Utility Pak is free upgrades for life. Registered users of PUP 2.0a, PUP97, PUP 2000, PUP v5, and PUP v6 are eligible for a free upgrade to PUP v7 (a $5.00 upgrade processing fee applies). |
Product SupportFree and unlimited technical support (including free updates) is available. See Technical Support. |
PUP v7 Software License AgreementFollow the link below to read the PUP v7 Software License Agreement. This is a "no-nonsense" agreement, intended for normal people (not lawyers). |
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Software License Agreement
If you purchase PUP v7, you must agree to the terms of the Software License Agreement below.
J-Walk and Associates
Software License Agreement
Power Utility Pak Version 7
By downloading the software, you agree to abide by the following provisions.
SOFTWARE VERSIONS
Power Utility Pak Version 7 ("PUP") exists in two versions: Trial Version and Fully-Licensed Version.
LICENSE
J-Walk and Associates grants you a license to use and copy the software program(s) and documentation subject to the limitations described here. The license for the Trial Version expires 30 days after it has been installed. The license for the Fully Licensed Version does not expire.
DISTRIBUTION OF SOFTWARE
Any and all distribution of the Fully-Licensed Version is prohibited. Not-for-profit distribution of Trial Version is permissible, on condition that the software is not altered in any way and is distributed in its entirety. Electronic transfer, renting, leasing, loaning, selling or distributing of the Trial Version for profit in any form, including but not limited to bulletin board distribution, magnetic or optical medium distribution is not permitted without the written consent of J-Walk and Associates. Furthermore, modification, or alteration of the software including but not limited to decompiling, disassembling, reverse engineering or creation of works arising from the software is prohibited.
DISTRIBUTION EXCEPTION
The PUP FUNCTION LIBRARY component of PUP copies VBA macros to an Excel workbook file. The PUP license allows such workbooks to be distributed to others. However, the VBA macros may not be included as part of any other commercial product.
BACKUP COPIES
You may make any reasonable number of backup copies of PUP.
MULTI-SYSTEM INSTALLATION
You may install PUP on multiple computer systems, subject to the condition that only one such system will be in use at any given time. For example, you may install the software on an office system and a home system.
DISASSEMBLY
You may not reverse-assemble or reverse-compile any component of PUP.
VBA SOURCE CODE
The complete VBA source code for PUP is available to licensed users for a nominal fee. This code is intended primarily for instructional purposes. The VBA code may not be incorporated into other commercial products.
COPYRIGHT
PUP and ancillary material are copyrighted by J-Walk and Associates. Do not delete the copyright notice, trademarks or protective notice from your copy or any copy you make.
WARRANTY
J-Walk and Associates does not warrant that the software will be free from errors or will meet your specific requirements. The software is made available to you "as is." However, if a problem is discovered and reported, J-Walk and Associates will take reasonable measures to correct the problem.
LIMITATIONS AND LIABILITY
J-Walk and Associates makes no warranty or condition, either express or implied, including but not limited to any implied warranties of merchantability and fitness for a particular purpose, regarding the software. In no event shall J-Walk and Associates or its suppliers be liable for any indirect, incidental or consequential damages, loss of profits, loss of use or data, or interruption of business, whether the alleged damages are labeled in tort, contract or indemnity.
Power Utility Pak Version 7
©1999-2008 by J-Walk and Associates Inc.
All rights reserved
Removed Features
Following is a list of features that were present in PUP v6, but have been removed from PUP v7.
- Create a PUP Toolbar
Support for custom toolbars in Excel 2007 is extremely limited. You can, however, easily add frequently-used PUP commands to your Quick Access Toolbar. - Chart Shortcut Menus
Excel 2007 no longer supports custom shortcut menus for charts, so if you choose the PUP Enhanced Shortcut menu options, right-clicking a chart will have no new menu items. - Toggle FaceID Toolbar
This feature, intended for Excel developers, is no longer useful in Excel 2007. - Interactive Zoom
Zooming a worksheet is now a simple matter, using the Zoom controls in the Excel status bar. - Object Hide/Unhide
Excel's new Selection and Visibility pane makes this utility obsolete. - Insert Symbol
Excel's Insert Symbol tool is much better. - Add Path to Header or Footer
This utility is obsolete because Excel has this feature. - PUP Worksheet Functions
Removed two functions because they are not relevant for Excel 2007: CELLCOLORINDEX and CELLFONTCOLOR.
Other PUP Features
This document describes additional features in PUP v7.
Power Utility Pak Group
PUP Shortcut Menus
As an option, you can choose to display enhanced shortcut menus. You can quickly turn this feature on and off from the PUP v7 Ribbon.
-
Worksheet Cell, Range, Column, or Row:
IMPROVED
Adds the following menu items: Print selection, Toggle Word Wrap, Change Case, Format Number, Center Across Selection, Quick Chart, Synchronize Sheets, toggle PUP InfoBox, and toggle page break display (new) -
Excel Desktop:
Adds the following menu items: Minimize All Windows, Tile Windows, Activate a Window, Interactive Hide/Unhide -
Sheet Tab:
Adds the following menu items: Sort Sheet Tabs, Delete Empty Sheets, Activate a Sheet, Interactive Hide/Unhide, Hide Sheet. -
Workbook Title Bar:
Adds the following menu items: Toggle Vertical Scroll Bar, Toggle Horizontal Scroll Bar, Toggle Grid Lines, Toggle Row and Column Headers, Toggle Sheet Tabs, Toggle R1C1 Reference Style, Hide 'Windows.
Amusements:
-
Video Poker:IMPROVED
Choose from Joker's Wild or Jacks or Better. You can also change the payoffs for the various poker hands. The win/loss chart is now displayed in a pop-up dialog box. - Dice
Game:
Similar to Triple Yahtzee. With an option to have four rolls per turn instead of three (your scores will sky-rocket). - Bomb
Hunt:
Works just like Microsoft's Minesweeper. - Hangman:
The classic word-guessing game. Includes 4,200 words. - Sudoku
Puzzle Generator:NEW
Generates a 9x9 Sudoku puzzle (with solution). -
Random Number Generator:
Choose a random number between two specified values. Animated display of the numbers being chosen. Great for office raffles and drawings.
PUP v7 Worksheet Functions
PUP v7's Worksheet Function Library utility makes it easy to add one or more custom worksheet functions to your workbook. The functions available in the PUP Function Library are listed below. For more information, download the PUP Worksheet Function Help File.
Date & Time Functions
- DAYSINMONTH
Returns the number of days in the month for a date. - MONTHWEEK
Returns the calendar week for a date serial number. - TIMEXX
Returns a string that represents a time, displayed as hh:mm:ss:xx, where xx is hundredths of a second (or another unit). - TIMEXX_ADD
Returns a string that represents the sum of two TIMEXX time strings. The result is displayed as hh:mm:ss:xx. - TIMEXX_SUBTRACT
Returns a string that represents the difference between two TIMEXX time strings. The result is displayed as hh:mm:ss:xx. - TIMEXX_SUM
Returns a string that represents the sum TIMEXX time strings. The result is displayed as hh:mm:ss:xx. - WHICHDAY
Returns a date that corresponds to a specified day in a month. For example, the date of the first Friday in January for a given year. - XDATE
Returns a specified date as text, displayed using the optional fmt date format string. Supports pre-1900 dates. - XDATEADD
Returns a date as text, incremented by a specified number of days, using the optional date format string. The days argument can be negative. Supports pre-1900 dates. - XDATEDAY
Returns an integer that corresponds to the day for a date. Supports pre-1900 dates. - XDATEDIF
Returns the number of days between two dates. Supports pre-1900 dates. - XDATEDOW
Returns an integer that corresponds to the day of the week for a date. Supports pre-1900 dates. - XDATEMONTH
Returns an integer (between 1 and 12) that corresponds to the month for a date. Supports pre-1900 dates. - XDATEYEAR
Returns the year for a date. Supports pre-1900 dates. - XDATEYEARDIF
Returns the number of full years between two dates. This function is useful for calculating ages. Supports pre-1900 dates.
Information Functions
- CELLCOLOR
NEW
Returns a number (decimal or 6-digit hex) that corresponds to the cell's background color index. - CELLHASFORMULA
Returns TRUE if cell has a formula. - CELLTYPE
Returns the cell type of the upper left cell in a range. - EXCELDIR
Displays the full path for the folder in which Excel is installed. - FILEEXISTS
Returns TRUE if the specified file exists; FALSE otherwise. - FILENAME
Displays the full path and file name of the workbook. - FONTCOLOR
NEW
Returns a number (decimal or 6-digit hex) that corresponds to the cell's font color. - NUMBERFORMAT
Returns a string that represents the cell's number format. - SHEETCOUNT
Returns the number of sheets in the workbook. - SHEETNAME
Returns the name of a worksheet. - USER
Returns the name of the current user.
Lookup & Reference Functions
- CREDITCARD
Accepts a credit card number and returns a string that represents the type of credit card. . - HINTERPOLATE
Similar to Excel's HLOOKUP function, but it returns an interpolated value if an exact match is not found. - LASTINCOLUMN
Returns the value in the last non-empty cell in a column. - LASTINROW
Returns the value in the last non-empty cell in a row. - SHEETOFFSET
Allows relative sheet referencing. - UNIQUEITEMS
Returns the number of unique items in a list. Or, returns an array consisting of the unique items in a list. - VINTERPOLATE
Similar to Excel's VLOOKUP function, but it returns an interpolated value if an exact match is not found.
Statistical & Math Functions
- COUNTAVISIBLE
Similar to Excel's COUNTA function, but it returns the count of just the visible cells. Excel's built-in SUBTOTAL function is a better choice. - COUNTBETWEEN
Counts the number of cells that contain a value between two values. - MAXALLSHEETS
Returns the maximum value in a particular cell across all worksheets in a workbook. - MINALLSHEETS
Returns the minimum value in a particular cell across all worksheets in a workbook. - SELECTONE
Returns the value in a cell chosen at random from a range. - STATICRAND
Returns a random number that doesn't change when the worksheet is recalculated. - SUMALLSHEETS
Returns the sum of all values in a particular cell across all worksheets in a workbook. - SUMVISIBLE
Similar to Excel's SUM function, but it returns the SUM of just the visible cells. Excel's built-in SUBTOTAL function is a better choice. - TOPAVERAGE
Returns the average of the top n values in a list.
Text Functions
- CHAR2
NEW
Like Excel's CHAR function, but it works with Unicode characters. - CODE2
NEW
Like Excel's CODE function, but it works with Unicode characters. - CONTAINS
Returns TRUE if a string contains a specified sub-string. - DOLLARTEXT
Returns its numeric argument, spelled out as dollars and cents text. - EXTRACTELEMENT
Returns the nth element of a text string, where the elements are separated by a specified separator character. - INSERTSTRING
Inserts a text string at a specified location within another string. - ISLIKE
Returns TRUE if a string matches a pattern. - PARSENAME
Splits a string that contains a name into its component parts: first name, middle name, and last name. - REMOVESPACES
Removes all of the spaces from a string. - SAYIT
NEW
Uses Excel's text-to-speech engine to speak the argument. - SCRAMBLE
Accepts text or a value and returns it scrambled randomly.
The Utilities
The utilities are described below, arranged by the Ribbon group in which they appear.
Click a utility name to see a screen capture of its dialog box. For more information about a particular utility, download or view the PUP v7 documentation.
Cells and Ranges Group
Formula Tools
-
Convert Relative and Absolute References:
Change cell references in formulas to absolute or relative. -
Unapply Names:CHANGED
Convert a name reference in a formula to its actual reference (either absolute or relative). For example, the utility converts a formula such as =SUM(Region1) to =SUM(A2:A98). Unfortunately, this utility is now less functional than in the past. It will not run if your workbook contains identical names (for example, two identical sheet-level names on different sheets). Working with identical names was far too error-prone. -
Exact Formula Copy:IMPROVED
Makes an exact copy of formulas. Range references are not changed. This utility now handles a range that contains a mixture of array formulas and non-array formulas. -
Error Condition Wizard:IMPROVED
Makes it easy to add an error condition to a formula or group of formulas. This is useful when you want to avoid displaying error values such as $DIV/0! The wizard walks you through the steps to create the formula you need. This utility now includes an option to create the formula using the new Excel 2007 IFERROR function. -
Cell Comment Tools:
Change the appearance of all comments, search and replace text within comments, remove the user name from comments, or create a listing of all comments. -
Calculator:
A handy calculator. Paste the calculated results into a cell, or retrieve a value from a cell for additional calculations. -
PUP Worksheet Function Library:IMPROVED
This utility adds one or more VBA function macros to your workbook. These macros provide you with new worksheet functions that you can use in your formulas. Choose from a list of 53 functions. Removed two functions because they are not relevant for Excel 2007: CELLCOLORINDEX and CELLFONTCOLOR. Added five new functions: CELLCOLOR, CHAR2, CODE2, FONTCOLOR, and SAYIT. Click here for more information.
Modify Cells and Ranges
- Text
Tools:
Lets you manipulate the text in cells in the following ways: (1) Add text to the beginning, end, or at a specified character position; Remove characters from the beginning, end, or at a specified character position; (3) Change the case of selected text; (4) Remove excess spaces from text; Enhancements: the ability to remove leading spaces or trailing spaces. -
Change Sign of Value:
Fix trailing negative signs (e.g, convert 12.43- to -12.43), make all cells positive, make all cells negative, or reverse the sign of all values. -
Force Values in Cells:
When you import data, Excel sometimes fails to recognize numbers as numeric data. This utility forces Excel to recognize such data as numbers.
-
Math Without Formulas:
This utility enables you to change values in cells without using formulas. Very flexible, and lightning fast.
-
Delete Hyperlinks:
Enables you to delete hyperlinks from a range, a worksheet, or an entire workbook.
-
Range Randomize Utilities:
Lets you: (1) Generate a series of consecutive integers, arranged randomly in a range; (2) Randomly rearrange the values in a range; or (3) Randomly select n cells from a range.
- Swap
Ranges:
This utility makes it easy to swap the contents of two cells or two identically-sized ranges.
-
Transform Vertical Range:
Makes it easy to convert a single column of entries into rows with multiple columns.
-
Combine Columns or Rows:
This utility combines data in multiple columns (or rows) into a single cell in the column (or row). The user decides what to do with the data that has been combined: Keep it, delete it, or create merged cells. As an option, you can specify one or more characters to insert between the combined data (for example, a space). Enhancements: Added the ability to insert a line break, and the ability to combine cells "as formatted".
Format
-
Superscript/Subscript Formatting:
Simplifies the task of applying superscript or subscript formatting to characters in a cell. In addition, you can toggle the Bold and Italic attributes and the case (upper or lower) for alpha characters -- perfect for those who work with chemical formulas. -
Alternate Row Shading:IMPROVED
Applies user-specified shading to alternate rows in a range. The color choices are now the colors from the active workbook's document theme. -
3D Cell Shading:IMPROVED
Applies an attractive three-dimensional border effect to a cell or range. When applying 3D formatting to a range, you now have the option of not applying a background color.
Convert
-
Unit Conversion:
Easily convert measurements from one unit to another. Very flexible. Easily customizable if you purchase the VBA source code. -
Currency ConversionIMPROVED
Easily convert currencies from one unit to another, using exchange rates downloaded from the Internet. Supports more than 50 world currencies. You can convert a single amount interactively, or convert a range of values. You can update the exchange rate data at any time via the Internet (it takes only a few seconds). This utility uses a new (and more reliable) data source.
Select
-
Select by Value:
Lets you select cells in a specified range (or an entire worksheet) that meet certain criteria -- for example, select all cells with a value between 12 and 24. Or, select all cells that contain text that ends in "ing." Or, you can select entire rows based on the contents of a column. This utility, for example, provides a quick way to select (and then delete) all empty rows. -
Select Cells by Format:IMPROVED
Lets you select cells based on their formatting. For example, you can select all cells that contain a yellow background. Once selected, you can apply other formatting to the cells. Added a new option to select cells based on their style (something that Excel can't do). - Go
To Min or Max Value:
This utility selects the minimum or maximum value in a selected range of cells.
Workbooks and Sheets Group
Worksheet Tools
-
Interactive Hide / Unhide:
Makes it easy to change the hidden status of all open workbooks, or the sheets contained in those workbooks. -
Synchronize Sheets:
Forces all worksheets in the active workbook to display the same range selection and upper-left cell as the
- Cell
Lock / Sheet Protect Utilities:
Makes it easy to lock and unlock specific types of cells in a worksheet (for example, lock all cells that contain formulas). Also simplifies protecting and unprotecting sheets. -
Insert Sequence Number:
Makes it easy to insert a unique (and consecutive) value into a cell. You can define any number of sequences, specify a text prefix and/or suffix, and specify the number of digits for the number. For example: Invoice xxxx-2005 (where xxxx represents the sequence number).
-
Toggle Settings:CHANGED
Quickly toggle any of the following settings: gridlines, horizontal scrollbar, vertical scrollbar, row and column headers, page breaks, formula view, sheet tabs, status bar, formula bar, full screen display, comment visibility, and object visibility. It's all done interactively, so you can see the effect before you commit to it. The Toggle Settings dialog box no longer has an option to show/hide the Task Pane. It does, however, have an option to show/hide the Selection and Visibility pane. -
Set Scroll Area:
Makes it very easy to set the scrollable range in a worksheet to prevent users from scrolling outside of the appropriate area and getting lost. This utility works by hiding unneeded rows and columns.
-
Reset the Last Cell:
Forces Excel to reset the "last cell" -- the cell that is activated when you press Ctrl+End. Excel has always had a problem keeping track of this.
Workbook Tools
- Sort
Sheets:
A fast and flexible way to rearrange the order of the sheets in a workbook. -
Save With Backup:
Makes a backup copy of the active workbook at a specified location. -
Create Workbook Contents Sheet:
This utility adds a new worksheet, which functions as a table of contents for quick navigation to other sheets in the workbook. Choose between hyperlinks, or buttons and macros. -
Customize A New Workbook:
Creates a new workbook with specially-named sheet tabs. For example, you can create a workbook with sheets named Division-1, Division-2, etc. Or, specify a range that contains your sheet names. -
View Activeworkbook's Folder:NEW
This simple, but very useful command, opens an Explorer window that shows the files in the active workbook's directory.
-
Remove All Macros:
This utility will remove any or all of the following: VBA modules, UserForms, Excel 5/95 dialog sheets, or Excel 4 XLM macro sheets.
Date and Time
-
Perpetual Calendar:IMPROVED
This multi-purpose tool (1) Displays a handy calendar for any month and year; (2) Inserts a graphic image of any calendar month; (3) Creates a new workbook with up to 12 sheets, each displaying a calendar month -- perfect for schedules. The calendar picture is now rendered using the active workbook's theme colors and font. -
Insert a Live Calendar:NEW
Inserts a small calendar into an 8-row by 7-column range. The dates are calculated using formulas, so you can enter a new month and year in the top cell and the calendar updates automatically. -
Date
Picker: CHANGED
Makes it easy to insert a formatted date into a cell, or change the formatting of an existing date. The Date Picker is now a "stay-on-top" dialog box rather than a floating toolbar. However, it has the same functionality as the toolbar version. In fact, it has more functionality: you can choose to enter the date with formatting, the date only, or the formatting only. -
Reminder Alarm:
Displays a reminder at a specified time of day, or after a specified period of time has elapsed.
Printing
-
Batch Printing Wizard:
Print any number of workbooks unattended. The workbooks can be in a specified directory or across multiple directories. -
Print Multiple Selection Wizard:
Lets you print non-contiguous ranges of cells without page breaks between the separate ranges. -
Copy Page Setup:IMPROVED
Makes it easy to copy print setting from one worksheet to other worksheets in the same workbook. This utility has been completely rewritten, and now copies header/footer images.
-
Font Reference Sheet:NEW
Displays a handy interactive workbook that lets you view the characters in any font installed on your system.
Import / Export
-
Export Range to File:
Exports a range to a separate file (either an Excel workbook, a CSV text file, or an HTML file). -
Export Range as Graphic:
Converts a range (and the graphic objects displayed in the range) to a graphic file (GIF, JPEG, TIF, or PNG format).
-
Save Sheet as HTML:
Saves the active sheet in HTML format, with many user-specified options. Unlike Excel, it does not produce a bloated file.
-
Insert File at Cursor:
Insert a complete worksheet, range, or text file into the current worksheet, at the cursor position. Includes an option to copy values only (no formulas), and an option to ignore formatting. -
Filename Lister:IMPROVED
Many people are surprised to discover that Windows provides no direct way to print a list of the filenames contained in a directory. The Filename Lister utility creates a list of filenames in a worksheet, with an option to create hyperlinks. When importing a list of files, you can now specify that the list include the files in all subdirectories.
Charts and Graphics Group
Charting Tools
-
Chart Data Labeler:
Lets you apply labels (contained in a range) to a chart data series -- a feature that is surprisingly missing from Excel. Enhancement: -
Resize Charts:
Makes it easy to make a chart an exact size, or make all charts the same size. -
Convert Chart To Picture:CHANGED
Makes a copy of a chart as a static picture. This is useful for saving charts that depict various what-if scenarios. The grayscale option is no longer available (because it looked terrible). -
Export Charts:
Quickly converts Excel charts to stand-alone GIF, JPEG, TIF, or PNG files. -
Chart Report:
Produces a detailed report that documents a chart, or produces a report that documents all charts.
Object Tools
-
Object Align, Size & Space:
Back by popular demand. This utility was removed from PUP v5, but now it's back. It provides an easy way to precisely align, size, and space a group of objects or embedded charts. -
Object Report:NEW
Creates a report that describes all graphic objects on a worksheet. Useful for locating hidden objects.
Auditing Group
Miscellaneous
- PUP
InfoBox: CHANGED
Displays a handy stay-on-top (and resizable) dialog box that lists key information about a selected cell. This utility no longer includes the option to display information about the selected range. For some reason, this option consistently caused Excel 2007 to crash.
Reports
- Date
Report:
Creates a useful report that summarizes cells that contain dates. This can help you identify potential date-related problems. -
Formula Report:
Creates a useful report that lists all formulas in a worksheet or workbook. Enhancement: The report includes the cell name for the formula, if any. -
Workbook Summary Report:
Creates a useful report that summarizes many aspects of a workbook. -
Number Format Report:
Creates a report that lists all number formats used in a worksheet or in a workbook. -
Data Validation Report:
Creates a report that describes all cells that use Data Validation. -
Conditional Formatting Report:IMPROVED
Creates a report that describes all cells that use Conditional Formatting. The report format has been modified so it's a sortable table. It also includes the new Excel 2007 conditional formatting options. -
VBA Project Summary Report:
Creates a summary report of the VBA procedures in a workbook. As an option, the report can include details for all controls contained in the UserForms.
Utilities
-
Workbook Link Finder:
Lets you track down workbook links. More accurate link identification. - Name
Lister:
Lets you works with names in ways that are otherwise not possible. -
Compare Ranges:
Lets you easily identify the differences between two worksheets or ranges. -
Worksheet Map:CHANGED
Creates a handy map that visually identifies cells of various types. Includes a new option to code the formula cells by complexity. The floating toolbar (used to navigate between the map and the workbook) has been replaced by a stay-on-top dialog box.
PUP Bookmarks Group
Bookmark Tools
A handy and easily accessible toolbar that lets you create bookmarks so you can quickly return to a particular workbook, worksheet, or range. If the workbook is not open, it opens for you. The bookmarks you create are saved between sessions. An excellent (and much more flexible) alternative to Excel's most recently used file list.
-
Create a Bookmark:CHANGED
This command is available at the top level of the Ribbon, making it easier than ever to create a new bookmark. -
Edit Bookmarks:CHANGED
This command is available at the top level of the Ribbon, making it easier than ever to manage your bookmarks. -
Activate Bookmarks:CHANGED
This command is available at the top level of the Ribbon, making it easier than ever to activate a bookmark. A new option lets you use Ctrl+Shift+B to display a bookmark list at the cursor location.
VBA Source Code License
If you purchase the PUP v7 source code, you must agree to the terms of the Software License Agreement below.
J-Walk and Associates
Software License Agreement
Power Utility Pak Version 7
VBA Source Code Option
By downloading or receiving (on disk or CD-ROM) the software, you agree to abide by the following provisions.
SOFTWARE VERSIONS AND SCOPE OF THIS AGREEMENT
Power Utility Pak Version 7 ("PUP") exists in two versions: Trial Version and Fully-Licensed Version. The Fully-Licensed version has an option to purchase the complete VBA source code. This Software License Agreement covers Power Utility Pak Version 5 With the VBA Source Code Option. This Software License is in addition to the standard Software License for Power Utility Pak Version 7.
LICENSE
J-Walk and Associates grants you a license to use and copy the software program(s) and documentation subject to the limitations described here. The license does not expire.
DISTRIBUTION OF SOFTWARE
Any and all distribution of the PUP Fully-Licensed Version With VBA Source Code Option is prohibited.
BACKUP COPIES
You may make any reasonable number of backup copies of PUP Fully-Licensed Version With VBA Source Code Option.
MULTI-SYSTEM INSTALLATION
You may install PUP Fully-Licensed Version With VBA Source Code Option on multiple computer systems, subject to the condition that only one such system will be in use at any given time. For example, you may install the software on an office system and a home system.
SOURCE CODE USAGE RESTRICTIONS
- The VBA Source Code for PUP is intended primarily for educational purposes.
- The PUP files may not be sold, shared, or distributed in any way.
- The Source Code may be modified and adapted for PERSONAL USE ONLY. Apart from the exception below, modified files may not be sold, shared, or distributed in any way.
- Modified or customized versions of the files may be distributed within an organization, provided that each end-user is a Licensed User of Power Utility Pak v7.
COPYRIGHT
PUP and ancillary material are copyrighted by J-Walk and Associates. Do not delete the copyright notice, trademarks or protective notice from your copy or any copy you make.
WARRANTY
J-Walk and Associates does not warrant that the software will be free from errors or will meet your specific requirements. The software is made available to you "as is." However, if a problem is discovered and reported, J-Walk and Associates will take reasonable measures to correct the problem.
LIMITATIONS AND LIABILITY
J-Walk and Associates makes no warranty or condition, either express or implied, including but not limited to any implied warranties of merchantability and fitness for a particular purpose, regarding the software. In no event shall J-Walk and Associates or its suppliers be liable for any indirect, incidental or consequential damages, loss of profits, loss of use or data, or interruption of business, whether the alleged damages are labeled in tort, contract or indemnity.
Power Utility Pak Version 7
©1999-2008 by J-Walk and Associates Inc.
All rights reserved
Download the PUP v7 User's Manual
The link below is to the 120-page PUP v7 User's Manual, in Adobe PDF format. This document contains the same information as the Main Help File for PUP v7, but in a different format.
- PUP v7 User's Manual (804K)
Viewing or printing the PDF file requires Adobe Acrobat Reader, which may already be installed on your system. If not, you can download a free copy
here.
To save the PDF file (rather than read it online), right-click the link
and choose Save Target As (or Save Link As).
Download the Help files
PUP v7 is well-documented, with context-sensitive help. The PUP v7 Help files
are available as a separate download. These are *.chm files
(compiled HTML Help files). To download a file, right-click the link below and
choose Save Target As or Save Link As. After the file is transferred to your hard drive,
you can double-click it to view the contents using the Windows HTML Help viewer
(hh.exe).
- Main Help File (204K)
This is the primary documentation for PUP v7. It describes each of the utilities, and provides a variety of tips - PUP Worksheet Function Help File
(62K)
This file describes the 53 PUP Worksheet functions, and provides examples of each.
Note: Both of these files are included with PUP v7, so if you've already downloaded the product there is no need to download these Help files.
Can't read the CHM file?
Some users have reported that they can't open the *.chm files. The most likely cause is that *.chm files are blocked for security reasons. To unblock a *.chm file, right-click its filename, and choose Properties from the shortcut menu. If the Properties dialog box has a Security tab, click that tab and unblock the file.
Frequently Asked Questions
What is PUP?
PUP, which stands for "Power Utility Pak," is a unique collection of add-ins that enhance Microsoft Excel by adding new features and making existing features easier to use. It consists of general purpose utilities, new worksheet functions, and enhanced shortcut menus. All told, PUP v7 (the current version of the software) adds more than 70 new (and non-trivial) features to Excel.
Does PUP v7 work with all versions of Excel?
No. PUP v7 requires Excel 2007 or later.
Is the Trial Version fully functional?
Yes. The Trial Version of PUP v7 is not crippled in any way, and it doesn't even display any annoying nag messages. It works just like the real thing -- because it is the real thing. You may use the trial version for 30 days. After that, you should either purchase a license or delete the files from your system.
How much does it cost?
The price for a single-user license for PUP v7 is US $40.00. If you would also like the complete VBA source code, add $20.00 (total of $60.00).
Do I really need the source code?
The VBA source code for PUP v7 is intended for those who know (or those who are learning) Visual Basic for Applications (VBA). Those who purchase the source can learn how the utilities were created, and even customize them for their personal use. If you're not a VBA programmer (and don't intend to become one), you do not need the PUP v7 source code.
I ordered PUP v7 with the source code, but the VB projects are locked. How do I view the source code?
After you install PUP v7, look in your \pup7 directory. You'll find a PDF document name 'PUP v7 source.pdf'. This file describes how to access the source code for PUP v7.
I purchased an earlier version. Can I get an upgrade?
Yes, free upgrades are available. Go to the Upgrade Page for details. Please note that an upgrade is free, but if you would like to purchase the VBA source code, the $20.00 applies (even if you purchased the source code for a previous version). Also, there is a $5 processing fee for each upgrade.
Why do I have to pay the upgrade processing fee if I chose to download it?
It costs time and money to process an upgrade. When you download a file from this web site, someone (me) has to pay for the data transfer. Most people simply have no idea of how much it costs to operate a large web site on a fast and reliable server. I'm giving you the upgrade free, and I'm asking you to cover the distribution and processing costs. The vast majority of users (about 99.86%) don't have a problem with this.
How can I purchase PUP v7?
The most efficient method is to use a credit card and purchase online using a secure server. Your credit card is approved online, and you can download the files immediately. You can also order by fax or mail, but these methods require human intervention, and a $5.00 processing fee is applied.
Do you offer discounts for multiple copies?
Yes, refer to the table below.
| No. of Licenses | Discount % | PUP v7 Unit Price | PUP v6 Unit Price |
| 1-4 | 0% | $39.95 | $40.00 |
| 5-9 | 25% | $29.96 | $30.00 |
| 10-25 | 35% | $25.97 | $26.00 |
| 25-49 | 50% | $19.98 | $20.00 |
| 50-99 | 60% | $15.98 | $16.00 |
| 100-499 | 70% | $11.99 | $12.00 |
| 500-999 | 75% | $9.99 | $10.00 |
| 1000-4999 | 85% | $5.99 | $6.00 |
| 5000+ (site license) | sales@j-walk.com | ||
Do you offer any special deals for PUP v7?
Yes. Each of the books I've written includes a coupon for a discounted PUP license.
Please note: The coupon in older editions of these books will list an earlier version of PUP. If you'd like to receive PUP v7 instead, just indicate so on the coupon.
I bought one of those books. Can I get the discounted price by ordering online?
No. You must mail the coupon to get the discounted price.
I have the Trial Version, and I'd like to become a licensed user. Is there a way to "unlock" the trial version?
No. When you become a licensed user you'll need to download a new (very small) file to update your installation.
Do you offer any educational discounts?
Officially, no. However, I spent nine consecutive years in college, so I understand that students are often on a tight budget. Therefore, educational discounts will be considered on a case-by-case basis. Contact me and describe your situation.
When extracting the files, I get an error message about CHM files.
You may get this error is you're using Windows Vista. The solution is to right-click the *.exe file and then choose 'Run as Administrator.' Microsoft has apparently decided that *.chm files are a security risk.
The PUP v7 help doesn't work!
It's possible that a security update has disabled *.chm files on your system. Go to your \pup7 directory, and right-click the pup7.chm file. Choose Properties from the shortcut menu. If you see a Security tab, use the checkbox to unblock the file. Repeat for pupfunctions.chm.
Is PUP v7 copy protected?
No. Copy protection only serves to inconvenience honest users, and does very little to prevent software piracy. If you like PUP v7, you should purchase a license. Doing so will keep you honest, enable you to get free upgrades, and help support the concept of independent software development.
The license prohibits illegal copying. You can, however, distribute the Trial Version to as many people as you like.
What programming language did you use to develop the Power Utility Pak?
Power Utility Pak is written exclusively in Visual Basic for Applications (VBA). This is Excel's built-in macro language. It doesn't use any custom DLL files or non-standard controls, and it does not make any changes to your system (except for settings stored in the Windows registry).
How did you get that PUP v7 Ribbon to appear?
The pup7.xlam file contains XML code that creates the Ribbon when the add-in is loaded.
Is the VBA source code available?
Yes. The complete VBA source code is available to licensed users for an additional $20.00 -- a very small price to pay for literally hundreds of examples of useful programming techniques. Purchasing the source code will also let you see how the Ribbon is created. Click here for more information about purchasing the VBA source code.
I purchased PUP v7, and now I'd like to purchase the source code. I can't find a way to do that online without buying another copy of PUP.
That's because there is no way to determine licensed users. Send me an email and I'll provide instructions for paying the extra $20 for the PUP source code.
If I purchase this product, can I adapt your VBA code for applications that I develop?
Yes, but the applications that you develop may not be sold or used for commercial purposes (refer to the VBA Source Code License Agreement).
If you have any questions about this, please contact me..
Does PUP v7 include a user manual?
To reduce the size of the PUP v7 download, a printable manual is not included. The product's documentation is in the form of thorough, context-sensitive help files. You can, however, download a User's Manual in PDF format, or you can download the help files separately.
Is PUP v7 a memory hog?
Not at all. Memory usage was a primary consideration in developing this product. PUP v7 is modular, so only the utilities that you actually use are loaded into memory. PUP v7 includes an option that lets you control how many utilities will remain in memory.
How long has Power Utility Pak been around?
Power Utility Pak was first developed in 1994, shortly after Excel 5 was released. I was looking for a project that would help me learn VBA -- the programming language that debuted in Excel 5. I created some utilities, gave them the unimaginative name of Power Utility Pak, and included them with my Excel 5 Power Programming Techniques book.
I continued working on the project, added some new utilities, and released an updated (shareware) version called Power Utility Pak 2.0. When Excel 97 was released, I worked on it some more (a lot more), and released PUP97 -- which happened to win a ZDNet Shareware Award in 1998. I continued to add new utilities and enhancements, and PUP97 evolved into PUP 2000, which became available when Excel 2000 was released.
PUP v5 was the most significant upgrade, and it included about 20 new utilities, and most of the others were significantly enhanced. PUP v6 added still more utilities and improvements.
The current version, PUP v7, was started during the beta phase of Office 2007. Because Excel 2007 is so different from previous versions, I decided to create a new Excel 2007-only version.
Is there a Macintosh version of PUP?
No, and there are no plans for one. The number of Excel for Macintosh users is relatively small, and the products are so incompatible that it would be like creating a brand new product.
I have an idea for a new utility for the next version of Power Utility Pak. Are you open to suggestions?
Absolutely. The main requirement is that the utility must be general purpose in nature, and add something that's useful to a fair number of users.
How do I get technical support?
Technical support is available by e-mail, directly from the developer. Questions are typically answered within 24 hours, usually more quickly. Details at the Technical Support page.
What do I do if I discover a bug in PUP?
First, check the PUP v7 Update Page. An updated version of the utility may be available, and you can download the new file.
If an update is not available, send an e-mail, and describe the problem and the steps required to reproduce it. The problem will be corrected, and the updated file will be made available to everyone.
I developed an application that uses one of the custom worksheet functions included with PUP v7. Can I distribute the workbook file that contains the functions?
Yes, workbook files that use any of the PUP worksheet functions can be distributed. However, the application may not be sold or used for commercial purposes.
Should I uninstall an earlier version of PUP before installing PUP v7?
You can if you want to, but it's not necessary. The first time PUP v7 loads, it will uninstall any previous version that it finds: PUP97, PUP 2000, PUP v5, or PUP v6.
How do I install PUP v7?
Installation is a two-step process:
- Execute the *.exe file to extract the PUP v7 files. If you're using Vista, right-click the file and choose 'Run as Administrator.'
- After the files are copied, a workbook named 'pup installation instructions.xlsm' is opened automatically, and provides additional instructions.
Can I move my copy of PUP v7 to a different computer?
Yes, all of the PUP v7 files are contained in a single directory. You can simply copy the files to your new system, and then delete them from your old system. You can transfer the files via a network connection, burn them to a CD-ROM, or even copy the files to a series of floppy discs.
After the files are copied, you'll need to install the add-in. To do so, start Excel and open the workbook named 'pup installation instructions.xlsm' for additional information.
How does PUP v7 work?
PUP was developed using the programming tools that are supplied with every copy of Excel -- the Visual Basic for Applications (VBA) macro language. One of the primary design goals of PUP v7 was simplicity. Consequently, it does not use any custom DLLs or non-standard controls, and it does not make any changes to your system settings (except for settings stored in the Windows Registry).
Here's a basic overview of how the product works:
- PUP v7 consists of dozens of add-in files, which use a *.pup7 extension, rather than an *.xlam extension. They are, however, standard Excel add-in files. The *.pup7 extension is used because these individual files are not intended to be installed separately. Therefore, they don't appear in the Browse dialog box when the Browse button is clicked from Excel's Add-Ins dialog box.
- When the pup7.xlam add-in is opened, the new Ribbon tab is created based on the XML code stored in the file. The pup7.xlam file controls loading and unloading of the utilities.
- pup7.xlam loads the utilities on an "as needed" basis so they won't use up memory and system resources if they are not used.
- pup7.xlam keeps track of which utilities are in memory, and you can specify the maximum number of utility files to keep in memory. You control this in the PUP Options dialog box (choose PUP Options from the Power Utility Pak menu).
- PUP stores its settings in the Windows Registry database. This is also
where it stores the last-used dialog box settings. The path is:
HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Power Utility Pak\
Can I view PUP's registry settings?
To view the current registry settings, choose PUP v7 - Power Utility Pak - PUP - About PUP v7. Then click the Registry Settings button, and respond Yes to the message box. This will create a new workbook that displays all of the settings.
Can I delete PUP's registry settings?
To delete all of the registry settings for PUP v7, choose Power Utility Pak - PUP - About PUP v7. Then click the Registry Settings button, and respond No to the message box. This will delete all of the settings, and it will be as if you just installed PUP v7.
Does PUP v7 use the same registry entries as PUP v6?
Yes. Therefore, if you upgrade from PUP v6 to PUP v7, all of your previous setting will be intact (including your PUP Bookmarks).
Can I temporarily uninstall PUP v7?
Sure. In Excel, press Alt+TI to display the Add-Ins dialog box. Remove the checkmark from the Power Utility Pak v7 item and click OK. This will remove the PUP v7 tab and Ribbon (and unload any PUP utilities that are open). Keep in mind that this does not delete any files.
To install PUP v7 again, repeat the command, but place a checkmark next to the Power Utility Pak v7 item.
The text in the PUP v7 dialog boxes is cut off
If the text in some of the PUP v7 dialog boxes appears cut off, or is not displayed correctly, you're probably using the "Large Fonts" system option. Unfortunately, this setting is not fully compatible with Excel custom dialog boxes.
Activate the Windows Control Panel and access the Display Properties dialog box. Click the Settings tab and change the Font Size setting to Small Fonts.
When I enter a PUP function name into my formula, the formula returns a #NAME? error.
This error can be caused by the following:
- The workbook does not contain the VBA code that defines the function. In Excel, choose Formulas - Function Library - Insert Function. In the Insert Function dialog box, choose the User Defined category to display a list of non-standard functions that are available. If the PUP function you need is not listed, use the PUP Worksheet Function Library to add the function to your workbook. Choose PUP v7 - Cells and Ranges - Formula Tools - PUP Worksheet Function Library.
- You spelled the function name incorrectly. Consider using the Insert Function dialog box to choose the function from a list. The PUP functions are listed in the User Defined category.
When I use a PUP worksheet function, it doesn't update automatically.
Some of the functions may require a complete recalculation in order to update. To force a recalculation, press Ctrl+Alt+F9.
Some of the PUP worksheet functions recalculate very slowly.
If you use a function in many formulas, you may experience significantly slower calculation times. This is perfectly normal. A custom function will never be as fast as Excel's built-in functions.
A PUP worksheet function doesn't return the correct answer.
Although every attempt was made to make these functions robust and error-free, it's possible that, under some circumstances, they may return an error or an incorrect value.
- Make sure you read the help file for the function. You may have overlooked a subtle point.
- Try using the function with a different set of data. If the problem does not occur, try to determine the differences between the two data sets.
- Check the PUP v7 update page. It's possible that a more recent version of the PUP Function Library utility has been posted.
- Send an e-mail, and describe the problem in detail. If it is a problem with the function, it will be corrected and an update will be posted.
When I enter a PUP worksheet function into my formula, it is not converted to uppercase. Excel's built-in functions all get converted to uppercase.
When you use a custom function (such as any of the PUP worksheet functions), Excel "remembers" how you entered it the first time it was used. Therefore, if you enter a PUP function in uppercase the first time it is used, subsequent uses of that function will be converted to uppercase automatically.
Keep your copy of PUP up-to-date
The goal is to make every component of PUP v7 error-free and accurate. Free bug fixes and updated files are available from this page. These files will not work unless you have PUP v7 installed (either the Licensed Version or the Trial Version).
The current updates are listed in the table below.
Installing an update file
- Right-click the link in the Update File column and save the file to your hard drive.
- Make sure Excel is not running.
- Copy the file to your \pup7 directory. By default, this is directory is c:\program files\pup7.
- When you re-start Excel, PUP will use the updated file.
| Update File | Version | What Was Corrected |
| Currency Conversion | 7.1 | Refreshing the rates now works. This is a ZIP download. Two files must be replaced. |
Report a problem
If you discover a problem in PUP v7, please use e-mail to report it. Describe the problem and the steps required to reproduce it. The problem will be corrected and an updated file will be available here.
Technical Support
If you encounter a problem with a particular utility, start by checking the PUP v7 Program Update site. It's possible that a corrected version of the utility is available. If so, you can download a free copy.
Also, please check the list of frequently asked questions to see if your question is addressed.
To report a problem with PUP v7, contact J-Walk & Associates via email. The problem will be corrected, and the updated file will be posted at the PUP v7 Program Update site.
About the VBA Source Code
As an option, licensed users of PUP v7 can purchase the complete VBA source code
for an additional $20.00.
You'll learn how PUP v7 works, and you'll pick up dozens of new programming techniques along the way. The PUP source code is an excellent learning tool for VBA programmers of all levels. Even advanced programmers will probably pick up lots of new techniques.
What do you get?
If you purchase the PUP v7 Developer's Package ($60.00), you receive an end-user license for PUP, plus a PDF document that describes how to access all of the VBA source code for PUP v7.
The Software License Agreement
Follow the link below to read the Software License Agreement for the PUP Source Code option.
What can you do with it?
The VBA source code is available primarily for educational purposes.
The utilities in PUP v7 cover a wide range of applications. Studying a particular utility can provide you with new insights for developing your own Excel applications. Or, you might want to customize a particular PUP utility to better meet your needs. In either case, there's an excellent chance that you'll learn something about VBA that you didn't know before.
What can't you do with it?
- You may not give or sell the source code (or password) to anyone else.
- You may not use the PUP v7 source code to create commercial applications.
- You may not use the PUP source code to create add-ins that are used within your company -- unless every end-user also has a PUP license.
The PUP license is actually very simple: Anyone who uses PUP must be a licensed user. And this includes using applications that are derived from PUP.
If you have any questions about using PUP source code, please contact sales@j-walk.com.
More
PUP v7 was created using Visual Basic For Applications. VBA is the programming language built into Excel and many of the other Microsoft Office applications. PUP v7 uses no DLL files, and no non-standard controls. In other words, PUP v7 was designed for maximum compatibility.
Pricing for PUP v7 is as follows:
- Single-user license: US $40.00.
- Single-user license, with complete VBA source code: US $60.00.
- Quantity discounts are available for five or more licenses.
- Shipping/handling: Not applicable. PUP v7 is delivered electronically (CD-ROMs are not available). However, if your order requires human intervention (i.e., by mail or fax), a $5.00 processing fee applies.
Ordering Options
Order PUP v7 using any of the options described below.
- Order online using a secure server
The easiest and most efficient method. Your credit card is approved online and you download the files immediately. No processing fee, and no human interaction is required. - Order by fax
Requires a credit card. Fax orders are typically processed within 24 hours, but please allow 2-3 days. $5.00 processing fee. - Order by mail
Requires a credit card, check, or money order. $5.00 processing fee.
Important:
If you're using Windows Vista, be aware that Microsoft has deemed *.chm files to be a security risk and will install them only if you're an administrator.
When installing the PUP v7 trial, right-click the EXE file and choose 'Run As Administrator' from the shortcut menu.
About the Trial Version
The Trial Version of PUP v7 is fully-functional, and is not crippled in any way. In fact, it doesn't even display the traditional (and annoying) nag messages until the 30-day trial has expired. You can use the Trial Version for 30 days. After 30 days, you must delete the files or purchase the licensed version.
Download
Click the link below to download the Trial Version of PUP v7. The file is a self-extracting EXE file (named pup7trial.exe).
- Download PUP v7 Trial Version
(3.0 Mb)
Installation
For best results:
- Save the pup7trial.exe file to your hard drive.
- Double-click pup7trial.exe to extract the PUP v7 files.
- An Excel workbook will open automatically, with additional installation instructions.
Important:
If you're using Windows Vista, be aware that Microsoft has deemed *.chm files to be a security risk and will install them only if you're an administrator.
When installing the PUP v7 trial, right-click the EXE file and choose 'Run As Administrator' from the shortcut menu.
Note
Installing PUP v7 will uninstall any previous version of PUP that's installed. It will not delete the old files, however, so you can reinstall the previous version if desired.
PUP v7 Features
PUP v7 is the most comprehensive set of Excel add-in tools available.
- PUP augments Excel with more than 70 general purpose Excel utilities and 53 worksheet functions. You also get six non-serious amusements, for when you need a break from number-crunching.
- Easy-to-use tab-and-ribbon user interface integrates seamlessly with Excel 2007.
- Includes options to:
- Remember the last settings used in PUP dialog boxes
- Display the most recently used PUP dialog box (by pressing Ctrl+Shift+R)
- Display a graphic progress indicator for lengthy operations
- An auto-unload option for improved memory management (you specify the maximum number of utility files to keep in memory).
- Single-level Undo is available for most of the operations.
- The VBA code for PUP Worksheet functions can easily be inserted into any workbook (eliminating the need for external links). PUP v7 is not required to use these functions, so you can share your workbook with others who don't have a PUP license.
- Detailed context-sensitive help .
- You can add frequently used PUP commands to your Quick Access Toolbar.
- And it's a great learning tool. The complete VBA source code is available for a very modest fee (US $20).
Details
More about the specific features available in PUP v7:
- The PUP Utilities (with screen captures)
- The PUP Worksheet Functions
- Other PUP Features
- Removed Features
New Tools for Excel 2007
Power Utility Pak Version 7 (PUP v7) is a useful collection of add-ins that brings significant new functionality to Excel 2007 and Excel 2010. When PUP is installed, you can do things with Excel that you never thought were possible. Regardless of your experience level, you'll find features in PUP that can make your job easier. PUP v7 augments Excel with about 70 new commands and 53 new worksheet functions. The product is designed to work seamlessly with Excel.
PUP v7 takes advantage of the Ribbon user interface introduced in Excel 2007, so accessing the PUP tools is easier than ever. Click the image below for a larger view of the PUP v7 Ribbon.
Use the menu on the left to find out more about PUP v7. Better yet, take a few minutes and download a free (and fully functional) 30-day trial. Installation is easy, so you'll be up and running in a few minutes.
Requirements
- PUP v7 requires Excel 2007 or Excel 2010.
- It will not work with previous versions of Excel
- It will not work with any version of Excel for Macintosh.
Using an earlier version of Excel?
- If you use Excel 2000, Excel 2002, or Excel 2003: PUP v6 is the version for you.
Power Utility Pak v7
Add-in Tools for Excel 2007
