Excel.Tips.Net ExcelTips (Menu Interface)

Using the Report Manager

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:


ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2902) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Related Tips:

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 5+3 (To prevent automated submissions and spam.)
           Commenting Terms

Comments for this tip:

awyatt    06 Jun 2014, 17:29
It no longer exists, Steve (and others). As I mentioned in the tip above, Microsoft has been phasing it out for years.

That is why this tip is ONLY for users of the older versions of Excel, as noted, and there is no equivalent tip for newer versions.

Fred    06 Jun 2014, 16:36
Just what we all need: information about something that doesn't exist. Great! What could be better!
qzj00    07 Dec 2012, 20:22
I tried the supplied link
but got the following message:

Oops! The page you are looking for may have a new location, or is no longer available.
Stve Nadel    06 Dec 2012, 06:34
Hello Allen:

I am trying to find this feature in Excel 2010. I'm told it no longer exists. I've done research on the Internet and found several third party software. Have you tried out any of those third party programs and would you give any of them your recommendation?


Steve Nadel    06 Dec 2012, 06:32
Hi Allen:

I am looking for The Report Manager feature in Excel 2010. I am told that it no longer exists. If that is the case, can you recommend a third party replacement. I have seen a few on the Internet, but I want to know if you have tested it yet?

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.