+ Reply to Thread
Results 1 to 1 of 1

Pivot Table : Can't change source range

  1. #1
    Registered User
    Join Date

    Pivot Table : Can't change source range

    Hello and thanks in advance for your help...

    The attached file has almost 300 rows of data but the Pivot Table is only showing 143 rows worth of data. I need to edit the pivot table source code to include the added rows. Can you help? PS. I pased in the Online Help text that I found on this problem. My back button is not available (see underlined text below) but my data was just pasted in; it was not OLAP. Is there a way I can tell the Pivot Table to include all rows. I don't want to have to re-create all the individual pivot tables... Thanks much!!!


    Exce's Help text:

    "Select different source data for a PivotTable or PivotChart report"

    If you returned data from an Office Data Connection file (.odc extension) directly to a PivotTable report, or your report is based on OLAP source data, you cannot use different source data in the report.
    1. Click the PivotTable report. For a PivotChart report, click the associated PivotTable report.
    2. On the Data menu, click PivotTable and PivotChart Report
    3. In step 3 of the wizard, click Back.
    If the Back button is unavailable, your report is based on OLAP data, and you cannot change it to use different source data. If you want a report based on a different OLAP cube (cube: An OLAP data structure. A cube contains dimensions, like Country/Region/City, and data fields, like Sales Amount. Dimensions organize types of data into hierarchies with levels of detail, and data fields measure quantities.), create a new report.
    4. In step 2 of the wizard, notice whether the report is based on an Microsoft Excel range (the step has an edit box labeled Range or external data (the step has a Get Data button), and then do one of the following:
    Specify a different Excel range
    1. If the data you want is on a different worksheet, click the worksheet.
    2. Select the new source data range.
    Specify different external data
    3. Click Get Data.
    4. In Microsoft Query, make changes to the query. For help with the specifics of changing the query, see Help in Microsoft Query.
    5. On the Query File menu, click Return data to Microsoft Excel.
    5. Click Finish.
    6. Drag any new fields that you want to display from the PivotTable Field List window onto the report.
    Note After you make this change to a PivotChart report or its associated PivotTable report, some chart formatting may be lost.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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