Excel Report manager gone?

[jcoley2]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I am using Excel 2008 for Mac and cannot seem to find the report manager that Excel used to have--did it get removed for the 2008 version?

As an alternative, I formated each worksheet individually and then deleted the sheets I did not want to print and tried printing workbook but it has all the formatted pages incorrectly.

Any help appreciated.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I am using Excel 2008 for Mac and cannot seem to find the report manager that
Excel used to have--did it get removed for the 2008 version?

As an alternative, I formated each worksheet individually and then deleted the
sheets I did not want to print and tried printing workbook but it has all the
formatted pages incorrectly.

Any help appreciated.

Yes, the report manager is gone. It is based on VBA, and there is no VBA in
Office 2008. You'll have to give us more of a hint about the formatting.
What is not printing correctly? What is happening? Why do you think it is
wrong? Have you updated to the latest print drivers?

 

[jcoley2]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I am using Excel 2008 for Mac and cannot seem to find the report manager that
Excel used to have--did it get removed for the 2008 version?

As an alternative, I formated each worksheet individually and then deleted the
sheets I did not want to print and tried printing workbook but it has all the
formatted pages incorrectly.

Any help appreciated.

Yes, the report manager is gone. It is based on VBA, and there is no VBA in
Office 2008. You'll have to give us more of a hint about the formatting.
What is not printing correctly? What is happening? Why do you think it is
wrong? Have you updated to the latest print drivers?
[/QUOTE]

Let me see if I can explain it. I have a worksheet with 30 individual sheets, each formatted differently. Some are landscape, some potrait, all have been selected with a Print Area and each one formatted to fit between 1 and 3 pages. If I print each page individually, they come out fine. But when I print Entire Worksheet, it seems to not fit the individual sheets to the pages as I have them set up, but perhaps take one formatting page's specs and apply them to all pages.

I wanted to do this in order to print to a PDF file all 30 pages continuously and effortlessly and then email the contents.

Thanks in advance.

 

[Bob Greenblatt]

Let me see if I can explain it. I have a worksheet with 30 individual sheets,
each formatted differently. Some are landscape, some potrait, all have been
selected with a Print Area and each one formatted to fit between 1 and 3
pages. If I print each page individually, they come out fine. But when I print
Entire Worksheet, it seems to not fit the individual sheets to the pages as I
have them set up, but perhaps take one formatting page's specs and apply them
to all pages.

I wanted to do this in order to print to a PDF file all 30 pages continuously
and effortlessly and then email the contents.

Thanks in advance.

So, you are saying that each worksheet prints properly when printed, but
when you check the "entire workbook" option in the print dialog, that the
formatting is ignored? If so, this certainly seems like a bug, but I have
not seen or heard of this before. Will it print properly, or is only the pdf
incorrect? If just the PDF, it is probably not an Excel problem, but an
Apple issue.

 

[jcoley2]

Bob, thanks for your response. I figured out why the printing was not formattting--turns out that there were some additional worksheets in there that I thought I had deleted and they were at the front of the tabs (and not formatted), so now, when printing, those sheets I wanted and formatted came out fine.

Now for problem #2 (if you can help me)--when I print then via PDF, each individual sheet comes up as an individual PDF document when using print Entire Worksheet. Is there a way to make it so that they are linked page by page (sort of like how the original report manager worked)?

 

[Bob Greenblatt]

Bob, thanks for your response. I figured out why the printing was not
formattting--turns out that there were some additional worksheets in there
that I thought I had deleted and they were at the front of the tabs (and not
formatted), so now, when printing, those sheets I wanted and formatted came
out fine.

Now for problem #2 (if you can help me)--when I print then via PDF, each
individual sheet comes up as an individual PDF document when using print
Entire Worksheet. Is there a way to make it so that they are linked page by
page (sort of like how the original report manager worked)?

As far as I Know, this has been an issue for a long time. There are plenty
of public domain utilities for combining the pdfs. Try a Google search.