The only way I would of thought to do that, would be to have a subscription which runs the report and exports to excel and saves it on a file share.

Don't think you can get it to open dynamically in excel.