Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: PivotTable saved without underlying data (XL97)

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Irvine CA
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can I make sure my pivot tables are saved WITH underlying data.
    Sometimes I get the following message when trying to use my pivot tables:
    "PivotTable saved without underlying data. Use the Refresh Data command to update the PivotTable."
    I cannot figure out why some of my pivot tables ARE saved with the underlying data and some ARE NOT.
    (I am aware of the "Refresh on open" setting but am still hoping for an answer to the above.)
    Please help.
    Coreen

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you right click the pivot table and choose Table Options. There is an option Save Data with Table Layout in the data source options. That needs to be checked.

    HTH,
    D

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Irvine CA
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you very much, DK. That solved my problem! (^_^)

  4. #4
    New Member Data Bender's Avatar
    Join Date
    Oct 2013
    Location
    Music Capital
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: PivotTable saved without underlying data (XL97)

    This helped me too (on Excel 2010)! Thanks, dk.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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