Combining pivot table with data and trying to sort it

Hi,

I have created a pivot table of data and next to it I have created some formula's based on the information in the pivot table and from another tab.

Now I have my table of new data (the pivot table and data combined) I want to be able to sort all of the information by the data so it also changes the pivot table order, but when I do this I get the following message:

"We can't make this change for the selected cells because it will affect a PivotTable. Use the field list to change the report. If you are trying to insert or delete cells, move the PivotTable and try again"

Can anyone help? I can't attach a copy of the spreadsheet as it is company information but if you need more info I might be able to create a mock version to hopefully show what I mean...

Hi,

Please post a sample template of your workbook here (mock version).

please see attached file. hopefully helps...
123.xlsx

Hi,

Can you not import the Pivot Table data as well into your table using VLOOKUP by keeping the Pivot Table in a different sheet?