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