Instructions For Opening The 2013 Trends® Workbook

The Excel version of PKF Consulting’s Trends® in the Hotel Industry – 2013 edition was created using Excel 2010 and is saved as a macro enabled workbook (.xlsm) file. These instructions are also located in a README document in the zip file which contains the Excel workbook.

The macros embedded in the 2013 Trends® workbook were added to enhance its functionality. Depending on the Excel Macro Security settings on your computer, you may need to enable them in order to utilize that functionality. When you open the workbook, if you cannot click the I Agree button to continue, please click the version of Excel you're using for instructions on how to enable the macros and unlock the full functionality of the workbook.

• Excel 2003 or earlier
• Excel 2007
• Excel 2010

Excel 2003 or earlier

1. If the 2013 Trends® workbook will not open at all, you will need to install the Office Compatibility Pack on your computer. The Compatibility Pack is designed to allow older versions of Excel to work with files saved in the newer format (2007, 2010, and 2013). You can download the Compatibility Pack from free from Microsoft’s Download Center by clicking here. Please be sure to follow all instructions on Microsoft’s page before installing the Compatibility Pack.
2. Once the Compatibility Pack is installed, open the 2013 Trends workbook. A Security Warning message (see below) should pop up, informing you that the file contains macros.
   
   
   
   
3. Click Enable Macros.
4. On the opening page of the workbook, click the I Agree button to accept the terms and conditions and proceed to the Table of Contents page.
5. If the Security Warning does not appear AND if the I Agree button will not work, you will need to adjust the macro security settings in Excel.
6. On the Tools menu in Excel, point to Macro, and then click on Security.
7. Choose the Medium setting (see below) and then click OK.
   
   
   
   
8. Close and then re-open the 2013 Trends® workbook so that the new macro security settings will take affect. At the Security Warning pop-up, select Enable Macros.
9. On the opening page of the workbook, click the I Agree button to accept the terms and conditions and proceed to the Table of Contents page.

Excel 2007

1. When the workbook opens, a Security Warning bar may appear between the Excel Ribbon and the workbook area (see below, circled in red), informing you that Macros have been disabled. If you click the I Agree button in the workbook area, a message will pop up telling you that a macro cannot be run.
   
   
   
   
2. Click the Options button on the Security Warning bar to open the Microsoft Office Security Options.
3. Select Enable this content (see below, circled in red) and click OK.
   
   
   
   
4. On the opening page of the workbook, click the I Agree button to accept the terms and conditions and proceed to the Table of Contents page.

Excel 2010

1. When the workbook opens, you may see a Protected View warning (see below, circled in red).  Click the Enable Editing button if you see this message.
   
   
   
   
2. A Security Warning bar may appear next (see below, circled in red), informing you that Macros have been disabled.
   
   
   
   
3. Click Enable Content.
4. Click the I Agree button to accept the terms and conditions and proceed to the Table of Contents page.

If you have try these steps and the workbook still won’t work for you, please give David Murff a call at (832) 571-2280 or send an email to david.murff@pkfc.com.