Geek Documentation Logo

Repivot

Version 2.1


Introduction


If you have already purchased this Software, let me take a moment to thank you for being a loyal customer
You are entitled to free lifetime updates for ALL future builds

This documentation is to help you understand the Software and to give you a more meaningful insight into what it can do. Please go through the documentation and read it carefully · Moderate VBA skills will be required

Requirements

You will need the following Excel Version & Prerequisite to use this Software

  1. Excel 2010, 2013 & 2016 (32bit or 64bit)
  2. Moderate Excel skills (VBA skills are only required if you need to create an in-built Theme yourself). AddIn requires installing but Themes are easier to build and Styles are instantly applied
  3. Access to the VBOM (a setting in Excel) & Macro's must be enabled
  4. Windows PC · NOT a Mac!

No support is provided for customization or development of this Software






About Repivot #back to top

This Software allows you to pick Fill, Font and Line Colours to instantly create minimalist Pivot Table and Slicer Styles that you can then use in your own Workbooks. It has a lot of different settings in which you can change many elements of the Pivot Table and Slicer UI design. You can choose to Copy the Style(s) to a Blank Workbook or to a Closed Workbook. You can also just Copy the Worksheet into your Project, then delete it - the Styles will be added into your Spreadsheet to use with your Pivot Tables and Slicers. The Repivot AddIn is a fully featured AddIn that does more than the first release of a Workbook driven Repivot, using PNG's loaded via GDI for the Radiobuttons Group - see the AddIn link at the top of the Page!

Use the Pre-defined Fill Colours and Themes to create some really awesome Pivot Table Styles or simply select your own Colours

Repivot Carlsberg Green Image

Repivot Carlsberg Green Image

Getting Started #back to top

The download File - Repivot_v2.zip

Right-click and extract the Zip Archive to your PC. Three Files will be extracted, Repivot_v1.xlsm, Repivot_v2.xlsm and Repivot_v2.xlam

The download File - Repivot 2, Repivot_v2.xlam

Install the 'Repivot.xlam' File. Copy Repivot.xlam. Open Excel. File->Options. Click on Add-ins. Click 'Go...'. Click 'Browse'. Right-click and Paste the AddIn. Select the File and click OK. Click OK again - a Message will be displayed informing you that the AddIn has been installed

Quick Steps

1. Select a Pivot Table and click Design on the Ribbon (contextual Tab for the 'PivotTable Tools')

2. Select a Theme from the Theme Drop-down Combo Box and press the Repivot Button to restyle the Pivot Table

3. Select a Slicer and click Options on the Ribbon (contextual Tab for the 'Slicer Tools')

4. Select a Theme from the Theme Drop-down Combo Box and press the Reslicer Button to restyle the Slicer

The download File - Repivot 1, Repivot_v1.xlsm

Open the 'Repivot_v1.xlsm' File - there are 2 Worksheets you need to worry about, the Style Worksheet contains all of the settings and the Pivot Table Worksheet demonstrates the Styles on Pivot Tables and Slicers for you to test drive. Follow the steps below to create a new Pivot Table and Slicer Style

Quick Steps

1. Select one of the Pre-defined Fill Colours or System Themes and press the Adjust Styles Button

2. Copy the Pivot Table Worksheet into your Workbook and then delete it

3. Use the Pivot Table Styles and Slicer Styles on your own Pivot Tables

Pre-defined Colours #back to top

There are 34 Pre-defined Fill Colours and 7 Header Colours to start you off. Just select one of them in the Drop-down Combo Box in Cell "D6". The settings will update with the new Colours and the Swatch will be rendered with the main Colours used for the Style - the Long, RGB, HSL and HTML Colour Codes will also be shown. Here are the 34 Colour Styles and 7 Header Colours with a Swatch example for the Calypso Fill Colour and Desert Storm Header Colour (Swatches can be recreated if you change any of the main Colours using the Recreate Swatch Button):


Alpine
Bud
Calypso
Carlsberg Green
Catskill White
Celeste
Citrine White
Cream Brulee
Cyprus
Deep Sea Green
Di Serria
Green Pea
Holly
Kangeroo
Kashmir Blue
Lily
Matisse
Maverick
Medium Carmine
Mountain Meadow
Mystic
Nandor
Nebula
Nevada
Ocean Green
Pelorous
Periglacial Blue
Periwinkle Gray
Selective Yellow
Silver Tree
Swans Down
Tawny Port
Wedgewood
Wewak

Alabaster
Cararra
Desert Storm
Desert Storm Dark
Gallery
Porcelain
Wild Sand

                        


Repivot Calypso Swatch

Here is a Pivot Table and Slicer created by the Calypso Colour which has Row Banding on by default (this can be toggled on/off as required). Sometimes, depending on the Colour chosen you will have to tweak the settings to use White for specific elements otherwise the Font will be unreadable (I have done this for the Calypso Colour):

Repivot Calypso Pivot Table & Slicer Style

Click the Defaults Button to reset everything

The AddIn #back to top

Repivot Version 1 has now been deprecated and Version 2 is released as a fully-featured AddIn. The AddIn allows you to create and Save Themes and Styles for both Pivot Tables and Slicers. The benifit of the AddIn is that you can do this as you work, styling and restyling as you want

The Repivot Group on the Contextual PivotTable Tools, Design Tab of the Ribbon

Repivot Tab

The first Button is the button used to Restyle or 'Repivot' your Pivot Table. Then you have a separator bar. Then you have a 'Delete Style' Button which will delete the Style named in the Style Box if it exists. The other Button on this section is the 'Delete Theme' Button which will delete the current Theme in the Theme Box if it exists. The Style Name can be entered into the Style Edit Box - this is adjusted or created when the Repivot Button is pressed. The Theme can be selected in this section using the Drop-down Combo Box or you can Type in a new Theme name and a new Theme will be copied from the Default Theme

After the next separator bar you have the 'Select Colours' Button which is a Drop-down Menu enabling you to change the Colours used throughout each Style. You can change the Font, Line, Fill, Headers and Row / Column Banding. Repivot creates a blend of Colours from the single Fill Colour that you select. Repivot also chooses whether to display the Font given or to use a White Font if the luminance means that the Font would not be display or be readable

Repivot Select Colours

On this Menu, you can also view a Swatch of all of the Colours with Long, RGB, HSL and HTML Codes

Repivot Swatch

After the next separator, you have all of the Checkboxes that allow added settings like, Bold Header, Bold Filter Lables, Bold Grand Totals, Bold Sub Totals, Banded Row Headers and Underline Row Headers. These are saved automatically with the Theme as they are adjusted

Repivot Checkboxes

The Reslicer Group on the Contextual Slicer Tools, Options Tab of the Ribbon

New Radiobuttons Group

The first Button is the button used to Restyle or 'Reslice' your Slicer. Then you have a separator bar. Then you have a 'Delete Style' Button which will delete the Style named in the Style Box if it exists. The Style Name can be entered into the Style Edit Box - this is adjusted or created when the Reslicer Button is pressed. The Theme can be selected in this section using the Drop-down Combo Box - you cannot Type in any new names, they must be created using 'Repivot'

After the next separator bar you have the Radio Buttons which are used to Style the Slicers in terms of how Light and Dark the Colours are ie. Ultra Light, Light, Lighter, Medium, Dark and Ultra Dark. After the next separator, there are three more Checkbox settings, 'Slicer Border', 'Header Colour as Fill' and 'Dark on Light Variation'. Slicer Border will display a Border for the Slicer or remove it. Header Colour as Fill will use the Header Colour for the Theme instead of the Fill Colour. Dark on Light Variation will swap the way that the Hover Compliment Shade is used ie. Dark on Light Variation will show a darker Fill Colour on Hovering over the Slicer Elements instead of a lighter Fill Colour on Hovering over the Slicer Elements. After the last separator, there is an 'Unselected Items Shade' adjustment which allows a tweak to the Shade rendered for Unselected Slicers with or without Data

Themes #back to top

Themes are inbuilt into the Repivot Workbook using VBA and set specific settings including Colours. Select a Theme by clicking into the Cell "N25". I will select the Carlsberg Green Theme. You will notice that everything changes nicely to fit the Theme. Press the Adjust Styles Button to Style the Pivot Tables and Slicers - here is an image of the Carlsberg Green Theme on a Pivot Table and Slicer:

Repivot Carlsberg Green Pivot Table & Slicer Style

Click the Defaults Button to reset everything

Settings #back to top

Here are the Settings available in Repivot:


Pre-defined Fill Colours                            Drop-down Combo Box - the list of Pre-defined Fill Colours by Name used for the main Style                    
Pre-defined Header Colours                          Drop-down Combo Box - the list of Pre-defined Header Colours by Name used for the main Style                   
Fill Colour                                         Colour Dialog Picker - the main Fill Colour
Pivot Table Shade (used for Sub-totals)             Drop-down Combo Box - a value between -12 and 12 used to build the first Shade Colour
Use Bespoke Pivot Table Shade                       Checkbox (double-click) - turns on the Bespoke Pivot Table Shade
Bespoke Pivot Table Shade (used for Sub-totals)     Colour Dialog Picker - choose a bespoke main Pivot Table Shade Colour
Line Colour                                         Colour Dialog Picker - the main Line Colour used for Borders
Font Colour                                         Colour Dialog Picker - the main Font Colour used for all elements
Header and Labels Colour                            Colour Dialog Picker - the main Header & Labels Colour
Bold Grand Totals                                   Checkbox (double-click) - turns on Bold Style for the Grand Totals
Bold Filter Labels                                  Checkbox (double-click) - turns on the Bold Style for the Filter Labels
Table Type (visual)                                 Drop-down Combo Box - 3 Layout options, xlCompact, xlOutline and xlTabular
Banded Rows (visual)                                Checkbox (double-click) - turns on Row Banding for Pivot Tables
Banded Columns (visual)                             Checkbox (double-click) - turns on Column Banding for Pivot Tables
Slicer Border                                       Checkbox (double-click) - turns on Borders for Slicers
Use Bespoke Slicer Selected Items Colour            Checkbox (double-click) - toggles a default Colour or a user-specific Colour
Bespoke Slicer Selected Items Colour                Colour Dialog Picker - choose a bespoke Slicer Selected Items Colour
Use Bespoke Slicer Unselected Items Colour          Checkbox (double-click) - toggles a default Colour or a user-specific Colour
Bespoke Slicer Unselected Items Colour              Colour Dialog Picker - choose a bespoke Slicer Unselected Items Colour                      
Use White Font Colour for Elements                  
- apply a White Font to Grand Total Rows            Checkbox (double-click)
- apply a White Font to Grand Total Columns         Checkbox (double-click)
- apply a White Font to Filter Values               Checkbox (double-click)
- apply a White Font to Sub-total Row 1             Checkbox (double-click)
- apply a White Font to Sub-total Row 2             Checkbox (double-click)
- apply a White Font to Row Banding                 Checkbox (double-click)
- apply a White Font to Column Banding              Checkbox (double-click)
- apply a White Font to Header                      Checkbox (double-click)
- apply a White Font to Slicer Hover                Checkbox (double-click)
- apply a White Font to Slicer Selected Items       Checkbox (double-click)
Sub-heading 1 Line                                  Checkbox (double-click) - apply a thin line to Sub-heading 1
Sub-heading 2 Line                                  Checkbox (double-click) - apply a thin line to Sub-heading 2
Sub-heading 3 Line                                  Checkbox (double-click) - apply a thin line to Sub-heading 3
Sub-heading Line Colour                             Colour Dialog Picker - the Sub-heading Line Colour                             
Use Sub-heading 1 Colour                            Checkbox (double-click) - choose a bespoke Sub-heading 1
Sub-heading 1 Colour                                Colour Dialog Picker - the Sub-heading 1 Colour 
Use Sub-heading 2 Colour                            Checkbox (double-click) - choose a bespoke Sub-heading 2
Sub-heading 2 Colour                                Colour Dialog Picker - the Sub-heading 2 Colour
Use Sub-heading 3 Colour                            Checkbox (double-click) - choose a bespoke Sub-heading 3
Sub-heading 3 Colour                                Colour Dialog Picker - the Sub-heading 3 Colour
Row Banding Colour                                  Colour Dialog Picker - the Row Banding Colour
Column Banding Colour                               Colour Dialog Picker - the Column Banding Colour
Add Bottom Line to Sub-total 1                      Checkbox (double-click) - choose whether to add a Line to Sub-total 1
Add Bottom Line to Sub-total 2                      Checkbox (double-click) - choose whether to add a Line to Sub-total 2
Add Bottom Line to Sub-total 3                      Checkbox (double-click) - choose whether to add a Line to Sub-total 3
Colour Picker Dialog                                Drop-down Combo Box - 2 Dialog options, xlDialogPatterns and xlDialogEditColor                                
Create Style Set                                    Checkbox (double-click) - choose whether to create a Style set when adjusting Styles
- the Name for the new Pivot Table Style set        Input Box - can be over-typed
- the Name for the new Slicer Style set             Input Box - can be over-typed
Pivot Table Style Set Includes                      Checkbox (double-click) - determines which Pivot Table Styles are created
Pivot Table Styles
- All
- Repivot (Alt. Banding)
- Repivot (Alt. Banding1)
- Repivot (Alt. Header1)
- Repivot (Alt. Lighter Banding)
- Repivot (Alt. Sub-totals)
- Repivot (Default)
- Repivot (Default1)
Slicer Style Set Includes                           Checkbox (double-click) - determines which Slicer Styles are created
Slicer Styles
- All
- Reslicer (Alt. Fill Dark)
- Reslicer (Alt. Fill)
- Reslicer (Alt. Highlight)
- Reslicer (Alt. Lighter Fill)
- Reslicer (Default)
- Reslicer (Default1)
- Reslicer (Default2)
Copy Styles to Blank Workbook                       Button - copy all or some Pivot Table and Slicer Styles to a Blank Workbook
Include Colour Swatch                               Checkbox (double-click) - choose whether to include a Colour Swatch       
Save Styles to Closed Workbook                      Button - copy all or some Pivot Table and Slicer Styles to a Closed Workbook
System Themes                                       Drop-down Combo Box - choose from a variety of system Themes
- Google Sheets Blue
- Google Sheets Dark Grey
- Google Sheets Green
- Google Sheets Grey
- Google Sheets Red
- Repivot Carlsberg Green
- Repivot Green
Colour Swatch                                       A Range of small boxes detailing Colour information for the current Style
Recreate Swatch                                     Button - recreates Swatch Colours if any of the main Colour settings are changed

Screen Shots #back to top

Repivot AddIn (Version 2)

Repivot Choosing a Theme Screen Shot

Reslicer AddIn (Version 2.1)

Reslicer Screen Shot

Repivot Stylesheet (Version 1)

Repivot Stylesheet Shot

Repivot Colour Dialog Options (Version 1)

Repivot Colour Dialog Options Shot

Repivot Themes & Swatch (Version 1)

Repivot Themes & Swatch Shot

Fill Colour - Bud, Header Colour - Porcelain

Bud Screen Shot

Fill Colour - Catskill White, Header Colour - Porcelain

Catskill White Screen Shot

Fill Colour - Cream Brulee, Header Colour - Porcelain

Cream Brulee Screen Shot

Fill Colour - Cyprus, Header Colour - Desert Storm

Cyprus Screen Shot

Fill Colour - Kashmir Blue, Header Colour - Carrara

Kashmir Blue Screen Shot

Fill Colour - Nandor, Header Colour - Carrara

Nandor Blue Screen Shot

Fill Colour - Google Blue, Header Colour - Porcelain

Google Blue Screen Shot

Videos #back to top

Repivot - Copying the Styles

This is a demo of Selecting the Carlsberg Green Theme and Copying the Style into a Blank Workbook with the Colour Swatch used for the main Theme Colours



This is a demo of Selecting the Carlsberg Green Theme and Copying the Style into a Closed Workbook



How can I apply an Excel Theme Colour to the settings?

Choose the 'xlDialogPatterns' option from the Drop-down Combo Box for the Colour Picker Dialog. Then you can pick a Colour Theme

Colour Dialog xlDialogPatterns Screen Shot


How do I copy a Style into my own Spreadsheet?

You have a few options. You can use the 'Copy Styles to Blank Workbook' Button to copy 1 or more of the Styles into a Blank Workbook with the option of copying the Swatch Colours as well. You can use the 'Copy Styles to Closed Workbook' Button to copy 1 or more of the Styles into a Closed Workbook where you simply select your Excel File and the Code will do the rest. Lastly you can simply Copy the 'Pivot Table' Worksheet directly into your own Workbook and then immediately delete it - the Styles will persist and then you can use them in your own Workbook



Support #back to top

Please remember you have purchased very affordable Software and you have not paid for a full-time Software design agency - I am but one man. Occasionally I may help with small tweaks, but these requests will be put on a much lower priority due to their nature. You have not PAID for Support, Support is 100% optional and I provide it for your convenience, so please be patient, polite and respectful

Support (limited) for my Software includes:

* Responding to questions or problems regarding the Software and its features
* Fixing valid (replicated) bugs and reported issues for the VERSION I HAVE WRITTEN

Software support does not include:

* Customization and installation services
* Support for third party software or ANY kind of development whatsoever

Before seeking support, please...

* Make sure your question is a valid Software Issue and not a customization request
* Make sure you have read through the documentation and any related video guides before asking support on how to accomplish a task
* Make sure to double check the Software FAQs or online documentation
* Ensure that you access to the VBOM is allowed and that Macros can run in Excel
* Make sure to provide 'proof of purchase' and state the name / version of the Software that you are having issues with when requesting support by Email or via Facebook

How to get Support

Contact Mark Kubiszyn on the Email address provided when you purchased the Software, including the Order Number
Contact Kubiszyn.co.uk via our Facebook Page - remember to be patient, if there has been an issue with your download, I will always respond within 48 hours and will Email you the File directly if neccessary or via Messanger. For other issues the response time may be considerably longer and I may choose to respond to specific questions only (as is my right), depending on what has been asked

Version History (Changelog) #back to top

You can find the version history in the Code Module for any Macro-enabled Software or read more information below. The latest Version is always shown first


Changelog

28.04.2019 - (Version 2.1) released with Radiobuttons using PNG images and GDI

---

26.04.2019 - (Version 2) released as an AddIn (Version 1 is now deprecated, however it will still ship with the Download when purchasing Repivot)

---

20.04.2018 - (Version 1) released