#1   Report Post  
macdva094
 
Posts: n/a
Default Refresh Option

In Excel HelpIndexRefresh, Refresh data in a PivotTable or PivotChart
Report. Is there a fix for lost Formatting?
  #2   Report Post  
aristotle
 
Posts: n/a
Default

Hi,

Right click the pivot table and go to table options. You should be able to
choose "preserve formatting" amongst the options.

Regards,
A
--
Please rate my response if you found it helpful. Thanks.


"macdva094" wrote:

In Excel HelpIndexRefresh, Refresh data in a PivotTable or PivotChart
Report. Is there a fix for lost Formatting?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable Query Refresh warning dialog box in Excel 2003 Jeff Koons Excel Discussion (Misc queries) 2 December 1st 05 04:08 PM
SQL - Auto Refresh Upon Cell Value Change Elliot J Excel Worksheet Functions 1 May 12th 05 10:22 AM
Excel instance used with "Export to Microsoft Excel" option in Internet Explorer Karl Schweitzer Excel Discussion (Misc queries) 0 April 7th 05 06:17 PM
Second option button disappears when I make another column Monique Excel Worksheet Functions 0 March 9th 05 09:57 PM
Filter option vishu Excel Discussion (Misc queries) 1 February 28th 05 01:36 PM


All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"