Using the Report Manager

by Allen Wyatt
(last updated December 22, 2015)

We are all familiar with reports. In fact, in many businesses it seems we spend a good part of each day either reading, developing, or printing reports. In Excel, however, a report is similar to a view. A report is nothing but a stored definition of how you want a workbook printed. Reports are made up of sections, and each section can contain a different worksheet within the workbook and, optionally, a view and scenario for that worksheet. (Views and scenarios were covered in other issues of ExcelTips.)

Reports are created and accessed using the Report Manager add-in, which is not an integral part of Excel. It is an add-in that can be added to or removed from Excel, depending on your needs. When you first install Excel, the Report Manager is typically not enabled. You can check to see if the Report Manager is available by pulling down the View menu. If there is a Report Manager option, it is already installed and enabled on your system.

If you cannot find a Report Manager option in the View menu, you will need to make sure the Report Manager is enabled by following these steps:

  1. Choose Add-Ins from the Tools menu. Excel displays the Add-Ins dialog box. (See Figure 1.)
  2. Figure 1. The Add-Ins dialog box.

  3. Scroll through the list of available add-ins (if necessary), and make sure there is a check mark in the box to the left of the Report Manager option.
  4. Click on the OK button.

At this point Excel enables the add-in. If necessary, you are led through the process of installing the add-in from CD. You should now be able to see the Report Manager option in the View menu.

If you cannot find the Report Manager option in the list of available Add-Ins (step 2), and you are using Excel 97 or Excel 2000, you will need to run the Excel (or Office) setup program again and make sure you install it from there.

If you are using Excel 2002, the Report Manager is not available through the setup program. Instead you must download it to your system from the Microsoft Web site. Using the online help system, search for "report manager," and then follow the download instruction. You can then make sure the Report Manager add-in is enabled in Excel.

If you are using Excel 2003, you won't be able to locate information about the Report Manager by using online help. This is because Microsoft is trying to phase out the add-in, even though it still has real value for some users. Don't despair; the same add-in you can download and use with Excel 2002 can also be downloaded and used with Excel 2003. You can find more information on exactly how to do this by using the following article in the Knowledge Base:

http://support.microsoft.com/kb/873209

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2902) applies to Microsoft Excel , 8, , 10, and .

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Turning Off Names

You can use some of the tools in Excel to convert cell references in formulas into names. Converting back (from names into ...

Discover More

Inserting and Deleting Footnotes

Footnotes are essential in some types of writing. When you need to add footnotes to your documents, you'll appreciate the ...

Discover More

Quickly Transposing Cells

If you want to turn a range of cells by 90 degrees within a worksheet, you need to understand how Excel can handle the ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

MORE EXCELTIPS (MENU)

Editing Reports

The Report Manager allows you to create specialized reports that can be easily printed from your worksheet data. This tip ...

Discover More

Adding a Report

The Report Manager allows you to create specialized reports that can be easily printed from your worksheet data. This tip ...

Discover More

Printing Reports

The Report Manager allows you to create specialized reports that can be easily printed from your worksheet data. This tip ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)