What you have pretty much described perfectly is a product called NPrinting! As you have found, the standard QlikView software isn't up to much in terms of distributing data, especially when it comes to nicely formatted Excel files.
The easiest thing to do is check out www.nprinting.com to get some more information about the product. From there you can download a 45 day free trial to test it out.
We're a reseller of the NPrinting product within the UK, so if you would like to get in touch for a quick training session, or some help with your product evaluation, we're happy to help!