+ Reply to Thread
Results 1 to 2 of 2

Power Pivots not updating properly

  1. #1
    Registered User
    Join Date
    11-15-2021
    Location
    buenos aires
    MS-Off Ver
    Office 365
    Posts
    1

    Power Pivots not updating properly

    Hi! I have a problem that came up a couple of weeks ago.
    I am working with a data model that basically relates sales with different data masters. For example, Month, area, brand, etc..
    The thing is that when I update de data model in Power Pivot screen the pivot tables that feed from the model remains static and also not responding to the selections I wan to make. For example if I want to select a month.

    I'd searched everywhere and I am not finding any solution for this..

    What are your thoughts??? Pleas heeeeelp

  2. #2
    Forum Contributor
    Join Date
    10-14-2020
    Location
    Shanghai
    MS-Off Ver
    O365
    Posts
    156

    Re: Power Pivots not updating properly

    Hi

    I am facing the same issue. I found out that something is wrong or was damaged in the Datamodel or the power pivot tables i am using. In my case, I was deleting one by one the power pivots and suddenly it worked again.
    So i assume, one of your pivots is damaged, find it and then it will work.

    My issues now is, i can not add new pivots anymore or connect them with my slicers. Therefore I decided to rebuild the whole dashboard once the final layout and content is set up.

    Overall, without example its difficult to help you as there are many reasons (slicers, filter set, missing data,....)

    good luck

+ 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. Structuring data to create power pivots
    By gwoolley0302 in forum Excel General
    Replies: 4
    Last Post: 11-21-2019, 12:33 AM
  2. Replies: 0
    Last Post: 04-05-2018, 01:16 AM
  3. Grouping Data in Power Pivots
    By kersplash in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-16-2018, 03:28 AM
  4. [SOLVED] Updating Tables From Pivots
    By WinterTT in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-07-2017, 06:42 PM
  5. Can I use Power Query to pull from Pivots in multiple workbooks?
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2016, 10:24 AM
  6. Updating all pivots when opening workbook
    By JoFo in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-23-2008, 11:26 AM

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