LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Pivot Table format changes when data is refreshed

I have 12 copies of the same pivot table that keep changing when the data is
refreshed. I unchecked the autoformat as soemone has suggested. The column
widths retain their desired width after the refresh. However, I am still
required to format the column with word wrap in order to be able to read
what's in one of the the columns. Isn't there a way that i can eliminate this
extra step?
 
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
Formats of pivot tables changes when data is refreshed Bendinblues Excel Discussion (Misc queries) 2 October 17th 07 12:40 PM
Pivot Table to be refreshed whenever the web query is being refres Vicky Excel Discussion (Misc queries) 0 July 16th 06 10:28 AM
how do I format data into columns using a pivot table report? snd Excel Discussion (Misc queries) 1 April 24th 06 09:01 PM
Is there a way to compare a pivot table refreshed data to old one Wes Excel Discussion (Misc queries) 1 July 6th 05 05:34 PM
How can deleted data reappear in a refreshed pivot table in Excel excel_user123456 Excel Discussion (Misc queries) 3 February 23rd 05 08:34 PM


All times are GMT +1. The time now is 01:24 AM.

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

About Us

"It's about Microsoft Excel"