Would it be possible to elaborate a little on this process using the
sumproduct table. I checked out the sumproduct funtion and understand it but
I don't see how I proceed to used this to "replace" the pivot table.
Any additional info would be greatly appreciated.
thanks!
Jugglertwo

"robert111" wrote:


replace the pivot table with a sumproduct table, then formatting is
fixed forever.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=569780