Share via

How to Convert Pivot Table to Normal Table

Anonymous
2017-08-22T12:00:26+00:00

Hi,

I have arranged a pivot table to spit out rates which I have linked to another table. Problem is I need to manually change some of these rates but my data is linked to the pivot and if I cut/paste I will mess up the dependant cells. I need to convert the pivot so that it becomes a regular table and the rates stay in the same cells so I can edit.

I wanted to try OLAP to convert the pivot to formulas but the button is grey. Any suggestions?

**Post moved / split by the moderator to the appropriate forum category / another thread

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-09-07T22:49:11+00:00

    Copy and then paste special...values.

    3 people found this answer helpful.
    0 comments
  2. Ashish Mathur 100.8K Reputation points Volunteer Moderator
    2017-09-07T23:19:42+00:00

    Hi,

    You can convert your Pivot Table into CUBE formulas only when you build a Pivot Table from the data model i.e. PowerPivot.

    0 comments