Software

Combine the power of Microsoft Office 2007 and 2010

By · March 30, 2011, 1:24 AM PST · sonjathompson

Image 1 of 21

  • Trust Settings for Microsoft Office 2007 - Office button

    In a guest post, a TechRepublic member provided steps for uncovering a ton of Easter eggs by combining Microsoft Office 2007 with 2010. Here are the screenshots that walk you through the installation procedure. Be sure to read the post for the entire step-by-step process.

    After you've installed Microsoft Office 2007, you must install the Creative Commons Primary Interop Assemblies (PIA). In order for this to work, you must open Word, Excel, and PowerPoint 2007 in Trust Settings (Word must be opened first). Begin by clicking the Office button.

  • Trust Settings for Microsoft Office 2007 - Word Options

    Select Word Options.

  • Trust Settings for Microsoft Office 2007 - Trust Center Settings

    Select Trust Center and then Trust Center Settings.

  • Trust Settings for Microsoft Office 2007 - Macro Settings

    In the Macro Settings section, make sure that “Disable all macros except digitally signed macros” and “Trust access to the VBA project object model” are selected.

  • Trust Settings for Microsoft Office 2007 - ActiveX Settings

    In the ActiveX Settings section, make sure that “Prompt me before enabling all controls with minimal restrictions” and “Safe mode (helps limit the control’s access to your computer)” are selected [Note: The “Safe mode” is equivalent Office 2010’s Data Execution Prevention (DEP) mode, and it’s imperative that both are enabled, otherwise the goodies, eggs, and features won’t function properly between Office 2007 and 2010.]

  • Trust Settings for Microsoft Office 2007 - Add-ins

    In the Add-ins section, select “Require Application Add-ins to be signed by Trusted Publisher” [Note: This step is not required, but it’s strongly recommended so that certificates are valid (not expired) and recognized from reputable sources.]

  • Trust Settings for Microsoft Office 2007 - Message Bar

    In the Message Bar section, select “Never show information about blocked content” and make sure that “Enable Trust Center logging” at the bottom is NOT selected. Logging has to remain unchecked for Office 2007 and 2010 to work together.

  • Trust Settings for Microsoft Office 2007 - Privacy Options

    In the Privacy Options section, check everything under Privacy Options, plus “Store random numbers to improve Combine accuracy” and “Make hidden markup visible when opening or saving” under Document-specific settings. You can select the Translation Options and Research Options accordingly to your own preferences.

  • Trust Settings for Microsoft Office 2010 - Options

    After you've installed Microsoft Office 2010 (using the instructions listed in the blog post), it's time to install the "Creative Commons for 2010" PIA, which requires specific Trust Settings. Starting with Word, select Options.

  • Trust Settings for Microsoft Office 2010 - Trust Center

    Select Trust Center.

  • Trust Settings for Microsoft Office 2010 - Trust Center Settings

    Select Trust Center Settings.

  • Trust Settings for Microsoft Office 2010 - Default File Block Settings

    Here are the default File Block Settings.

  • Trust Settings for Microsoft Office 2010 - File Block Settings

    Clear all of the boxes in File Block Settings except for the very last option “Open selected file types in Protected View and allow editing.” Click Ok, and then go back to Options | Trust Center | Trust Center Settings.

  • Trust Settings for Microsoft Office 2010 - Protected View

    In the Protected View section, make sure that everything is selected.

  • Trust Settings for Microsoft Office 2010 - Macro Settings

    In Macro Settings, “Disable all macros except digitally signed macros” and “Trust access to the VBA project object model” must be selected in order for Office 2007 and 2010 to work together.

  • Trust Settings for Microsoft Office 2010 - ActiveX Settings

    In ActiveX Settings, select “Prompt me before enabling all controls with minimal restrictions” and “Safe mode (helps limit the control’s access to your computer.”

  • Trust Settings for Microsoft Office 2010 - Add-ins

    In the Add-ins sections, select “Require Application Add-ins to be signed by Trusted Publisher.”

  • Trust Settings for Microsoft Office 2010 - Trusted Documents

    In Trusted Documents, select “Allow documents on a network to be trusted.”

  • Trust Settings for Microsoft Office 2010 - Privacy Options

    In Privacy Options, make sure that everything is selected under the Privacy Options heading, plus “Store random numbers to improve Combine accuracy” and “Make hidden markup visible when opening or saving” is selected under Document-specific settings (Excel and PPT are slightly varied, but you will catch on easily).

  • Microsoft Office Add-ins

    Add-ins create some new Program files of their own, which can be confusing to a user. All the ones I highlighted in the accompaniment image are Add-ins, including the "Microsoft Creative Commons Add-in" (PIA for Office 2007) and "Microsoft Research" (Creative Commons PIA Add-in for 2010). So, why have three Microsoft Math Add-ins? The first Add-in for Word 2007 is actually the old original version, the Microsoft Mathematics and Mathematics Add-in is 3.0, and the newest one is 4.0.

  • Lengthy configuration time when combining Microsoft Office 2007 and 2010

    It takes time to install Creative Commons into Word, Excel, and PPT – especially in Office 2010, because it configures both 2007 and 2010 together.

Trust Settings for Microsoft Office 2007 - Office button

In a guest post, a TechRepublic member provided steps for uncovering a ton of Easter eggs by combining Microsoft Office 2007 with 2010. Here are the screenshots that walk you through the installation procedure. Be sure to read the post for the entire step-by-step process.

After you've installed Microsoft Office 2007, you must install the Creative Commons Primary Interop Assemblies (PIA). In order for this to work, you must open Word, Excel, and PowerPoint 2007 in Trust Settings (Word must be opened first). Begin by clicking the Office button.

Related Topics:

Software Enterprise Software Developer Open Source Software Mobility Cloud

By Sonja Thompson

Sonja Thompson started at TechRepublic in October 1999. She is a former Senior Editor at TechRepublic.

Show Comments