Hi,

The best solution is to use Excel Explosion ...
the add-in is available at ...
http://www.datapigtechnologies.com/freeware.htm