Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Melbourne, Fl USA
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table Refresh (Excel 2003 sp1)

    I have no clue what I did to this pivot table that now will not let me refresh it. I have another pivot table that has the same layout and it isn't a problem. What did I do to this one and how can I fix it?

    Thanks in advance

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Pivot Table Refresh (Excel 2003 sp1)

    The source data is not in this workbook. It is in a different workbook (S:Employee InfoSAPESS 2006.xls). It is supposed to be this way?

    We can not refresh it, since we do not have access to the source data.

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot Table Refresh (Excel 2003 sp1)

    The source data for the pivot table appears to be 'S:Employee InfoSAP[ESS 2006.xls]Raw Data'!$A$7 so
    1) It is an external source
    2) There is something wrong - a single cell is not a valid source for a pivot table.

    To fix it:
    - Click in any cell of the pivot table
    - Select Data | PivotTable and PivotChart Report...
    - Click < Previous
    - Activate the Raw Data sheet.
    - Select the entire used range A1:L70.
    - Click Finish.

    The pivot table should now be OK again.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Melbourne, Fl USA
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thanks

    Thanks to you both. I was working with too many things at once and didn't realize this was a copy from another workbook. I changed the source and it's fine now.

Posting Permissions

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