+ Reply to Thread
Results 1 to 3 of 3

Pivot Tables - Can I get back to my original Data

  1. #1
    Registered User
    Join Date
    08-23-2004
    Posts
    4

    Pivot Tables - Can I get back to my original Data

    I have a pivot table but have lost my original data.

    What can I do to see the data in the original format (i.e. before I put it into a pivot table)

    Thanks

  2. #2
    Forum Contributor
    Join Date
    12-02-2004
    Location
    London
    Posts
    255
    You could make sure that all page fields are displayed as all, no fields are hidden, make sure you have a Grand Total at the bottom of your pivot table and simply double click on this total, your original data should be displayed. There are two exceptions to this 1) If you have the option Save data with table unchecked you won't be able to drill down on the data or 2) The total number of rows of data exceeds 65,536 (the maximum rows of data in a sheet

  3. #3
    Registered User
    Join Date
    08-23-2004
    Posts
    4
    You are a star

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1