I've searched the forum, learned about setting the font style in slide master view. I find that helps simplify managing the tables, and drives use of consistent reporting measures across multiple pivot tables sharing the same source data.In SL2 (current as of today) when I cut/copy and paste text I can't get SL to retain the Font style nor size of the source text?

Yes, even the 'Sum of', 'Count of', etc simple types of measures that don't require a formula to define.

I typically define 'Measures' in Power Pivot for all the quantities that might appear in the PivotTable. That way, when Value columns are moved their formatting moves with them. Apply Conditional Formatting for each Value to the entire PivotTable. and set up the desired numeric format as usual. Choose values for X and Y that ensure your Value field is always in that range. Edit the Ruel Description to Format only cells with cell values between X and Y. Select the Rule Type 'Format only cells that contain'. should show the name of the numeric Value you want to display (second button). Click on a column with a numeric field, and apply conditional formatting based on the field, as shown in the figure. I'm using PowerPivot in what I describe below. More specifically, apply Conditional Formatting for all numeric Values (columns) used in the PivotTable. I found a consistently robust solution: Apply conditional formatting based on the names of the Fields used in your PivotTable. If the refresh results in new rows being added to the PivotTable, then you will still need to format those, unless you are using an AutoFormat. Now, when you refresh the PivotTable, your previously applied formatting should remain on rows and columns previously in the PivotTable. Make sure the Preserve Cell Formatting On Update check box is selected.The Layout & Format tab of the PivotTable Options dialog box. Make sure the Layout & Format tab is displayed.Excel displays the PivotTable Options dialog box. Click the Options tool in the PivotTable group.Format the PivotTable in whatever way desired.Make sure that your PivotTable displays the values you want.The way around this is to follow these steps: You see, when you update the data on which the PivotTable is based, and then refresh the PivotTable, all your formatting work may go away. Once you have the PivotTable displaying the values you need, you can then format the table to make the data presentable-for a while. PivotTables provide a great way to analyze large amounts of data and pull out the summarizations that you need.

Dont see keep source formatting word