Publish to Excel BI report doesn't respect defined Print Area

SOLVED

I have a multi page BI financial where i have defined the print area.   When I publish the report to excel it publishes everything on that worksheet and not just the defined print area.  Is there any work around for this?  I would use PDF but the problem with PDF is each sheet goes to a separate PDF