| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table format changes when data is refreshed
Hi
As well as un checking Autoformat, you need to CHECK Preserve Formatting -- Regards Roger Govier "Bendinblues" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table format changes when data is refreshed
Roger,
Preserve Formatting is checked. When the pivot tables get refreshed, the column widths are retained, but I need to format columns with word wrap in order for me to be able to read all of the text. "Roger Govier" wrote: Hi As well as un checking Autoformat, you need to CHECK Preserve Formatting -- Regards Roger Govier "Bendinblues" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table format changes when data is refreshed
Hi
Yes I understand what you are saying. If I highlight the relevant cells on my PT, an choose Format cellsAlignmentword wrap and then set the PT options as described, my headings stay wrapped even after updating. What version on Excel are you using? -- Regards Roger Govier "Bendinblues" wrote in message ... Roger, Preserve Formatting is checked. When the pivot tables get refreshed, the column widths are retained, but I need to format columns with word wrap in order for me to be able to read all of the text. "Roger Govier" wrote: Hi As well as un checking Autoformat, you need to CHECK Preserve Formatting -- Regards Roger Govier "Bendinblues" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table format changes when data is refreshed
Now everything is real screwy! I'm using Excel 2003 SP3. If I choose relevant column and select word wrap, text wraps as expected. then when I select prerserve formatting, text goes back to unwrapped state, even before i refresh any data. What's going on? "Roger Govier" wrote: Hi Yes I understand what you are saying. If I highlight the relevant cells on my PT, an choose Format cellsAlignmentword wrap and then set the PT options as described, my headings stay wrapped even after updating. What version on Excel are you using? -- Regards Roger Govier "Bendinblues" wrote in message ... Roger, Preserve Formatting is checked. When the pivot tables get refreshed, the column widths are retained, but I need to format columns with word wrap in order for me to be able to read all of the text. "Roger Govier" wrote: Hi As well as un checking Autoformat, you need to CHECK Preserve Formatting -- Regards Roger Govier "Bendinblues" wrote in message ... 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table format changes when data is refreshed
Hi
My suspicion in SP3. I haven't loaded it yet. On my wife's machine, she had problems with Outlook after loading SP3. Restoring to a point before SP3 was loaded removed the problem. If you want to send me a copy of your file direct, I will load in on my SP2 version to see if it behaves OK. To mail direct roger at technology4u dot co dot uk Do the obvious with at and dots. -- Regards Roger Govier "Bendinblues" wrote in message ... Now everything is real screwy! I'm using Excel 2003 SP3. If I choose relevant column and select word wrap, text wraps as expected. then when I select prerserve formatting, text goes back to unwrapped state, even before i refresh any data. What's going on? "Roger Govier" wrote: Hi Yes I understand what you are saying. If I highlight the relevant cells on my PT, an choose Format cellsAlignmentword wrap and then set the PT options as described, my headings stay wrapped even after updating. What version on Excel are you using? -- Regards Roger Govier "Bendinblues" wrote in message ... Roger, Preserve Formatting is checked. When the pivot tables get refreshed, the column widths are retained, but I need to format columns with word wrap in order for me to be able to read all of the text. "Roger Govier" wrote: Hi As well as un checking Autoformat, you need to CHECK Preserve Formatting -- Regards Roger Govier "Bendinblues" wrote in message ... 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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table format changes when data is refreshed
it's on its way. i'll be coming from rmbrown at ukuzwana dot com.
"Roger Govier" wrote: Hi My suspicion in SP3. I haven't loaded it yet. On my wife's machine, she had problems with Outlook after loading SP3. Restoring to a point before SP3 was loaded removed the problem. If you want to send me a copy of your file direct, I will load in on my SP2 version to see if it behaves OK. To mail direct roger at technology4u dot co dot uk Do the obvious with at and dots. -- Regards Roger Govier "Bendinblues" wrote in message ... Now everything is real screwy! I'm using Excel 2003 SP3. If I choose relevant column and select word wrap, text wraps as expected. then when I select prerserve formatting, text goes back to unwrapped state, even before i refresh any data. What's going on? "Roger Govier" wrote: Hi Yes I understand what you are saying. If I highlight the relevant cells on my PT, an choose Format cellsAlignmentword wrap and then set the PT options as described, my headings stay wrapped even after updating. What version on Excel are you using? -- Regards Roger Govier "Bendinblues" wrote in message ... Roger, Preserve Formatting is checked. When the pivot tables get refreshed, the column widths are retained, but I need to format columns with word wrap in order for me to be able to read all of the text. "Roger Govier" wrote: Hi As well as un checking Autoformat, you need to CHECK Preserve Formatting -- Regards Roger Govier "Bendinblues" wrote in message ... 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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table format changes when data is refreshed
Hi Reggie
File received, sorted and returned. I don't think it was an SP3 issue, as I had a similar problem at first with SP2. The only thing that I can think was causing the problem, was the fact that you had Years and Year allocated to the PT, both of which were Grouped fields. Year was showing as he Month (quite independently of Month which you had allocated) as you cannot have Year with Years. I removed the Year field. I formatted Rows as Wrap TextVerticalTop and set the various column widths as appropriate. Now, it retains the wrap text on Refresh for me each time. I also removed Automatic Subtotal on most fields, as it seemed inappropriate and was just giving a more confusing appearance. -- Regards Roger Govier "Bendinblues" wrote in message ... it's on its way. i'll be coming from rmbrown at ukuzwana dot com. "Roger Govier" wrote: Hi My suspicion in SP3. I haven't loaded it yet. On my wife's machine, she had problems with Outlook after loading SP3. Restoring to a point before SP3 was loaded removed the problem. If you want to send me a copy of your file direct, I will load in on my SP2 version to see if it behaves OK. To mail direct roger at technology4u dot co dot uk Do the obvious with at and dots. -- Regards Roger Govier "Bendinblues" wrote in message ... Now everything is real screwy! I'm using Excel 2003 SP3. If I choose relevant column and select word wrap, text wraps as expected. then when I select prerserve formatting, text goes back to unwrapped state, even before i refresh any data. What's going on? "Roger Govier" wrote: Hi Yes I understand what you are saying. If I highlight the relevant cells on my PT, an choose Format cellsAlignmentword wrap and then set the PT options as described, my headings stay wrapped even after updating. What version on Excel are you using? -- Regards Roger Govier "Bendinblues" wrote in message ... Roger, Preserve Formatting is checked. When the pivot tables get refreshed, the column widths are retained, but I need to format columns with word wrap in order for me to be able to read all of the text. "Roger Govier" wrote: Hi As well as un checking Autoformat, you need to CHECK Preserve Formatting -- Regards Roger Govier "Bendinblues" wrote in message ... 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? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table format changes when data is refreshed
Roger,
Thanks for sorting this out. You uncovered another problem I am having w/ year/years/month that I'll start another thread with. thanks "Roger Govier" wrote: Hi Reggie File received, sorted and returned. I don't think it was an SP3 issue, as I had a similar problem at first with SP2. The only thing that I can think was causing the problem, was the fact that you had Years and Year allocated to the PT, both of which were Grouped fields. Year was showing as he Month (quite independently of Month which you had allocated) as you cannot have Year with Years. I removed the Year field. I formatted Rows as Wrap TextVerticalTop and set the various column widths as appropriate. Now, it retains the wrap text on Refresh for me each time. I also removed Automatic Subtotal on most fields, as it seemed inappropriate and was just giving a more confusing appearance. -- Regards Roger Govier "Bendinblues" wrote in message ... it's on its way. i'll be coming from rmbrown at ukuzwana dot com. "Roger Govier" wrote: Hi My suspicion in SP3. I haven't loaded it yet. On my wife's machine, she had problems with Outlook after loading SP3. Restoring to a point before SP3 was loaded removed the problem. If you want to send me a copy of your file direct, I will load in on my SP2 version to see if it behaves OK. To mail direct roger at technology4u dot co dot uk Do the obvious with at and dots. -- Regards Roger Govier "Bendinblues" wrote in message ... Now everything is real screwy! I'm using Excel 2003 SP3. If I choose relevant column and select word wrap, text wraps as expected. then when I select prerserve formatting, text goes back to unwrapped state, even before i refresh any data. What's going on? "Roger Govier" wrote: Hi Yes I understand what you are saying. If I highlight the relevant cells on my PT, an choose Format cellsAlignmentword wrap and then set the PT options as described, my headings stay wrapped even after updating. What version on Excel are you using? -- Regards Roger Govier "Bendinblues" wrote in message ... Roger, Preserve Formatting is checked. When the pivot tables get refreshed, the column widths are retained, but I need to format columns with word wrap in order for me to be able to read all of the text. "Roger Govier" wrote: Hi As well as un checking Autoformat, you need to CHECK Preserve Formatting -- Regards Roger Govier "Bendinblues" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formats of pivot tables changes when data is refreshed | Excel Discussion (Misc queries) | |||
| Pivot Table to be refreshed whenever the web query is being refres | Excel Discussion (Misc queries) | |||
| how do I format data into columns using a pivot table report? | Excel Discussion (Misc queries) | |||
| Is there a way to compare a pivot table refreshed data to old one | Excel Discussion (Misc queries) | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
