OOXML Hacking: Vertical Bullet Alignment

Bad design decisions haunt our lives. One poor choice was Microsoft’s selection of the text baseline for vertical bullet alignment in PowerPoint. Bigger bullets move up, smaller bullets move down, without any control in the user interface. I’m sure you’ve seen this effect as you change bullet size relative to text:

Bad Vertical Bullet Alignment


Fixing Vertical Bullet Alignment with VBA

There are a couple of ways to fix this issue. One is to download and install this free Add-in by John Wilson of PowerPoint Alchemy: Bullets Move Up and Down. The VBA code behind this add-in looks something like this:

Sub fixBulletAlignment()
  Dim oDes As Design
  Dim oMast As Master
  Dim L As Long
  Dim oCust As CustomLayout
  Dim oshp As Shape
  For Each oDes In ActivePresentation.Designs
    For Each oCust In oDes.SlideMaster.CustomLayouts
      For Each oshp In oCust.Shapes
        If oshp.Type = msoPlaceholder Then
          Select Case oshp.PlaceholderFormat.Type
          Case Is = ppPlaceholderBody, ppPlaceholderVerticalBody, ppPlaceholderObject
            For L = 1 To oshp.TextFrame.TextRange.Paragraphs.Count
              With oshp.TextFrame.TextRange.Paragraphs(L).ParagraphFormat
                .BaseLineAlignment = ppBaselineAlignCenter
              End With
            Next L
          End Select
        End If
      Next oshp
    Next oCust
  Next oDes
  MsgBox "Masters and layouts fixed", vbInformation, "PowerPoint Alchemy"
End Sub

When this runs, it adds an over-ride to the text level definitions on each slide layout that has multi-level text (any layout containing a Content or Text placeholder).

<a:lstStyle>
  <a:lvl1pPr fontAlgn="ctr">
    <a:defRPr/>
  </a:lvl1pPr>
  <a:lvl2pPr fontAlgn="ctr">
    <a:defRPr/>
  </a:lvl2pPr>
  <a:lvl3pPr fontAlgn="ctr">
    <a:defRPr/>
  </a:lvl3pPr>
  <a:lvl4pPr fontAlgn="ctr">
    <a:defRPr/>
  </a:lvl4pPr>
  <a:lvl5pPr fontAlgn="ctr">
    <a:defRPr/>
  </a:lvl5pPr>
</a:lstStyle>

This is adequate for most purposes. With correctly aligned bullets, we now get this effect when we change the bullet size:

Good Vertical Bullet Alignment

There are a couple of downsides to the VBA approach:

  • You have to remember to apply it to each presentation or template.
  • If you add a new layout, or add a new text or content placeholder to an existing layout, you’ll have to re-run the macro.
  • Table text and text box text does not benefit, their bullets will still be wonky.

Fixing Vertical Bullet Alignment with XML Hacking

With XML hacking, we can fix this problem once and never have to think about it again. Start by unzipping a new blank template, then editing ppt\slideMasters\slideMaster1.xml. There are 3 sections to be edited: p:titleStyle (for all title placeholders), p:bodyStyle (for all text or content placeholders) and p:otherStyle (for table text).

The editing is the same for all sections: for each a:lvlXpPr section, where X is the level number, add fontAlgn=”ctr” to the definition. Here’s what it looks like before…

<a:lvl1pPr marL="0" indent="0" algn="l" defTabSz="914400" rtl="0" eaLnBrk="1" latinLnBrk="0" hangingPunct="1">

…and after editing:

<a:lvl1pPr fontAlgn="ctr" marL="0" indent="0" algn="l" defTabSz="914400" rtl="0" eaLnBrk="1" latinLnBrk="0" hangingPunct="1">

There are 19 level definitions in slideMaster1.xml to change. When you’re done that, open ppt\presentation.xml and make the same edit to the 9 levels of the p:defaultTextStyle section that controls formatting for text boxes and notes and handout pages.

When you’re done, rezip the XML files and rename the template blank.potx. Place it so it works as your default template, here’s an article from Steve Rindsberg with the details for each Office version. For PowerPoint 2016 and 2019 for Windows, follow the PowerPoint 2013 directions. For 2019 for Mac, use the Mac 2016 directions: Create your own default presentation.

Now that this is set in your default template, every new file created when PowerPoint opens will have the correct vertical bullet alignment. Please note that in PowerPoint for Windows, if you choose File>New>Blank Presentation, this autogenerates a new file that is not based on your default template. Such a file will have incorrect vertical bullet alignment.

Shared Workgroup Templates – Best Practices

Groups of workers usually use the same templates. But it can be time-consuming to keep everyone updated when templates are installed separately on each desktop. Instead, you can implement shared workgroup templates with a feature already built into Office.


Shared Workgroup Templates – Multiple Uses

Every desktop version of Office, Mac and Windows, includes a Workgroup templates option that allows you to set a network share as a templates folder. Templates on this share are instantly available to all users, making updates and revisions a breeze. Automatically, everyone in the office is using the same version. As long as template names remain identical, then old Word documents automatically attach themselves to the new template.

While you can only set the Workgroup Templates location in Word, once you make the change there, it also applies to PowerPoint and Excel.

The Workgroup templates network share can serve more that just templates. With some additional subfolders, it can be a source for Document Themes, including custom SuperThemes, it can hold collection of Font and Color themes. These additional files don’t show in the File>New dialog. Theme files display under the Themes dropdown, theme colors under the Colors dropdown and theme fonts under the Fonts dropdown.


Shared Workgroup Templates – Setup

To set up shared workgroup templates, first create the network location and ensure it’s accessible to all in the office without a signin. Each computer should connect to the share automatically on restart, so users don’t have to remember to manually connect before creating a new document. Create subfolders with the following names for othe file types you want to support. Document Themes for themes, with subfolders for Theme Colors and Theme Fonts. All versions of Office expect exactly the same file structure.

If the office uses Group Policies to install and configure software, you can use that feature to add the Workgroup Template location to each user installation. If you’re using “sneakernet” for configuration, here’s how to do it manually. All Office suites use a setting in Word to set the location for all the other programs

Office 2010, 2013, 2016 and 2019 for Windows

  1. In Word, choose File>Options>Advanced.
  2. Scroll down to the General section of Advanced and click on the File Locations… button.
  3. Select the Workgroup templates line, then click on the Modify button.
  4. In the dialog that opens, enter the path to the network share in the Folder name field, or use the window controls to navigate to the folder. Select the folder and click on OK. OK all the way out and close Word

Office 2007 for Windows

  1. In Word, click on the Office button, then on Word Options, then on Advanced..
  2. Scroll down to the General section of Advanced and click on the File Locations… button.
  3. Select the Workgroup templates line, then click on the Modify button.
  4. In the dialog that opens, enter the path to the network share in the Folder name field, or use the window controls to navigate to the folder. Select the folder and click on OK. OK all the way out and close Word.

Office 2003 and earlier for Windows

  1. In Word, choose Tools>Options and click on the File Locations tab.
  2. Select the Workgroup templates line, then click on the Modify button.
  3. In the dialog that opens, enter the path to the network share in the Folder name field, or use the window controls to navigate to the folder. Select the folder and click on OK. OK all the way out and close Word.

Office 2016 and 2019 for Mac

  1. In Word, choose Word>Preferences>File Locations.
  2. Select the Workgroup templates line, then click on the Modify button.
  3. In the dialog that opens, use the window controls to navigate to the folder. Select the folder and click on Open. OK out and close Word

Office 2011 and earlier for Mac

  1. In Word, choose Word>Preferences>File Locations.
  2. Select the Workgroup templates line, then click on the Modify button.
  3. In the dialog that opens, use the window controls to navigate to the folder. Select the folder and click on Choose. OK out and close Word

Shared Workgroup Templates in Use

Here’s how to access Workgroup templates in Office programs

Office 2016 and 2019 for Windows

  1. Choose File>New.
  2. Click on Custom.
  3. Click on Workgroup Templates, select a template, then click on Create.

Office 2013 for Windows

  1. Choose FILE>New.
  2. Click on SHARED.
  3. Click on a template.

Office 2010 for Windows

  1. Choose File>New>My Templates.
  2. On the Personal Templates tab, select a template, then click on OK. This tab also shows local templates on the user’s computer.

Office 2007 for Windows

  1. Click on the Office button, then on New.
  2. Click on My templates…
  3. Select the My Templates tab. Workgroup templates are displayed along with local templates in the same pane.

Office 2003 and earlier for Windows

  1. Click on File>New. The New Document pane opens at the side of the window.
  2. On the New Document pane, click on On my computer…
  3. Select a template from the General pane and click on OK. This pane shows a mix of local and workgroup templates.

Office 2016 and 2019 for Mac

  1. Choose File>New from Template…. The Document Gallery opens
  2. In the upper left corner, click on the Work link. This link only appears when you have a Workgroup Templates location set in Preferences.
  3. Select a template, then click on Create.

Office 2011 for Mac

  1. Choose File>New from Template. The Document Gallery opens.
  2. Click on Workgroup Templates in the left-hand TEMPLATES list..
  3. Select a template and click on Choose.

Office 2008 for Mac

  1. Choose File>Project Gallery. The Project Gallery opens.
  2. Click on My Templates in the left-hand Category list..
  3. Select a template and click on Open. This window will show a mix of Workgroup and local templates.

Shared Workgroup Templates – Shortcomings

In addition to templates and themes, a local templates folder also serves custom Chart and SmartArt templates. Neither of these formats is supported by Workgroup Templates, so those templates must still be installed locally on each user’s computer.

OOXML Hacking: Layout Color Variations for Visual Interest

Having worked with many great designers, I see that they try to create variety in chart appearance rather than uniformity. So what if there was a way to have make a chart layout with the colors in a different order? This could give you layout color variations while sticking to the branding guidelines. Well, I have a solution for you, but you’re gonna have to hack some XML!

If you’re an XML newby, please read my article XML Hacking: An Introduction. macOS users will live longer lives if they take a look at XML Hacking: Editing in macOS.

Normally, every layout under a slide master has only 1 color theme. You’re mostly stuck with those 10 colors in a fixed order. In my earlier article about Great Color Themes, I explained how the sequence of colors determines the color order of charts.

But during some recent research, I started reading about the <p:clrMapOvr> XML element. This can be applied to a slide layout to rearrange the color theme. With Accents 1 to 6 in a different order, charts can acquire a whole new look. Here’s how it works.


Layout Color Variations with clrMapOvr

Before Layout Color Variations

At the end of most layouts, you may have seen this XML:

  <p:clrMapOvr>
    <a:masterClrMapping/>
  </p:clrMapOvr>

This tells the layout that it should use the standard color mapping as defined in the theme. We would think of this as the default or normal set of colors. But what if we want to alter this sequence? We can assign each color theme value to a different task. If you import a PowerPoint 2003 or older deck, this gets generated automatically to keep the deck looking as expected.

Here’s an alternate mapping of the same colors:

  <p:clrMapOvr>
    <a:overrideClrMapping bg1="lt1" tx1="dk1" bg2="lt2" tx2="dk2" accent1="accent6" accent2="accent5" accent3="accent4" accent4="accent3" accent5="accent2" accent6="accent1" hlink="hlink" folHlink="folHlink"/>
  </p:clrMapOvr>

This reverses the order of accent colors from the master, giving charts, fills and shapes a whole new look for the slides based on this layout.

After Layout Color Variations

We used to tell clients “Sorry, we have to set the color order to match only one of your designed charts.” Now we have a different message: “Different chart color sequences? No problem. Just use a different layout!”

If XML hacking doesn’t interest you, Brandwares can do it for you. We’re a full-service template creation service for all Office programs. Email me at production@brandwares.com with your project details.

Legacy Slides – Best Practices


Legacy Slides – Making It Work the Way You Think It Should Work

Here’s an all-too-common scenario. An organization has a library of presentations built up over the years, full of valuable content. Time passes and a branding update becomes inevitable, to keep the corporate look contemporary. A designer is hired, a new template created and distributed. Users create new decks and start pasting in old slides. Chaos ensues: the formatting is all f***ed up! It could be something minor, like regular text changing to bold. But much more often, old formatting gets pasted in, and in Slide Master view you start seeing unwanted layouts, often with names preceded by numbers like 1_Title and Content. What went wrong?

PowerPoint has several requirements for pasting to work as expected. When you paste in old slides, and you want them to map to your new slide layouts, they must meet all 5 of these criteria:

  1. The slide layout name must be the same. This can be set in Slide Master view.
  2. The slide layout type (as set in XML) must be the same. If you copy an existing Title Slide layout, it will retain the layout type. But if you delete all Title Slide layouts, then realize you made a mistake, you’re in trouble. It’s possible to recreate a built-in slide layout by running a VBA macro:
    Sub RestoreLayout()
      With ActivePresentation.Slides
        .Add(.Count + 1, ppLayoutObject).Delete
      End With
    End Sub

  3. The number of placeholders must be the same. When there is a different number of placeholders on the slide being pasted, PowerPoint goes mental and will reassign content randomly.
  4. The types of placeholders must be the same. If a user is pasting a Microsoft-compatible Title and Content slide, PowerPoint is looking for:
    1 Title,
    1 Content,
    1 Date,
    1 Footer and
    1 Page Number placeholder. No more, no less. If your old template layout has only a Title and Content placeholder, your new template must have the same.
  5. For corresponding placeholders in the old and new layouts, the idx number must match. Title placeholders don’t have idx numbers, because there is only one of them on a slide at a time. The idx numbers tell PowerPoint which placeholder should receive information from a particular placeholder in the old layout. This allows you to have several of the same type of placeholder on a layout and still have PowerPoint map content correctly among them.

This simplest way to guarantee that all these criteria will be met is to not create a template from a brand new file. Instead, reformat the old template to the new branding, taking care not to delete or rename any layouts (you can add new ones), and not to add or delete any placeholders on the existing layouts.


Legacy Slides – Another Possible Hiccup

An additional wrinkle can appear if an embedded image is included, perhaps for a logo. Then the XML will include a line line this:

<a:blip r:embed="rId2">

rId numbers are used by the _rels file that corresponds with the layout to tell PowerPoint where to find the logo. If the rId number is wrong, PowerPoint will show an empty box with the text The picture could not be displayed. Of course, you could just replace the image if you see this error during file construction.

Static pictures, graphics, text boxes and shapes placed on the layout make no difference to layout mapping. Add them, remove them, they won’t stop PowerPoint finding the correct layout.

If a pasted slide does not meet all of the above criteria, PowerPoint imports the slide layout from the old deck, prepending it’s name with 1_, if it’s the first time it’s importing that layout. Very quickly, the client’s deck is polluted with multiple spurious slide layouts. When face with choices like Title and Content, 1_Title and Content, 2_Title and Content, 3_Title and Content, the user will simply give up trying to decide which one to use. Branding goes down the drain.

After 3 pastes from “designer” decks, this is what your client is struggling with:
After 3 pastes from designer decks

For maximum legacy compatibility, new templates you create for a client should include the slide layouts and placeholders of previous templates they have commissioned. Often it’s feasible to segregate these using different slide masters, one for each previous template they have used. Each slide master includes exactly the same layouts and placeholders used in a previous version, but with the branding updated to the new look. Then in the receiving template, the user is instructed to paste immediately after a slide based on an earlier version. This method can reduce the user’s pain of having to follow your shiny new template.

In a workflow where PowerPoint files are converted to Google Slides and back, none of the above will work. The XML created by Google is a mess and pasted slides will inevitably bring their non-standard Google layouts with them. There is no fix for this other than a custom VBA conversion macro.

We have years of expertise in this area and can either assess your template for legacy slide compatibility or create a template or theme for you that will work seamlessly with your old files. We’re here to help! Contact me at production@brandwares.com.

OOXML Hacking: Fix Broken PowerPoint Links

Please note: Microsoft has modified the nature of OLE links. It’s no longer possible to maintain relative OLE links (linked Excel and Word) in current versions of Office. The directions below will allow you to re-establish a broken link, but when you update the linked file, PowerPoint will write an abolute path. If you’re relinking other object types, like images, audio or video, this article will allow you to create permanent relative, semi-relative and absolute paths.

Someone sends you a presentation linked to an Excel file. The links don’t work and you can’t fix them without redoing them. Here’s how to fix broken PowerPoint links with a one minute of XML Hacking.

This article is really just for PowerPoint for Mac users. If you have the Windows version, you can fix broken links by choosing File>Info, then clicking on Edit Links to Files in the right-hand column under Related Documents. (Please note, the Edit Links option only appears if you actually have a link in the open presentation.) Word and Excel for Mac already have utilities to fix links.

If you haven’t hacked XML before, please read XML Hacking: An Introduction and XML Hacking: Editing in macOS. This article mentions Excel, which I’ve used as an example, but the same advice is true for Word files linked to PowerPoint. OLE Links to other formats, like PDF, are simply not supported on macOS.

In Office, links to documents include the complete path. Of course, when you move those linked files to a new computer, the path is always different, so the links must be corrected. The symptoms of a broken link depends on the type of link that was created. If the file creator selected a workbook section or chart, then used Paste Special to paste in a link, you’ll see this message when you double-click on the Excel excerpt:

Fix Broken PowerPoint Links - Paste Special

But the creator may have used Insert>Object instead, and chosen to link rather than embed the file. Then you’ll see this when you try to edit:

Fix Broken PowerPoint Links - Inserted Object

Then after dismissing that dialog, you’ll see the first one about the server error.


Fix Broken PowerPoint Links – The Steps

The issue is that a path is embedded in the PowerPoint file, and that path must be edited. Open the file in BBEdit.

The XML we need to change is associated with the slide(s) on which the Excel item is placed. So lets look. In the left-hand window, click on ppt. Then select slides then the _rels folder. Rels is short for relationships, and it’s the mechanism in every OOXML folder that tells PowerPoint where to find the objects in use.

The _rels folder has a .rels file for each slide in the presentation. Open the file for the slide containing the linked Excel. If the link was inserted using Paste Special, it will look like this (Pay attention to the third line and scroll all the way to the right. The path to be edited is in bold):

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
  <Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/oleObject" Target="file:///\\192.168.1.250\Dockets\Test\Excel\Link2PowerPoint.xlsx!Sheet1!R1C1:R1C4" TargetMode="External"/>
  <Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/slideLayout" Target="../slideLayouts/slideLayout7.xml"/>
  <Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing" Target="../drawings/vmlDrawing1.vml"/>
  <Relationship Id="rId4" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/image" Target="../media/image1.emf"/>
</Relationships>

If the Excel file has been inserted as an linked object, it won’t include a range of cells, just the workbook name:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
  <Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/oleObject" Target="file:///\\192.168.1.250\Dockets\Test\Excel\Link2PowerPoint.xlsx" TargetMode="External"/>
  <Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/slideLayout" Target="../slideLayouts/slideLayout7.xml"/>
  <Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing" Target="../drawings/vmlDrawing2.vml"/>
  <Relationship Id="rId4" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/image" Target="../media/image2.emf"/>
</Relationships>

Since the Excel item was inserted on a Windows computer, the path uses backslashes instead of forward slashes. There are two path syntaxes that are acceptable. If both the file linked to and the presentation containing the link are in your User folder, you can use a relative path and the linked file will open up immediately. If the file linked to is on a network share or somewhere on your disk outside your user folder, you will have to use an absolute path and you will get a challenge from Office when you open the link.

Let’s do the relative path first. In this example, the Excel file is in my user Documents folder and the PowerPoint is in my user Downloads folder. So I edit:

Target="file:///\\192.168.1.250\Dockets\Test\Excel\Link2PowerPoint.xlsx"

to:

Target="file:///../Documents/Test/Excel/Link2PowerPoint.xlsx"

In Unix/DOS speak, the 2 dots mean “go up one level”, out of the Downloads folder where the presentation is into the main user folder. Then the slashes lead you down into the Documents folder and subfolders to the Excel location. Once you set a relative path, you must leave the PowerPoint file in the same folder. Moving it will break the path.


Fix Broken PowerPoint Links – The Best Relative Path

For a linked file that you know will be moved from desktop to desktop, the best strategy is to place both files in the same folder. Then use this path:

Target="file:///Link2PowerPoint.xlsx"

Now even if you move it back to Windows, the linked Excel file will open as expected. As I noted above, when you open or update the linked Excel (or Word) file, PowerPoint will replace your relative path with an absolute one. This only happens with OLE links. For picture, audio, video and other file types, the relative link will remain unless you manually update.


Fix Broken PowerPoint Links – Absolute Paths

If the file to be linked to is on another disk, use an absolute path. With an absolute path, you can move the PowerPoint file anywhere on your computer or to other machines and it will still be able to find the linked file. Here’s what an absolute path looks like:

Target="file:///Volumes/TheNameOfYourHardDisk/Users/YourUserName/Documents/Test/Excel/Link2PowerPoint.xlsx"

Important! A macOS absolute path must begin with Volumes, followed by a slash and the name of the disk. If your network is set up for different operating systems, you’ll probably use an IP address instead, as shown in the original file path. Consult with your IT department.

Office 2016 for Mac applications are sandboxed applications, so when you first open an Office file linked with an absolute path, you’ll see a warning:


Fix Broken PowerPoint Links - Absolute Path Warning 1

Click on Select…, then you’ll see:

Fix Broken PowerPoint Links - Absolute Path Warning 1

Select the correct file if it isn’t already selected, then click on Grant Access. Now double-click on the linked Excel item to edit and you’ll see this again:

Fix Broken PowerPoint Links - Edit Warning

OK, that’s something of a hassle, but the good thing is that you won’t see those warnings again as long as the linked file says in the same place with the same name. You also only get warned once per placed file, even if there are multiple uses of that file in your presentation.

Linked files are a huge benefit when you have a data source that is constantly being updated. Using them means your presentation can always be up to date. Now that you know how to fix the links, you have a very useful new tool.

OOXML Hacking: Custom Content in AutoText Gallery

Using the Word for Windows program interface, you can select custom content, then add it to an AutoText gallery. As an example, select a Table of Contents and then add it to the TOC Gallery using References>Table of Contents>Save Selection to Table of Contents Gallery (highlighted in red below):

Add a Table of Contents to the TOC Gallery

Unfortunately, Mac versions of Word do not share this feature. But it’s a simple hack. If you are new to XML editing, please read XML Hacking: An Introduction. MacOS users should also read XML Hacking: Editing in macOS to avoid a couple of Mac-specific XML issues. The latter article now mentions the free XML editing plugin for the Chrome browser in the July 2018 update.

This hack will add content to other Word Galleries, like the Cover Page Gallery. Please see the last section of this article for the details.

If This is For Your Own AutoText Gallery

The directions below assume you’re adding AutoText to a template for a client. What if it’s just for yourself? In that case, you would be adding AutoText to your Normal.dotm template.

Normal.dotm is stored in your user Library folder. To find it:

  1. Hold down the Option key, while clicking on the Go menu (macOS menu bar) and choose Library. A window opens showing your user Library.
  2. Open ~/Library/Group Containers/UBF8T346G9.Office/User Content/Templates.
  3. Make a copy! If your Normal template contains any macros, other AutoText or styles, you don’t want to lose them all by making an XML editing mistake.

Add a Table of Contents to the TOC Gallery – The Steps

Make sure you’re working on a template rather than a document. We’ll be using AutoText, and AutoText is saved to the template. If you’re working on a document, the AutoText would get saved to the template attached to the document, not the document itself.

  • Start by making the invisible characters visible, using Word>Preferences…>View and checking All in the Show Non-Printing Characters section.
  • Now select the custom Table of Contents, making sure to include the paragraph mark just below it.
  • Choose Insert>AutoText>AutoText….
  • Set the Look in: dropdown to the name of the template you’re working on.
  • In the Enter AutoText entries here: field, give the AutoText entry a sensible name like Clientname Custom TOC.
  • Click on the Add button and save the template. Close Word.
  • Open the template file in your text editor or Chrome browser with the OOXML plugin.
  • Navigate to word/glossary and open document.xml, the home of all AutoText.
  • Search for the name you gave the TOC AutoText entry. The first few lines should look something like this:
  <w:docParts>
    <w:docPart>
      <w:docPartPr>
        <w:name w:val="Brandwares Custom TOC"/>
        <w:style w:val="TOC 2"/>
        <w:category>
          <w:name w:val="General"/>
          <w:gallery w:val="docParts"/>
        </w:category>
        <w:behaviors>
          <w:behavior w:val="content"/>
        </w:behaviors>
        <w:guid w:val="{DBD01F60-383F-C040-9417-745701ADCDFD}"/>
      </w:docPartPr>
  • Make 2 changes in the <w:category> section:
    1. Change the w:name value from General to a more meaningful name like Custom TOC. This will display as the heading under which your custom TOC appears.
    2. Change the w:gallery value from docParts to tblOfContents. This is the crucial step that makes the TOC appear in the TOC Gallery.
  <w:docParts>
    <w:docPart>
      <w:docPartPr>
        <w:name w:val="Brandwares Custom TOC"/>
        <w:style w:val="TOC 2"/>
        <w:category>
          <w:name w:val="Custom TOC"/>
          <w:gallery w:val="tblOfContents"/>
        </w:category>
        <w:behaviors>
          <w:behavior w:val="content"/>
        </w:behaviors>
        <w:guid w:val="{DBD01F60-383F-C040-9417-745701ADCDFD}"/>
      </w:docPartPr>
  • Resave the template file, close the editor and open it in Word.
  • Choose References>Table of Contents, scroll down to the Custom TOC section and choose your custom TOC.

Final Custom TOC in TOC Gallery


Add Content to a Different AutoText Gallery

You can use exactly the same steps to add a custom cover to the Cover Gallery. Just change the w:category w:name value to Custom Covers and the w:gallery value to coverPg. Use the table below to find the values used for other gallery type.

Please note, the category names are Microsoft defaults, and yes, they are inconsistent whether they spell it Built-in or Built-In. Using these will group your entry with them. If you want your own category, just use a different word or phrase and Word will add it on the fly. To make the category pop to the top of a list, include a space in front of the name (Thanks to Timothy Rylatt for the suggestion):

Gallery Type w:category w:name Values w:gallery Value
Bibliographies Built-In bib
Cover Pages Built-In coverPg
Equations Built-In eq
Footers Built-in ftrs
Headers Built-In hdrs
Page Numbers Page X, Page X of Y, Plain Number, Plain Text, With Shapes pgNum
Page Numbers (Bottom of Page) Page X, Page X of Y, Plain Number, Simple, With Shapes pgNumB
Page Numbers (Margins) Page X, Plain Number, With Shapes pgNumMargins
Page Numbers (Top of Page) Page X, Page X of Y, Plain Number, Simple, With Shapes pgNumT
Placeholders General placeholder
Table of Contents Built-In tblOfContents
Tables Built-In tbls
Text Boxes Built-in txtBox
Watermarks Confidential, Disclaimers, Urgent watermarks

If this looks too geeky for you, we’re glad to help! Brandwares is full-service template creation service specializing in working with graphic designers and corporations. Contact me at production@brandwares.com.

The Flat Theme – Best Practices

Flat Theme Shape Styles

I’m writing an article or two about Office Effects Themes and how you can modify them. As an example, I created the Brandwares Flat Theme, which will be of use to designers as is. This theme file gets rid of the bulgy 3-D shapes, glows and hokey shadows of the standard Microsoft themes and relies only on tints, shades and outline variations. You can use this example in 2 ways: as a theme file that you can modify and send as your own, and as an Effects Theme file that can be installed in Office for Windows to provide access to flat shapes in all other themes.

Here you can download the Flat Theme. It’s also available on our Downloads page. After downloading, you can open it in PowerPoint, create new font and color themes, apply them, then resave as a new theme. The flat shapes will travel with the theme and be automatically applied to any deck that uses the theme. If you’re an Office for Mac user, you’ll have to create a font theme using this article: XML Hacking: Font Themes.


The Flat Theme – Specs

There are 7 variants in each row of the the Shape Styles dialog, each showing the dk1 color as a background plus the 6 Accent colors. The first 2 rows feature a 0.5pt outline on the shape in a darker variant of the accent color, with the first row showing a white shape background and the second row the relevant accent color.

The third row is the one I choose most of the time: a flat shape with no outline.

The fourth row has a 50% screened-back background color with black text.

The fills for the 5th and 6th rows are 2 progressively darker shades of the accent colors. The 5th row shows a 50% shade of the color, while the 6th is a two-layer multiplier fill with a 50% shade overlaying a 50% tint. I’ve written at length about effects themes and their construction in my book about OOXML Hacking.

Users of Office 2016 for Windows and for Mac will see an additional group of Presets below the theme shape styles. Except for the stroke weight in row 2, these fills are generated automatically by the program and cannot be modified by XML.


The Flat Theme – Installing as Effects Theme

You can also use the Flat Theme as a new effects theme in Windows versions of Excel, PowerPoint or Word (Office for Mac will display effects themes embedded in a theme or template, but there is no support in the program interface for applying a different effects theme). Then it will appear in the Theme Effects dropdown of Office for Windows along with the standard Microsoft themes. Here are the steps to do that:

  1. Download the Flat Theme from the link above and unzip it.
  2. Change the file name from BrandwaresFlatShapes.thmx to Flat.eftx. The first part of the name can be something other than Flat, but the ending must be .eftx. No other change to the theme file is needed.
  3. Close all Office programs.
  4. Copy the file to the same folder as the Microsoft Theme Effects files:

32-bit Office 2007: C:\Program Files (x86)\Microsoft Office\Document Themes 12\Theme Effects

64-bit Office 2007: C:\Program Files\Microsoft Office\Document Themes 12\Theme Effects

32-bit Office 2010: C:\Program Files (x86)\Microsoft Office\Document Themes 14\Theme Effects

64-bit Office 2010: C:\Program Files\Microsoft Office\Document Themes 14\Theme Effects

32-bit Office 2013: C:\Program Files (x86)\Microsoft Office\root\Document Themes 15\Theme Effects

64-bit Office 2013: C:\Program Files\Microsoft Office\root\Document Themes 15\Theme Effects

32-bit Office 2016, 2019, 2021 and Microsoft 365: C:\Program Files (x86)\Microsoft Office\root\Document Themes 16\Theme Effects

64-bit Office 2016, 2019, 2021 and Microsoft 365: C:\Program Files\Microsoft Office\root\Document Themes 16\Theme Effects

With Office 2013 and 2016, there may not be a root folder, but then the Document Themes folder will be inside Microsoft Office, eliminating one level.

Restart an Office program and you’ll see a new addition to the Effects dropdown:

Using the Brandwares Flat Shapes theme as an Effects Theme
Flat Theme Chosen

Please note, repairing Office in Windows will normally delete all non-Microsoft effects themes, so re-installation will be necessary.

Video Formats – Best Practices

It can be a bewildering subject, figuring out which video formats are going to work in a presentation. It’s doubly difficult when a presentation is designed on one computer, then played on another. I can’t count the number of seminars I’ve observed where the presenter is humming and hawing about the video: “Well it worked in rehearsal…” Even Microsoft’s web site has inaccurate information about choosing a video format, so what’s a user to do?

Fortunately, we’ve done lots of research and testing on the subject. I’m focusing here on the use of video in PowerPoint and Keynote presentations to find what works reliably. But I make one assumption: that you are using current versions of the software and operating system. In Windows, you should be on Windows 7 or better and be using Office 2010 or better. In macOS, I regard El Capitan (10.11) as a minimum, running at least Keynote 6 and/or Office 2016 for Mac. You may be able to get away with less, but the degree of uncertainty and need for testing goes up.


Video Formats – Containers

The main reason why there is so much confusion around video formats is that each video has at least 2 types of format. One is the Container format and is denoted by the file ending of the video. MP4, MPG and MOV are Container formats. Most people refer to the container format, but most can hold a variety of video and audio streams that be differently encoded. An analogy might be a Word document that can contain a variety of languages. A .docx file ending doesn’t tell you if it’s an English text!


Video Formats – Codecs

The second format is the encoding, referred to as the Codec (short for Compression/Decompression). H.264 or MPEG-2 are both video codecs, but there are also audio codecs like MP3 and AAC. To ensure a video plays reliably in any given context, you have to have both the right container and codec formats. This is the source of the common complaint “Well, I used an .MP4 file, but it didn’t work.” The codec was wrong.

It’s not such a big issue when all computers in a company are one operating system. If you’re only using Windows, slap in a WMV file, it will work. Usually. But when a company has mixed operating systems, or when you’re designing one one operating system for use on another, you have to be much more selective.

So here’s my recommendation: stick with MP4 for a container format with H.264 for a codec. It is supported by most software, plus HTML5. An MPG container with the MPEG-2 codec is also reliable for desktop software. Using either of these 2 format combinations, the video will play in Keynote or PowerPoint in macOS and PowerPoint in Windows. Always.

But how do you tell what codec is used in a given file? The MP4 or MPG file ending gives nothing away.


Video Formats – Finding the Codec

In macOS, open the video file in QuickTime Player, then choose Window>Show Movie Inspector. The video and audio codecs will display beside the Format heading. Here’s what you’ll see with a usable MP4 or MPG file:

macOS – MP4 + H.264
Video formats: MP4-H.264
macOS – MPG + MPEG-2
Video formats: MPG-MPEG-2

Windows users must install third-party software. You can use the VLC video player for this, but I prefer MediaInfo, which is focused on simply providing information. One note: MediaInfo shows the H.264 codec as AVC. These shots show the video format highlighted in yellow:

Windows – MP4 + H.264
Video formats: MP4-H.264
Windows – MPG + MPEG-2
Video formats: MPG-MPEG-2

Let’s hear what your experiences are with video in cross-platform presentations. Victories and horror-shows are both entertaining, I look forward to reading your comments.

SuperThemes from Brandwares

SuperThemes are a Microsoft-created theme format that includes more than one theme in the same file. You see them in action when you use a Microsoft theme in PowerPoint 2013 for Windows and PowerPoint 2016 for Windows and Mac. Opening a SuperTheme lights up the Design tab>Variants Gallery with design choices, like this selection used in Microsoft’s Ion Boardroom SuperTheme:

SuperThemes from Microsoft

SuperThemes have 2 signficant advantages:

  1. The design variants show right up front on the Ribbon, so users immediately see what alternate looks are available to them.
  2. Including size variants ensure that the brand is never distorted by the user changing the slide size. The user can choose a slide size that completely fills any monitor, but the logos and artwork always remain at the aspect ratio you have set. No more graphic distortion

SuperThemes have been around for several years, but Microsoft has never released the specifications for creating them. Brandwares got to work on the problem and has reversed engineered the format. When I originally wrote this, we were the only company in the world that could create custom SuperThemes for you. But I published all the details in my book OOXML Hacking, so now anyone can do it!


SuperThemes – How They Work

Micrsoft’s SuperThemes include 4 to 8 design variants plus size variants for 16:9 and 4:3 aspect ratios. But that’s just a starting point. Down at the lab we found we can create size variants for 16:10 monitors, 35mm film and all the other preset sizes that Microsoft includes in PowerPoint. One client commissioned SuperThemes so they could display widescreen, then switch to 4:3 to print the deck on letter-size paper. Here’s a downloadable example you can try out: Test SuperTheme

This SuperTheme contains 2 design variants, one with a white background and a second with a grey background. It also includes 3 size variants, for 16:9, 16:10 and 4:3. After you download and unzip the file, copy it to the the Document Themes folder inside your Office templates folder. Under Windows, this will normally be in your user Documents folder under Custom Office Templates\Document Themes. Mac users will need to hold down the Alt key while clicking on the Go menu and choosing Library. This opens the hidden user Library. Once that’s open, look for Library/Group Containers/UBF8T346G9.Office/User Content/Themes and copy the .thmx file to that folder.

Now open PowerPoint, select the Design tab and drop down the Theme Gallery. Now there’s a new row called Custom and that’s where you’ll find the test SuperTheme:

Design Tab Custom Row

Select it and you’ll see 2 variants appear:

SuperThemes have Variants

Switching design variants will change all slides in the presentation to that design. Now try changing the Slide Size. There are 2 sizes immediately available, 4:3 and 16:9. Notice that the logo remains undistorted even when the slide size changes. You can’t do that with a normal theme!

But many monitors are 16:10 and using 16:9 leaves big black bars at the top and bottom of your show. That’s not a problem with this SuperTheme. Click on Slide Size>Custom Slide Size (Slide Size>Page Setup on a Mac). Change the Slide(s) sized for: dropdown to On-Screen Show (16:10). The presentation is resized without any distortion to the logo. (Since we’ve set up just 3 sizes, if you picked one of the other sizes like Banner or 35mm Film you would see logo distortion. So don’t do that!)

When PowerPoint is using a SuperTheme with size variants, the Slide Size button works in a different way than normal. Inside of actually resizing the slide, it calls the associated size variant. If there is no variant for the chosen size, then PowerPoint resizes as usual. When you change the slide size to a smaller canvas, PowerPoint will ask whether you want to Maximise or Ensure Fit (Don’t Scale or Scale on a Mac). In a SuperTheme where you are switching to a supported size variant, it doesn’t matter which you choose, because PowerPoint won’t actually be resizing the slides. It just applies a variant theme.


SuperThemes – What You Need to Know

SuperThemes are intended for use with PowerPoint 2013 and 2016. They can be used with earlier versions, but there will only be access to the primary theme. This is normally set to Widescreen, so a user of older software should switch the slide size from the default 4:3 10″ x 7.5″ format.

Research in 2019 has revealed that SuperThemes can only be constructed from Presentations having a single Slide Master. It appears that Microsoft didn’t design the format for the additional complexity of multiple masters.

For a custom SuperTheme, you can supply separate themes or templates for each design and size variant. Each design variant can be completely independant, using different font or color themes, if needed. Multiply the number of designs by the number of sizes to know how many theme to supply. The downloadable SuperTheme above uses 2 designs in 3 sizes, so 6 themes went into its making.

Keep in mind that SuperThemes have the same shortcomings as themes. They can’t contain custom tables styles, macro programming, sample slides or preformatted notes or handout masters. If you need to be distributing any of those, consider using a template instead of a theme or SuperTheme.

When designing for SuperThemes, consider what might happen to an existing deck if the user changes the slide size after inserting graphics. If content placeholders in your variant themes have different aspect ratios, photos will still get distorted. So part of your design would be to include picture boxes that have a constant aspect ratio in all themes. They can be bigger or smaller, as long as the ratio of long side to small side is the same.

For 16:9 themes, we do not recommend the older On-screen Show (16:9) slide size produced by PowerPoint 2007 and 2010. This creates a slide that is 10″ x 5.63″. It’s the right proportion, but when a user creates a new slide in PowerPoint 2013 or 2016, it defaults to the new Widescreen size 13.333″ x 7.5″. This means your theme graphics are scaled up and you lose quality. Instead, create 16:9 themes using the Widescreen size created by newer versions.

For 16:10, we’ve found that a 12″ x 7.5″ slide size works perfectly. Of course, 4:3 slides are still 10″ x 7.5″, as always. This means that you can keep the height constant on all size variants. Only the width changes.

Then email the themes to us and we’ll assemble them for you. Too complicated? We’re a full-service Office shop: we can create complete SuperThemes from an InDesign or Illustrator file. Just tell us which slide sizes you want to support and we’ll do the rest. When we create a deck, it’s always guaranteed to work as expected, since we know Microsoft Office at least as well as you know Adobe software. Contact me at production@brandwares.com

OOXML Hacking: Repairing Color Themes

Last time, I wrote about how to make great color themes. But what about if you (or your client) have discovered that an existing color theme has a problem. If you catch them early, most issues with color themes can be corrected using PowerPoint’s user interface. Say you’ve created a theme or template, but some of the tests in the last article show problems. Repairing color themes requires rearranging the theme colors, then recoloring any graphic elements on the Slide Master and Slide Layouts.

If you didn’t test the template or theme and you’ve already created a presentation before finding the theme problem, it’s more work to fix. Follow the same sequence: rearrange the colors in the theme, fix the Slide Master, then the Layouts and finally repair any element on each slide that still needs help.

But what about if there are multiple templates, or several decks that have been created from a faulty theme? Repairing color theme problems manually quickly becomes an ordeal. It’s time-consuming and error-prone to try to make all the changes by hand. Searching and Replacing using a text editor would be much quicker and more thorough. It’s time to hack some XML!


Repairing Color Themes – The Theme

If you haven’t editing XML directly before, please read XML Hacking: An Introduction. MacOS users should also read XML Hacking: Editing in macOS to avoid a couple of Mac-specific XML issues.

We’re going to fix all the color theme problems by searching for XML text and replacing it with corrected values. Professional test editors really shine for this kind of work because of their abilities to do search and replace on multiple folders full of files, saving you hours of work. NotePad++ for Windows and BBEdit for macOS are 2 excellent choices for this work, they both have multi-file search and replace.

If you’re using Windows, unzip the files in a separate folder. On a Mac, open the theme or template in BBEdit.

Start by correcting the color order of the theme file located in ppt\theme\theme1.xml. During design, you may have applied more than one theme and PowerPoint hoards them all. If you have more than one theme file, check the name attribute to ensure you’re changing the one actually used in your deck. (If the theme is called Office Theme, that’s a Microsoft default, you don’t have to update it.) You may also have more than one theme if your presentation contains more than one slide master. Here are before and after examples, showing only the first 4 colors:

Before: Theme1.xml
<a:clrScheme name="Broken">
  <a:dk1>
    <a:srgbClr val="333333"/>
  </a:dk1>
  <a:lt1>
    <a:srgbClr val="518CA3"/>
  </a:lt1>
  <a:dk2>
    <a:srgbClr val="FFFFFF"/>
  </a:dk2>
  <a:lt2>
    <a:srgbClr val="E4E4E4"/>
  </a:lt2>

This has blue in the lt1 (Light 1) slot and white in the dk2 (Dark 2) spot. One symptom is inserted SmartArt that shows blue text instead of the expected white.

Before: SmartArt Appearance
Repairing Color Themes - Before
After: Theme1.xml
<a:clrScheme name="Repaired">
  <a:dk1>
    <a:srgbClr val="333333"/>
  </a:dk1>
  <a:lt1>
    <a:srgbClr val="FFFFFF"/>
  </a:lt1>
  <a:dk2>
    <a:srgbClr val="518CA3"/>
  </a:dk2>
  <a:lt2>
    <a:srgbClr val="E4E4E4"/>
  </a:lt2>

If a presentation uses Chart Templates, you may also see files in the Theme folder like themeOveride1.xml. This override component allows a chart template to have a color theme different from the presentation into which it’s placed. All chart templates created from a template contain this themeOverride component, which is simply a copy of the main color theme. If the template color theme is bad, then you’ll also have to open all the chart templates and update chart/theme/themeOverride1.xml.


Repairing Color Themes – The Slide Master

For our simple example, we can skip this step, but for more complex repairs, it may also be necessary to adjust the color map in the slide master. If the presentation was based on a color theme exported from Word or Excel, this is necessary. It’s also often needed for legacy decks that have been imported from PowerPoint 2003 and earlier.

The Slide Master has 2 parts. First is the slide formatting that displays in the Slide Master view of PowerPoint. It’s tagged with <p:cSld>. Immediately after that are parameter storage sections holding references to the slide layouts, title, body and other text formatting, etc. The very first section <p:clrMap is what we’re looking for. The full default color map looks like this:

<p:clrMap bg1="lt1" tx1="dk1" bg2="lt2" tx2="dk2" accent1="accent1" accent2="accent2" accent3="accent3" accent4="accent4" accent5="accent5" accent6="accent6" hlink="hlink" folHlink="folHlink"/>

Compare this to a color map when a Word color theme is imported to PowerPoint:

<p:clrMap bg1="dk1" tx1="lt1" bg2="dk2" tx2="lt2" accent1="accent1" accent2="accent2" accent3="accent3" accent4="accent4" accent5="accent5" accent6="accent6" hlink="hlink" folHlink="folHlink"/>

You can see that the dark colors dk1 and dk2 are mapped to the background instead of the text, while text is formatted with lt1 and lt2. The color theme hasn’t been altered, just the way it is mapped to the presentation elements. There is nothing in the program interface to fix this, you must edit the XML. Mental organization becomes very important when changing both the theme and the color map, you can easily get confused.


Repairing Color Themes – Search and Replace

The above steps are preparatory to making the actual changes. Now we need to change the color tags attached to all affected elements in the Slide Master(s) and all Slide Layouts and Slides. Let’s use the example of switching the blue and white. The blue was in the lt1 slot, which is mapped in the Slide Master to bk1 by default. The white was in the dk2, mapped to tx2. After switching the color order, we need to change all bk1 color tags to tx2 and all tx2 tags to bk1.

Wherever a tag is used as an attribute, it has straight quotes before and after. Include these in your search terms so you don’t mess up the color map in the Slide Master. It’s simplest to run this on all files in the archive:

Find what: “bk1” – Replace with: “tx22”

Find what: “tx2” – Replace with: “bk1”

Find what: “tx22” – Replace with: “tx2”

That should do it! Zip up the files with the same file ending as the original, if you’re using Windows. On the Mac, just save the file. Test in PowerPoint.

After: SmartArt Appearance
Repairing Color Themes - After

This is the simplest repair scenario. Sometimes you have to move more colors around, particularly if the creator was someone unfamiliar with PowerPoint. Make notes ahead of time, to make sure you’ve got the right colors moving to the right slots. And always work on a copy of the file, not the original! If it gets too complicated, just send it to us, we do this kind of thing all the time.

Next time, I’ll be discussing PowerPoint SuperThemes. Brandwares has cracked the construction of these, so I’ll cover what you need to know.