Hi Folks.!
Report Manager Excel 2000 ignores my Views and prints entire sheet. I need to cancel docs to stop the printer.
I'm preparing my tax sheets and now I need to print. Before I use my live data, I set up a report named Rep1. I set up two views that are recognized in my report:
Sheet1,Viewa,(none) and Sheet1,Viewb,(none). When I "SHOW" these the ranges are highlighted correctly, and they are listed in that report.
I clicked "print..." in the report manager window and it takes me to the dialog window. 1 page and no pagecount are the options.
It starts to print the whole sheet.
Searching for a solution I went to the print options in the File menu. I thought maybe there could be a print report option that I had missed.
I searched in MS for Report manager issues (v9.0.2720), but none were reported.
I ensured my printer cache was empty, and that I wasn't printing some residual docs and none are present.
Any help will be appreciated.
AndyF