Pivot table not updating
If there is a pivot field to the left of the field that you are sorting, the sorting is restricted by that outer field.
The labels or values are only sorted within each of the items in the outer field -- the sorting does not occur overall.
The Office Open XML Formats are based on XML and ZIP archive technologies.
However, unlike legacy files, Office Open XML Formats files can be opened to reveal component parts that give you access to the structures that compose the file.
Rather than using copy and then paste values, however, a better way for many purposes is to create some hidden columns or a whole hidden sheet that copies values using simple formulae.
When the A-Z button is clicked, the Orders values are sorted in ascending order.In the screen shot below, the Product field is in the row area, and a product name is selected, in cell A5.When the Z-A button is clicked, the product names are sorted in descending order.In the screen shot below, the Product field is in the row area, and the Category field is to its left, as an Outer field.The Product quantity in cell C5 is selected, and when the A-Z button is clicked, the Qty values are sorted in ascending order -- within each Category.