+ Reply to Thread
Results 1 to 3 of 3

Pivot Table Issue

  1. #1
    Registered User
    Join Date
    05-10-2018
    Location
    Pennsylvania
    MS-Off Ver
    Office 365
    Posts
    43

    Pivot Table Issue

    Ever since my company switched to Office 365, the pivot tables in our excel files don't properly update. So, we add data into a sheet and the pivot table tied to it won't properly display the correct count. It may be a Name Manager issue but if I take the same range as the Name and change the pivot table Data Source to the range, it calculates properly but if I put in the Named Range it misses lines for some reason. This has only started a few months ago but since we have files with constantly changing data sizes, it can be frustrating to constantly update the pivot table range when the Named Range should do that on its own.

    Is anyone else having this issue and is there any way to fix this?

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Pivot Table Issue

    Does the 'Refers To:' window in the name manager dialog box show a dynamic formula or static range? Is it possible to upload a small desensitized sample?
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    Re: Pivot Table Issue

    You might also consider using Tables, which will resize automatically as you add data.
    Rory

+ 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. Pivot table issue, I'm not able to capture new data, when table is updated
    By johnnyq113 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-26-2015, 05:01 PM
  2. Pivot table issue
    By krishnaa_kumarr88 in forum Excel General
    Replies: 0
    Last Post: 10-20-2014, 10:40 AM
  3. pivot table issue
    By jedoob in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-19-2013, 03:08 PM
  4. [SOLVED] Pivot table issue
    By atlant15 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-18-2013, 08:29 AM
  5. Excel 2007 : Pivot Table Issue
    By manvirrr in forum Excel General
    Replies: 1
    Last Post: 10-14-2008, 07:05 AM
  6. Pivot table issue
    By 50pingviner in forum Excel General
    Replies: 0
    Last Post: 09-22-2006, 09:05 AM
  7. Pivot Table Issue NEED HELP
    By ketedford in forum Excel General
    Replies: 0
    Last Post: 04-20-2005, 10:10 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