Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Convert a Pivot Table to a Table? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Most of our reports are 2d spreadsheets. Currently MS Project Server and Excel Services only allows us to build OLAP cubes and open the data through Excel in a Pivottable. Is it possible, without purchasing Excel 2010, to convert a pivot table into a table?

    I want all tasks with Start, Finish, Workload, Unit of measure, technology, and quite a few other custom fields as column headers. I just can't stand pivot tables!!

    Thursday, June 30, 2011 2:49 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Did you try using Paste Special >> Paste Values, when copy pasting the Pivot table into a new sheet. That should remove all formatting and paste it as a standard text.

    As for diaplaying all data as columns, you need to right cliick in the Pivot tabel area, select Pivot Table Options >> DIsplay tab >>and select CLassic Pivot table style.

    Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com
    Thursday, June 30, 2011 8:31 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Just copy the row and column data from the pivot table to a new worksheet.   It is then flat.

    cheers!

    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
    www.WhartonComputer.com
    Thursday, June 30, 2011 3:00 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    All tasks are collapsed? They have to be expanded manually I believe? I tried copying and pasting into a new worksheet, and it just puts the data in with the expand/collapse option.

    Also whenever adding another field to the pivottable, it puts the data in a new ROW under the one column within the table (Column A) Everything is just collapsed below the project. I don't want this, I want the data in cells next to each task in another column.

    Thursday, June 30, 2011 4:52 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Did you try using Paste Special >> Paste Values, when copy pasting the Pivot table into a new sheet. That should remove all formatting and paste it as a standard text.

    As for diaplaying all data as columns, you need to right cliick in the Pivot tabel area, select Pivot Table Options >> DIsplay tab >>and select CLassic Pivot table style.

    Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com
    Thursday, June 30, 2011 8:31 PM