sparky2205
Active Member
- Joined
- Feb 6, 2013
- Messages
- 481
- Office Version
- 365
- 2016
- Platform
- Windows
Background:
I have an issue with formatting on a PivotTable.
The row labels are long so the text orientation is set at 60 degrees.
Preserve formatting is selected in options.
The spreadsheet is a template which is used to produce data for a number of processes.
The issue:
The behaviour of the above formatting in the template is irregular when used repeatedly.
i.e. sometimes only the first two columns will have the formatting applied, sometimes more.
When I update the template with new information and Refresh I get a message that the PivotTable already contains information even though the PivotTable itself is blank. I saved the template without the source data in an attempt to start with a clean PivotTable.
But whatever I have tried so far the formatting is still not applied to all columns after a refresh.
Any help would be appreciated.
I have an issue with formatting on a PivotTable.
The row labels are long so the text orientation is set at 60 degrees.
Preserve formatting is selected in options.
The spreadsheet is a template which is used to produce data for a number of processes.
The issue:
The behaviour of the above formatting in the template is irregular when used repeatedly.
i.e. sometimes only the first two columns will have the formatting applied, sometimes more.
When I update the template with new information and Refresh I get a message that the PivotTable already contains information even though the PivotTable itself is blank. I saved the template without the source data in an attempt to start with a clean PivotTable.
But whatever I have tried so far the formatting is still not applied to all columns after a refresh.
Any help would be appreciated.