J-Walk & Associates, Inc.

Software License Agreement

If you purchase PUP v6, you must agree to the terms of the Software License Agreement below.

 

J-Walk and Associates
Software License Agreement

Power Utility Pak Version 6

By downloading the software, you agree to abide by the following provisions.

SOFTWARE VERSIONS

Power Utility Pak Version 6 ("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 6
©1999-2008 by J-Walk and Associates Inc.
All rights reserved

Download the PUP v6 User's Manual

The link below is to the 120-page PUP v6 User's Manual, in Adobe PDF format. This document contains the same information as the Main Help File for PUP v6, but in a different format.

• PUP v6 User's Manual (780K)

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.

Download the Help files

PUP v6 is well-documented, with context-sensitive help. You can download the Help files for PUP v6. These are *.chm files (compiled HTML Help files). To download a file, right-click the link and choose Save Target 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 (211 K)
  This is the primary documentation for PUP v6. It describes each of the utilities, and provides a variety of tips
• PUP Worksheet Function Help File (59K)
  This file describes the 50 PUP Worksheet functions, and provides examples of each.

Note: Both of these files are included with PUP v6, so if you've already downloaded the product there is no need to download these Help files.

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, enhanced shortcut menus, and a handy PUP Bookmarks toolbar.

Does PUP v6 work with all versions of Excel?

No. PUP v6 requires Excel 2000 or later.

Does PUP v6 work with Excel 2007

PUP v6 works with Excel 2007, but not very well. If you use PUP 2007, you'll want PUP v7 -- which was created specifically for Excel 2007.

Is the Trial Version fully functional?

Yes. The Trial Version of PUP v6 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 v6 is US $39.95. If you would also like the complete VBA source code, add $20.00 (total of $59.95).

Do I really need the source code?

The VBA source code for PUP v6 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 v6 source code.

I purchased an earlier version. Can I get an upgrade?

Yes, free upgrades are available. See the link on the left. Please note that upgrades are free, but upgrades to the VBA source code are $20.00. Also, there is a $5 upgrade processing fee.

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.73%) don't have a problem with this.

How can I purchase PUP v6?

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 mail.

• PUP v6 ordering information

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?

Yes. Each of the books I write contains a coupon for a free (or significantly discounted) copy of PUP. These books are all published by Wiley, and are written by John Walkenbach, who is also the developer of PUP v6.

Please note: Although the coupon in these books may list an earlier version of PUP, you will actually receive the current version (PUP v6).

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.

Is PUP v6 copy protected?

No. Copy protection only serves to inconvenience honest users, and does very little to prevent software piracy. If you like PUP v6, 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 ActiveX controls, and it does not make any changes to your system (except for settings stored in the Windows registry).

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.

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.

I purchased PUP v6 with the VBA Source Code option. How do I view the source code?

Look in your \pup6 directory. You will find a MS Word document that contains all of the information you need.

Does PUP v6 include a user manual?

To reduce the size of the PUP v6 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.

• PUP v6 Documentation Download

Is PUP v6 a memory hog?

Not at all. Memory usage was a primary consideration in developing this product. PUP v6 is modular, so only the utilities that you actually use are loaded into memory. PUP v6 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 born 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 in 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 builds off of the previous version, and includes several new features and enhancements.

What happened to PUP v5

PUP v5 is no longer sold. It has been replaced by PUP v6.

What happened to PUP 2000?

PUP 2000 is no longer available. If you use Excel 2000 or later, you'll most definitely want PUP v6.

What happened to PUP97?

PUP97 is no longer available. It has been replaced by later versions. If you still use Excel 97, there is not a current version of PUP that's compatible.

What about PUP 2.0?

That version is long gone.

PUP 1.0?

Don't ask.

Is there a Macintosh version of PUP?

No, and there are no plans for one.

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. Send e-mail to support@j-walk.com.

What do I do if I discover a bug in PUP?

First, check the PUP v6 Update Site. An updated version of the utility may be available, and you can download the new file.

If an update is not available, send e-mail to support@j-walk.com, 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 v6. 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. If you have any questions about this, please contact support@j-walk.com.

Should I uninstall an earlier version of PUP before installing PUP v6?

You can if you want, but it's not necessary. The first time PUP v6 loads, it will uninstall PUP97, PUP 2000, or PUP v5.

How do I install PUP v6?

Installation is a two-step process:

1. Execute the *.exe file to extract the PUP v6 files. In the Trial Version, execute pup6trial.exe to extract the files. In the Licensed Version, the file is name pup6.exe (or setup.exe if you purchased the CD-ROM).
2. Start Excel and choose Tools - Add-Ins. Click the Browse button and locate the pup6.xla add-in file. By default, the PUP v6 files are extracted to this directory:

c:\program files\pup6\
  

Can I move my copy of PUP v6 to a different computer?

Yes, all of the PUP v6 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, copy the files to a series of floppy discs, or burn them to a CD-ROM.

After the files are copied, you'll need to install the add-in. To do so, start Excel. Choose Tools Add-Ins. In the Add-Ins dialog box, click the Browse button and locate the pup6.xla file.

How does PUP v6 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 v6 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 v6 consists of dozens of add-in files, which use a *.pup extension, rather than an *.xla extension. They are, however, standard Excel add-in files. The *.pup extension is used so these files won't appear in the Browse dialog box when the Browse button is clicked from Excel's Add-Ins dialog box.
• When the pup6.xla add-in is opened, VBA code builds the PUP v6 menu, and it controls loading and unloading of the utilities.
• pup6.xla loads the utilities on an "as needed" basis so they won't use up memory and system resources if they are not used.
• pup6.xla 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 PUP v6 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 for PUP v6: Select About Power Utility Pak from the PUP v6 menu. 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 v6: Select About Power Utility Pak from the PUP v6 menu. 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 v6.

Does PUP v6 use the same registry entries as PUP v5?

Yes. Therefore, if you upgrade from PUP v5 to PUP v6, all of your previous setting will be intact.

Can I temporarily uninstall PUP v6?

Sure. In Excel, choose Tools -Add-Ins. Remove the checkmark from the Power Utility Pak v6 item and click OK. This will remove the PUP v6 menu (and any PUP utilities that are open).

To install PUP v6 again, repeat the command, but place a checkmark next to the Power Utility Pak v6 item.

The PUP v6 menu sometimes disappears. What's wrong?

The most likely reason is that another Excel application has reset the menu bar. Or, you may have changed your mind about closing Excel (i.e., clicked Cancel in response to a "Save the file" message after requesting to close Excel).

Press Ctrl+Shift+U to rebuild the PUP v6 menu. If you use another add-in that insists on resetting the menu bar, you can create a PUP v6 toolbar and access the PUP utilities from the tool bar.

I moved my PUP v6 files to a different directory, and now the toolbar buttons don't work.

The solution is simple: Create a new toolbar. Choose Create a PUP Toolbar from the PUP v6 menu. This will delete the old toolbar and create a new one that points to the new location of your PUP v6 files.

Can I create more than one PUP toolbar?

Yes, but you'll need to rename the existing PUP toolbar before you create a new one (otherwise it will replace the existing one). To rename a toolbar, choose View | Toolbars | Customize. Select the Toolbars tab in the Customize dialog box. Select the 'PUP v6' item and click Rename.

Everyone once in a while, Excel starts acting strangely. Is this a PUP v6 problem?

Unfortunately, it's not uncommon to encounter a situation in which Excel stops working properly. For example, the video display may be incorrect, or Excel may suddenly stop responding to commands. 

The most common cause of general "strangeness" on the part of Excel is not enough system resources (Excel has always had a serious problem in this area). The solution is to exit Excel and re-start Windows. If possible, don't run any other applications while you use Excel. 

This problem is not caused by the Power Utility Pak per se. However, if you've loaded many of the PUP v6 utilities, you might try unloading some or all of them. You may find that restarting Windows several times per day solves this type of problem. Upgrading to a more recent version of Windows (such as Windows 2000 or Windows XP) may also help.

Also, it's a good idea to keep track of which add-in programs are installed (use the Add-Ins command on the Tools menu). In addition, you may have add-ins in your XLStart directory. These add-ins are loaded every time Excel starts, and may not even be listed in the Add-Ins dialog box. Add-ins consume memory and resources, and there is no need to load them if you don't use them. Look to see whether you really need these programs to be loaded at startup, or contact your System Administrator if you you�re unfamiliar with this process.

The text in the PUP v6 dialog boxes is cut off

If the text in some of the PUP v6 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. Select Function from the Insert menu, and 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. Select PUP Worksheet Function Library from the PUP v6 - Formula Tools menu.
• 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.

1. Make sure you read the help file for the function. You may have overlooked a subtle point.
2. 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.
3. Check the PUP v6 update web site. It's possible that a more recent version of the PUP Function Library utility has been posted.
4. Contact support@j-walk.com. 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 v6 error-free and accurate. Free bug fixes and updated files are available from this page. These files will not work unless you have PUP v6 installed (either the Licensed Version or the Trial Version).

The current updates are listed in the table below.

Installing an update file

1. Right-click the link in the Update File column and save the file to your hard drive.
2. Make sure Excel is not running.
3. Copy the file to your \pup6 directory. By default, this is directory is c:\program files\pup6.
4. When you re-start Excel, PUP will use the updated file.
    

Update File	Version	What Was Corrected
Currency Conversion	6.5	Uses a new (and more reliable) data source for the currency rates. This update requires replacing two files. They are both in the zip file. Updated on 22-Aug-08.
Enhanced Shortcut Menus	6.1	Two menu items on chart-related shortcut menus were not deleted when PUP's Enhanced Shortcut Menus were turned off. This update corrects the problem. Updated on 12-Aug-05.
PUP Date Picker Toolbar	6.1	Fixes a problem with incorrect dates when using the 'Week starts on Monday' option and the first day of the month is a Sunday. Updated on 11-May-05
PUP Help File	6.1	Fixes a problem with the PUP v6 Help file Contents: Chart Report was listed twice. Updated on 06-Jan-05
PUP Options	6.2	Fixes the "380 Error" that may occur when you attempt to view or change the PUP Options. Fixes the problem of the Options dialog box not displaying all the PUP utilities that are currently loaded. Updated on 20-Dec-04, and 18-Mar-05.
Range Randomize Utilities	6.1	Fixes the compile error when using the 'Select cell(s) at random' option. Updated on 19-Dec-04.
Data Validation Report	6.1	Eliminates the error that occurs if a data validation cell is merged with one or more other cells that do not contain data validation. Updated on 19-Dec-04.
Conditional Formatting Report	6.1	When generating a report for the active sheet only, the sheet name in the report may not correspond to the original worksheet name. Updated on 18-Dec-04.
Create a PUP Toolbar	6.1	Some of the toolbar buttons opened the wrong utility. Updated on 17-Dec-04.

About version numbers

Each PUP utility is stored in a separate *.pup file. The version number for the initial release of PUP v6 is Version 6.0. Updated files will have a later version number. To determine the version number of a particular PUP v6 utility:

1. Locate the *.pup6 file in an Explorer window.
2. Right-click the file name and select Properties.
3. In the Properties dialog box, click the Summary tab. The version number is listed in the Keywords field.

Report a problem

If you discover a problem in PUP v67, 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 v6 Program Update site. It's possible that a corrected version of the utility is available. If so, you can download a free copy.

• PUP v6 Program Updates

Also, please check the list of frequently asked questions to see if your question is addressed.

• PUP v6 FAQ

To report a problem with PUP v6, contact J-Walk & Associates via email. The problem will be corrected, and the updated file will be posted at the PUP v6 Program Update site.

• support@j-walk.com

About the VBA Source Code

As an option, licensed users of PUP v6 can purchase the complete VBA source code for an additional $20.00.

You'll learn how PUP v6 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 v6 Developer's Package ($59.95), you receive an end-user license for PUP, plus a Microsoft Word document that describes how to access all of the VBA source code for PUP v6.

The Software License Agreement

Follow the link below to read the Software License Agreement for the PUP Source Code option.

• Software License Agreement

What can you do with it?

The VBA source code is available primarily for educational purposes.

The utilities in PUP v6 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 v6 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 v6 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 v6 was designed for maximum compatibility.

Pricing for PUP v6 is as follows:

• Single-user license: US $39.95.
• Single-user license, with complete VBA source code: US $59.95.
• Quantity discounts are available for five or more licenses.
• Shipping/handling: Not applicable. PUP v6 is delivered electronically (CD-ROMs are not available). However, if your order requires human intervention (i.e., by mail), a $5.00 processing fee applies.

Ordering Options

Order PUP v6 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 mail 
  Requires a credit card, check, or money order. $5.00 processing fee.

About the Trial Version

The Trial Version of PUP v6 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 v6. The file is a self-extracting EXE file (named pup6trial.exe).

• Download PUP v6 Trial Version (2.4 Mb)
   

Installation

For best results:

1. Save the pup6trial.exe file to your hard drive.
2. Make sure that Excel is not running.
3. Double-click pup6trial.exe and follow the instructions.

Note

Installing PUP v6 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.

Other PUP Features

This document describes additional features in PUP v6.

Enhanced Shortcut Menus

As an option, you can choose to display enhanced shortcut menus. Improvement: No longer uses a custom image to identify PUP commands. This solves a potential problem of overwriting the Clipboard when Excel is opened.

• Worksheet Cell, Range, Column, or Row:
  Adds the following menu items: Print selection, Toggle Word Wrap, Change Case, Format Number, Center Across Selection, Quick Chart, Synchronize Sheets. Enhancement: Added Toggle PUP Infobox Toolbar.
• Chart:
  Adds the following menu items: Export Chart as Graphic, Chart Data Labeler. Enhancements: Added Convert Chart To Picture and Chart Report.
• 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.

PUP Bookmarks

• PUP Bookmarks: 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 alternative to Excel's "most recently used file list."

Amusements

Need a break from crunching numbers? PUP v6 includes:

• Video Poker: 
  Choose from Joker's Wild or Jacks or Better. You can also change the payoffs for the various poker hands.
• Dice Game:
  Like Triple Yahtzee. You have 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 700 additional words.
• 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 v6 Worksheet Functions

PUP v6'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

• CELLCOLORINDEX
  Returns a number that corresponds to the cell's background color index.
• CELLFONTCOLOR
  Returns a number that corresponds to the cell's font 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.
• 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

• 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.
• SCRAMBLE
  Accepts text or a value and returns it scrambled randomly.

The Utilities

The utilities are described below, by category. To view a screen shot, click the utility's title. For more information about a particular utility, download or view the PUP v6 documentation.

Range Tools

• 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.
• 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.
• 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.
• 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:
  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. Note: Excel 2002 and later also provides this feature.
• Go To Min or Max Value:
  This utility selects the minimum or maximum value in a selected range of cells.
• 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.
• 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.
• Delete Hyperlinks:
  Enables you to delete hyperlinks from a range, a worksheet, or an entire workbook.
• 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).
• 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).
• 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".

Formula Tools

• Math Without Formulas:
  This utility enables you to change values in cells without using formulas. Very flexible, and lightning fast.
• Exact Formula Copy:
  Makes an exact copy of formulas. Range references are not changed.
• Convert Relative and Absolute References:
  Change cell references in formulas to absolute or relative.
• Unapply Names:
  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).
• Unit Conversion: 
  Easily convert measurements from one unit to another. Very flexible. Easily customizable if you purchase the VBA source code.
• Currency Conversion: 
  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).
• Error Condition Wizard:
  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.
• PUP Worksheet Function Library:
  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 50 functions, including the popular XDATE functions.

Formatting Tools

• 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.
• Insert Symbol:
  Makes it easy to insert a special character from any installed font. Note: This is primarily for Excel 2000 users; Excel 2002 and later provides a much better implementation of this feature.
• 3D Cell Shading:
  Applies an attractive three-dimensional border effect to a cell or range.
• Alternate Row Shading:
  Applies user-specified shading to alternate rows in a range. Improvements: Avoids the error when attempting to apply conditional formatting to a shared workbook
• Font Reference Sheet:  
  Displays a handy interactive workbook that lets you view the characters in any font installed on your system.

Worksheet Tools

• Toggle Settings:
  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.
• 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.

• Interactive Zooming:
  Adjust the worksheet zoom level interactively, for the active sheet or for all sheets. Improvements: Smooth zooming, "stay on top" dialog so you can select other sheets or workbooks.
• 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.
• Calculator:
  A handy calculator. Paste the calculated results into a cell, or retrieve a value from a cell for additional calculations.
• Synchronize Sheets:
  Forces all worksheets in the active workbook to display the same range selection and upper-left cell as the active sheet.
• 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

• 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.
• Interactive Hide / Unhide: 
  Makes it easy to change the hidden status of all open workbooks, or the sheets contained in those workbooks. 
• 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.
• Filename Lister:
  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. Improvement: Option to create hyperlinks.

Chart & Graphics Tools

• Export Charts:
  Quickly converts Excel charts to stand-alone GIF, JPEG, TIF, or PNG files.
• 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: Now ignores data that is hidden as a result of autofiltering.
• Resize Charts:
  Makes it easy to make a chart an exact size, or make all charts the same size.
• Convert Chart To Picture:
  Makes a copy of a chart as a static picture. This is useful for saving charts that depict various what-if scenarios.
• Chart Report:
  Produces a detailed report that documents a chart, or produces a report that documents all charts.
• 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 Hide / Unhide:
  An interactive way to hide or unhide charts and other objects on a worksheet.

Printing Tools

• 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:
  Makes it easy to copy print setting from one worksheet to other worksheets in the same workbook.
• Add Path to Header or Footer:
  Creates a VBA procedure that prints the workbook's full path in the page header or footer -- something that's normally not possible to do. You can also control the font and size.  Note: This utility is primarily for workbooks that will be used in versions prior to Excel 2002. (Excel 2002 and later supports the file path in headers and footers).

Date & Time Tools

• Perpetual Calendar:
  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. Enhancement: (4) The ability to create a simple appointment calendar that use cell comments to store appointments.
• PUP Date Picker Toolbar:
  Displays a handy toolbar that makes it easy to insert a formatted date into a cell, or change the formatting of an existing date (or a range of dates).
• Reminder Alarm:
  Displays a reminder at a specified time of day, or after a specified period of time has elapsed.

Auditing Tools

• Workbook Summary Report:
  Creates a useful report that summarizes many aspects of a workbook.
• 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.
• Number Format Report:
  Creates a report that lists all number formats used in a worksheet or in a workbook.
• Workbook Link Finder:
  Lets you track down workbook links. More accurate link identification.
• Data Validation Report:
  Creates a report that describes all cells that use Data Validation.
• Conditional Formatting Report:
  Creates a report that describes all cells that use Conditional Formatting
• Worksheet Map: 
  Creates a handy map that visually identifies cells of various types. Includes a new option to code the formula cells by complexity.
• Compare Ranges:
  Lets you easily identify the differences between two worksheets or ranges.
• Name Lister:
  Lets you works with names in ways that are otherwise not possible.
• PUP InfoBox Toolbar:
  Displays a handy toolbar that lists key information about a selected cell or selected range. Long-time users of Excel may find a similarity to the old InfoBox window option. Enhancements: Displays Alignment for a cell selection, and displays the number of unique entries for a range selection. In addition, you can click buttons to select a subset of the selected range (e.g., all formulas that return a value).

VBA & Macro Tools

• 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.
• 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.
• Toggle FaceID Toolbar:
  Displays a toolbar that makes it easy to identify the FaceID property value for toolbar images.

PUP v6 Features

About PUP....

• Includes more than 70 general purpose Excel utilities and 50 worksheet functions.
• Easy-to-use menu system.
• Detailed context-sensitive help .
• Undo is available for most of the operations.
• The ability to create a PUP Toolbar.
• An option to remember the last settings used in PUP dialog boxes.
• An option to display the most recently used PUP dialog box by pressing Ctrl+Shift+R.
• An option to display a graphic progress indicator for lengthy operations.
• An Auto-unload option for improved memory management (user specifies the maximum number of utility files to keep in memory).
• Some of the utilities feature a "stay on top" dialog box, so you can continue working without dismissing the dialog box.
• The VBA code for PUP Worksheet functions can be easily inserted into any workbook (eliminating the need for external links).
• The ability to quickly access the PUP file folder, view all of the PUP  registry settings, and delete all of the registry settings.
• Programmers: 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

New Tools for Excel

Power Utility Pak Version 6 (PUP v6) is a useful collection of add-ins that brings significant new functionality to Excel. 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 v6 augments Excel with about 70 new commands and 50 new worksheet functions. The product is designed to work seamlessly with Excel.

PC Magazine called PUP v5 "The most impressive set of general-purpose utilities for Excel." PUP v6 is even better.

Use the menu on the left to find out more about PUP v6. 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 v6 is designed to work with the following products:

• Microsoft Excel 2000
• Microsoft Excel 2002 (part of MS Office XP)
• Microsoft Excel 2003 (part of MS Office System 2003)

Please note that PUP v6 does not work with any version of Excel for Macintosh.

Using Excel 2007?

• If you use Excel 2007 or Excel 2010, you'll need PUP v7.