+ Reply to Thread
Results 1 to 2 of 2

Pivot table will not displays rows when run on macro

Hybrid View

  1. #1
    Registered User
    Join Date
    11-04-2016
    Location
    Dallas, TX
    MS-Off Ver
    2010
    Posts
    1

    Pivot table will not displays rows when run on macro

    I have a monthly report I run each month. The data is always in the same format but the data and amount of data is always different. I created a pivot table to provide me with a simple count - types of new customers and the number of that type of customers. When I created the macro everything worked great it provided me with a list of new customer types, broke it down for me, and gave me the grand total. However when I run the macro all i get is the table with the grand total. What am I doing wrong?

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,333

    Re: Pivot table will not displays rows when run on macro

    Hey sism,

    It is tough to know without seeing a workbook. You might not be displaying the information because you have filtered out all the rows, or you may not be getting the data from a full pivot table, or you simply might need to REFRESH the pivot after importing new data. Here are the instructions to attach a file.

    To Attach a File:

    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. missing pivot table rows when macro is run
    By BigDingo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-25-2016, 11:49 AM
  2. [SOLVED] Excel offers no recommended charts nor displays pivot table data
    By shellataylor in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-19-2016, 08:22 PM
  3. Replies: 1
    Last Post: 06-09-2015, 01:44 AM
  4. Sorting a Pivot Table thats displays Running Totals
    By Jabba69 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-11-2014, 05:58 AM
  5. Replies: 7
    Last Post: 02-14-2013, 01:32 PM
  6. Pivot table which displays only the total for some of the fields
    By moty.98 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-13-2013, 03:10 PM
  7. [SOLVED] Pivot table displays data differently, Excel 2003
    By Perkyleo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2005, 12:40 PM

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