M
MC AdminTS
I have encountered a rather unusual problem with MS Excel
2000 when printing a multi-tab spreadsheet. If each tab
has a different page orientation such that the first 2 are
landscape then one is portrait then the next 4 are
landscape. When printing this spreadsheet the document
comes out like normal except for the 2 pages after the
portrait page are cut off as if they were portrait and not
landscape. The print is still orientated on the page as
if it were landscape and the page comes out landscape,
however, the printing stops at the edge of what would be
considered a portrait page. The rest of the workbook
prints fine. This only happens when printing the entire
workbook. If printing each tab individually, then
everything prints correctly.
If I move the 2 tabs after the portrait tab to the end of
the list then the document prints fine. This is not a
viable solution since the tab order is very important.
The spreadsheet is extremely complex with links and macros
so it is not an option to just copy and paste a tab to
another tab without adding weeks of work to the project.
The solution that I found was to switch the one portrait
sheet to landscape and then everything printed fine. Does
Excel not support printing a full workbook with different
page orientation?
This is not a print driver issue because the same issue
happens when I print to multiple other printers with
different types of drivers.
Any advice would be appreciated.
2000 when printing a multi-tab spreadsheet. If each tab
has a different page orientation such that the first 2 are
landscape then one is portrait then the next 4 are
landscape. When printing this spreadsheet the document
comes out like normal except for the 2 pages after the
portrait page are cut off as if they were portrait and not
landscape. The print is still orientated on the page as
if it were landscape and the page comes out landscape,
however, the printing stops at the edge of what would be
considered a portrait page. The rest of the workbook
prints fine. This only happens when printing the entire
workbook. If printing each tab individually, then
everything prints correctly.
If I move the 2 tabs after the portrait tab to the end of
the list then the document prints fine. This is not a
viable solution since the tab order is very important.
The spreadsheet is extremely complex with links and macros
so it is not an option to just copy and paste a tab to
another tab without adding weeks of work to the project.
The solution that I found was to switch the one portrait
sheet to landscape and then everything printed fine. Does
Excel not support printing a full workbook with different
page orientation?
This is not a print driver issue because the same issue
happens when I print to multiple other printers with
different types of drivers.
Any advice would be appreciated.