Pivot Software is a software program developed by Portrait Displays. The most common release is 9.03.003, with over 98% of all installations currently using this version. During setup, the program creates a startup registration point in Windows in order to automatically start when any user boots the PC. The primary executable is named wpctrl.exe. The setup package generally installs about 15 files and is usually about 4.31 MB (4,523,086 bytes). Relative to the overall usage of users who have this installed on their PCs, most are running Windows 7 (SP1) and Windows 10. While about 38% of users of Pivot Software come from the United States, it is also popular in United Kingdom and Germany.
Pivot Animator 4.2.6 Now available. The latest stable version of Pivot, which adds several keyboard shortcuts for the figure builder window and the ability to load multiple sprites. See the readme.txt file for a full list of changes.
Program details. Or, you can uninstall Pivot Software from your computer by using the Add/Remove Program feature in the Window's Control Panel. On the Start menu (for Windows 8, right-click the screen's bottom-left corner), click Control Panel, and then, under Programs, do one of the following:.
Windows Vista/7/8: Click Uninstall a Program. Windows XP: Click Add or Remove Programs. When you find the program Pivot Software, click it, and then do one of the following:. Windows Vista/7/8: Click Uninstall. Windows XP: Click the Remove or Change/Remove tab (to the right of the program). Follow the prompts. A progress bar shows you how long it will take to remove Pivot Software.
There is no doubt that pivot tables are incredibly powerful, and save us a lot of time when summarizing data. However, we also spend a lot of time doing repetitive tasks with pivot tables. Do you spend extra time doing any of the following?. Searching for fields in the field list.
Formatting numbers. Working with source data. Changing layout settings These small tasks can be very time consuming and frustrating!
Do You Spend Extra Time Building Pivot Tables? If you use pivot tables frequently then you could be wasting a lot of time with some of these boring repetitive tasks, which takes time away from the fun stuff. If you have pivot tables with more than 20-30 fields, then just scrolling through the field list to find the field you're looking for can take a lot of time. And if you don't know the name of the field you are looking for, then you probably do something like the following:.
Find the sheet that contains the source data. Scroll horizontally through the columns until you find the field. Go back to the sheet that contains the pivot table.
Find the field name in the field list. Add it to the pivot table. REPEAT for all the fields you want to add. This process alone can be very time consuming. How Can We Make This Faster? My name is Jon, and I have been using Excel all day everyday for over 10 years.
I love Excel! ? And, I have probably built thousands of pivot tables. I use pivot tables for everything from a quick list of unique values, to reconciling accounts, to creating sophisticated interactive dashboards. They have a seemingly infinite number of uses, and they are just awesome! When you start using pivot tables frequently, you begin to realize that some of Excel's built-in tools could be a little more efficient. There are certain tasks that just take way too much time with the built-in field list and various options menus. Fortunately, VBA (the language used to write macros) allows us to program pivot tables to help automate some of these tasks.
Over the years I have written a lot of macros that perform specific tasks to modify or update a pivot table. However, I wanted to bring these automation routines into an application that everyone could use. This is where the PivotPal add-in was born. PivotPal started as a simple form with a search box where you could quickly find a field in the field list, then add it to one of the areas in the pivot using keyboard shortcuts. That feature alone saved me a ton of time. But the features quickly grew from there I also wanted a way to quickly format numbers, instead of having to navigate through four menus just to change a number format.
I also wanted the ability to work on the pivot table from the source data sheet. Why should we have to constantly jump back and forth between two sheets that might not be located next to each other in the workbook?
The list goes on, and I spent over a year adding features to enhance PivotPal. PivotPal Saves You Time The goal of PivotPal is to save you a ton of time when working with your pivot tables. The add-in is packed features that make things faster and easier. Let's take a look at some of the features. Quickly Find Fields & Add Them to the Pivot PivotPal contains a search box that allows you to quickly find fields in the field list. It works similar to a Google search, and the results are narrowed down as you type.
Once you find the field, you can use keyboard shortcuts or the mouse to add the field to any of the areas in the pivot table. You will never have to spend time scrolling through the field list again. You can also select multiple fields in the list to quickly add or remove fields, and even change number formatting. Number Formatting Made Easy When formatting a number in the values area you typically have to step through 4 menus just to change a number format. There is no doubt that this takes extra time.
PivotPal contains a few features that relieve a lot of pain with this process. First, PivotPal automatically applies number formatting.
When you add a field to the values area with PivotPal, the number formatting for the field in the source data is detected and automatically applied to the pivot table. This means you have to take zero steps to format the field. It's automatically done for you!
If you the source data is not formatted, or you want to change the formatting of the field, you can do so in one step by selecting from the list of formats in the Formats drop-down menu on the PivotPal window. This list of number formats can be easily customized using the My Number Formats tool that is included with PivotPal.
The My Number Formats tool also allows you to apply your favorite number formats to any cell in the workbook. It is not limited to pivot tables. If you are constantly adding custom number formats like ($1.0M) to your workbooks, then this tool will allow you to do that in one click. New Feature: Automatic Number Formatting I've added a new feature that automatically formats the numbers in the Values area of the pivot table when using the built-in Pivot Table Fields List. The Automatic Number Formatting feature detects the number formatting that is used in the source data range, and automatically applies it to the pivot table when a field is added to the values area. If the source data is not formatted, or does not exist in the workbook, then a default number format that you specify is applied to the pivot table.
Either way, you will never have ugly looking pivot tables with the General number format. Working With Your Source Data When building pivot tables it is only natural to spend a lot of time working with the source data. This includes tasks like:. Finding fields. Investigating blanks and errors.
Converting data types (dates, numbers, text). Writing formulas. Changing the data source range. Drilling down on the details of a number in the pivot The built-in menus don't allow you to work with source data while building the pivot table. Unless your pivot table is on the same sheet as the source data, you spend a lot of time flipping back and forth between the pivot sheet and source data sheet. PivotPal solves some of these problems with a few great features.
Build Pivots from the Source Data Sheet Often times you will know what field you want to add to a pivot table, but you don't know the name of the field. This is especially true when you are working with data that is exported from a database system. The field names aren't always descriptive. Let's say you want to add the field that contains the product groupings, but you don't know the name of the field. With PivotPal you would simply press the GoTo Data button on the PivotPal window. This will take you to the source data sheet, and the PivotPal window will remain open. You can then browse through your sheet or use Excel's Find menu to find the field.
Selecting any cell in the column of the field will automatically select that field in the PivotPal window. Now all you have to do is press one of the Area buttons on the PivotPal window to add the field to your pivot table.
It's that easy! Press the GoTo Pivot button to return back to your pivot table and view the results. Filtering Your Source Data When you double-click on a cell in the values area of the pivot (right-click Show Details), Excel adds a new sheet to your workbook that contains the rows of data that make up that slice (intersection) of the pivot. I call these drill-down sheets.
This can be handy information if you are trying to investigate a number, but your workbook can quickly become cluttered with drill-down sheets. The other problem is that the drill-down sheet is not formatted, and usually difficult to read. PivotPal has a Filter Source button that will show the exact same results by applying filters to your source data sheet.
This means you can investigate the actual source data, instead of a drill-down sheet. If you need to make changes to the data, then it is already filtered for the rows you want to see. And, your workbook will NOT become cluttered with drill-down pages. This feature has a lot of great benefits, and you will find yourself using it all the time. Layout Settings Done Your Way Did you know that there are over 30 different layout and options settings for pivot tables? We spend a lot of time changing these settings for each pivot table we create.
Often times we are applying the same settings over-and-over again. Do you find yourself doing a process similar to this: 1. Change layout to Tabular format 2. Turn Subtotals off 3.
Display zeros for Blanks 4. Insert blank line after item Everyone has their own preferences, but applying these settings can take extra steps.
PivotPal has a feature called My Pivot Layouts that allows you to create profiles with your favorite settings, then quickly apply them to any pivot table with the click of a button. Just selecting the layout profile you want to apply, and all the settings will be automatically adjusted for you. It will save you a ton of time! Additional Features PivotPal is packed with features to help you get your job done faster.
Source Range Warning – Have you ever forgotten to update the data source range after adding new data? I have, and it can be an embarrassing mistake. PivotPal will warn you when there are more rows in your source data then what is currently set as the source range in your pivot table. In other words, it will save your butt from embarrassing mistakes.
?. Apply Number Formats to Any Workbook – Your workbook does not have to contain pivot tables to use the My Number Formats tool.
You can apply your custom number formats to cells in any workbook. Jump to any Pivot Table – There is a drop-down menu at the top of the PivotPal window that contains a list of all the pivot tables in the workbook. It also tells you what sheet the pivot table is on. This makes it easy to jump to the other pivot tables using the GoTo Pivot button. You can also quickly check to see which fields are used on other pivot tables by just selecting from the list. The field list will be loaded for the selected pivot table. Pivot Info List – The button to the right of the Pivot Drop-down opens a window that contains a list of all the pivot tables in the workbook.
This list contains additional details about the pivot table including the pivot cache index number, source range, source type, and total pivot cache count. This feature will be enhanced in the future to include a lot more. Works with PowerPivot – PivotPal will work with your PowerPivot models too.
This saves a lot of time when searching for fields in many different tables. Function and Calculation Types – PivotPal contains two drop-down menus for the function (sum, count, average) and calculation types (% of totals, rank, etc.). This allows you to quickly change the calculation type of the value field(s) you have selected in the list. Yes, you can apply these settings to multiple fields at the same time. When selecting a calculation type, the name of the field is automatically changed to describe the calculation. Instead of “Sum of Revenue2”, the field will be named “Revenue% of Total”.
This is something that Excel does NOT do. Change How You Work With Pivot Tables PivotPal will help increase your productivity, and alleviate some of the frustrations you face when working with pivot tables. PivotPal is meant to compliment the built-in menus in Excel. It won't completely replace these menus, but instead it provides a quicker solution for some of the tasks we do the most. This time savings will allow you to spend more time on creative and analytic (fun) part of your job. Spending time on this type of work will make a bigger impact for your organization and your career.
What Others Are Saying About PivotPal. PivotPal is a great tool! It saves me a ton of time when working on unfamiliar data when I am creating a Pivot Table by allowing me to construct the Pivot while looking at the source data. That is an extremely helpful feature. Between constructing Pivot Tables while looking at the source data and being able to add more than one item at a time to a Pivot Table field saves me quite a bit of time. Another great feature is being able to instantly filter the source data to match what is currently filtered in the Pivot Table takes away the hassle of drill down sheets and deleting drill down sheets when I am finished analyzing the data.
I really appreciate having been able to review the PivotPal ahead of its launch and its had a serious workout already on a Dashboard I’ve created for my company’s global use. Using the PivotPal has been quite a ‘light bulb moment’ in that it has helped to really cement my understanding of how Pivots in MS Excel work – quite apart from making Pivot Tables much easier and faster to set up, especially for multiple tables, it’s also helped me understand much better MS Excel’s high level Pivot Table workflow. As well as being feature rich PivotPal also uses the valuable screen and workspace real estate much more efficiently than Excel’s native Pivot management which has been a real benefit whilst developing my spreadsheet Dashboard in meeting rooms and on my sofa using just my laptop without the luxury of twin monitors back at my desk. I work for a leading automotive manufacturer with a global manufacturing and design footprint and your tool has been key in developing a new dashboard we’ve just agreed to at our most senior level to use globally as was one of our new key metrics in our Product Development teams.
So it was very timely to have an easy to manage and understand PivotPal tool to help! David W Here's Exactly What You Get With PivotPal PivotPal is an Excel Add-in that is compatible with Excel 2007, 2010, 2013 and 2016 for Windows. PivotPal Standard Version The Standard Version comes with all the great time saving features that will help you work faster with your pivot tables. Search the Pivot Table Field List.
Automatic Number Formatting. Filter the Source Data. Auto Select Fields on Cell Selection. Warning when New Data Added to Source. Works with PowerPivot & OLAP pivot tables.
My Number Formats Tool. My Pivot Layouts Tool. Lifetime Support & Upgrades. Free Bonus #1 – PowerQuery & Pivot Tables Video PivotPal Developer Version With the Developer Version you get access to the VBA Source Code that makes PivotPal run.
This is great if you are learning VBA and interested in developing add-ins or applications. Search the Pivot Table Field List. Automatic Number Formatting. Filter the Source Data. Auto Select Fields on Cell Selection.
Warning when New Data Added to Source. Works with PowerPivot & OLAP pivot tables. My Number Formats Tool.
My Pivot Layouts Tool. Lifetime Support & Upgrades. Get the VBA Source Code. Free Bonus #1 – PowerQuery & Pivot Tables Video. Free Bonus #2 – PivotPal VBA Video.Licensing: This purchase is for 1 user license for the PivotPal add-in. You may install it on up to three computers that you own.
Please do not distribute or share the files.Note: PivotPal does not work on the Mac versions of Excel. Free Bonus Videos I am including some great bonus videos with PivotPal that will help you learn more about pivot tables, pivot charts, my new favorite tool PowerQuery, and the VBA code that runs PivotPal. Bonus #1 – PowerQuery and Pivot Tables Video Series In this three part series I explain how to create this dashboard of snowfall data. You will learn how to use PowerQuery to unpivot or normalize the data we download from the web.
I copy some snowfall data from the website of my favorite ski resort, and it needs to be unpivoted (re-shaped) to be in the correct structure to use for a pivot table. This is also referred to as normalizing the data. PowerQuery is a free add-in from Microsoft for Excel 2010 and 2013. It is an awesome tool and one of my new favorites. PowerQuery will save you a ton of time when re-shaping or manipulating data.
Ever use the Text-to-Columns feature in Excel? This is similar to that only a million times better. ? And don't worry if you don't have PowerQuery yet. I also provide instructions on how to download and install it. Bonus #2 – Learn How PivotPal Works and the VBA Code That Makes it Run This video explains how PivotPal works and we dive into VB Editor to look at the forms and code that make up the add-in. This will be helpful if you are new to VBA or add-ins and want to understand how they work.
The bonus includes access to a special page that contains the video, and also contains a section where you can ask questions. Note: This bonus is only available if you buy the Developer Version of PivotPal. Frequently Asked Questions. Can I install PivotPal on multiple computers? You can install PivotPal on up to three computers that you own. You cannot share or distribute the files. What payment options do you accept?
I accept PayPal and all major credit cards. Click the buy now button above to be taken to a secure checkout page. How do I get PivotPal once I make a purchase? You will be able to download PivotPal immediately after purchase. You will also receive an email with the download link and purchase receipt.
PivotPal has a lot of features, how do I learn all of them? There is a dedicated for PivotPal that contains video tutorials and guides to help you learn the features.
I want to get reimbursed by my employer. Can I get a receipt for the purchase? Absolutely, a formal pdf receipt will be emailed to you immediately after purchase. What version of Excel do I need? PivotPal is an Excel add-in that works with Excel 2007, 2010, 2013, and 2016 for Windows (both 32-bit or 64-bit). Will PivotPal be updated, and do I get these updates?
I will continue to add features to PivotPal as you request them. I already have a list of features I want to add, and look forward to getting feedback from you to help make PivotPal better. Can I undo the changes I make to my pivot tables? As with all macros, the undo history is lost when a macro makes changes to the workbook. This is one drawback to automating Excel. However, I am working on a feature that will allow you to view your pivot table history, and undo changes.
I recommend saving your file before making any major changes to your pivot tables. What if it doesn't work for me? PivotPal is guaranteed to work.
If you are unsatisfied for any reason you can get a full refund within 90 days of purchase. Plus, I am always happy to answer your questions and help you any way I can. What is an Excel add-in? An Excel add-in is an Excel file that contains VBA code (macros & forms). You install the file one time, and then it will open automatically every time you open Excel. Once PivotPal is installed, the XL Campus tab will appear in the Ribbon.
This tab contains the PivotPal buttons to open the various windows. Try PivotPal Risk-Free I want you to love PivotPal! If you are not completely satisfied for any reason, I will give you a full refund within 90 days of purchase. And yes, you still get to keep the add-in file.
So you could get a refund and keep all these products for free. I’m hoping you don’t do this, and I probably shouldn’t even mention it, but I’m willing to take this risk in hopes that PivotPal will really help you. So try PivotPal for 90 days. Support Is Only A Click Away I am here to help you with any questions. You can contact me directly if you need any helping using PivotPal.
You will also receive installation instructions and there is an online help page with videos that will explain all of the PivotPal features in more detail. PivotPal is very easy to use and it will work for you! Jon Acampora [email protected] PS – If you are going to spend any time searching for a field in the field list, or applying pivot table layout options today, then PivotPal wants to give you a hand. ?. Hi Jon, The pivot pal is allowed to install up to 3 computers. I have 1 personal laptop, 1 company computer & 1 Laptop and 1 tablet. I would like to assign 2 add in license to my personal laptop and tablet. 1 license share between with company computer and laptop.
In this case, can I install at company computer and un-install from company computer and reinstall the add in to company laptop when nessacery. Can I withdraw this license to re-install to new company computer/laptop? Please advice. I am considering to purchase pivot pal + VBA if the add-in is flexible when I change company/laptop for company usage and personal usage. Hi Anirudh, Thanks for your question. PivotPal does NOT need to be installed on the computer.
It is delivered as an.xlam Add-in file that you install through the Add-ins Manager within Excel. I do NOT package my add-ins with installers for this reason. A lot of companies do not allow you to install programs. So, the add-in file is just saved to a folder on your computer and then installed through Excel. Here is a page with so you can see the process. Please let me know if you have any questions.
Hi, Jon, Wow, I’ve not used a pivot table yet but feel that I need one! I just joined as a volunteer at Veterans Support Group, Inc.(501-c-3) charitable organization. They are using Excel and so far have entered a great amount of information and records. Can I install your Pivot Pal on top of Excel and have it work beautifully? I work at their office and also bring home work.
I have Excel 2016 and they have Office 365 with Excel. Will I have a problem if I use your program on these two different Excel programs?
If this will work out the way I wish, I’d order your big package tomorrow. BTW your videos are great.
You’re an excellent teacher. Sincerely, Chuck Sotis. Hey Jon, refreshing a pivot table is relatively easy, of course, with Shift-F10/Refresh.
But to improve productivity I try to eliminate clicks, or even keyboard shortcuts as much as possible. I have set my Excel files containing pivot tables to refresh on opening. In addition, I use a macro to refresh after saving the file so I see results after adding new data before closing the file. Option Explicit Private Sub WorkbookBeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Me.RefreshAll End Sub I have added this macro to each file with pivot tables, but a more “elegant” solution would be to have a “central” macro, so each file does not have to be saved as an.xlsm file. I have added the code above to the PERSONAL.XLSB in a module in the Modules folder. But it does not work. Should I put the code in the ThisWorkbook instead?
If so, how do I handle it with some other code that is already there? Or would an add-in be more appropriate? I have looked how to create an add-in but somehow I can’t get it to work. Maybe you can point me in the right direction. And maybe you find it useful to add this to your PivotPal add-in?