Did you check the "preserve formating" in the pivottable options?

Regarding the second questions you can add an additional button to your
excel. Go to View|Toolbars|Customize the go to Tab Commands, choose Data
and look for the "refresh data" button. You can drag this button to your
toolbar.

Regards,
Arien


--
Arien
------------------------------------------------------------------------
Arien's Profile: http://www.excelforum.com/member.php...fo&userid=1892
View this thread: http://www.excelforum.com/showthread...hreadid=533761