+ Reply to Thread
Results 1 to 1 of 1

Pivot data and report data not updating as I would like

  1. #1
    Registered User
    Join Date
    02-14-2019
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    2

    Question Pivot data and report data not updating as I would like

    Sir, Ma'am, Team,

    I have an excel spreadsheet with a dashboard and simple queries use for reporting, when I have 1 of each risk level VH, H, M L and VL, my dashboard will work, however, as it is a Pivot Chart, if one or more of the risk levels do not exist, it then upsets all of my figures. I do not have the correct knowledge to fix this (attached is my spreadsheet). There are hidden tabs.

    Additionally, the report tables which use queries do not update, I would all of my data to update when it changes, on load, close or change of cell data, this does not occur, even when I manually update the whole data base by selecting Data, update all. I may need to change the Table cell names in the future will this be hard to fix if the referencing is messed up?

    Could I please ask someone to review the spreadsheet and fix my issues - I have tried, if then statements even just using one graph representing the Risk Levels but the total still would not work,

    Any help for this excel simple user would be appreciated.

    Mick

+ 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. Need help with separating data on a Pivot report
    By reddwarf in forum Excel General
    Replies: 8
    Last Post: 01-15-2019, 10:17 PM
  2. Replies: 2
    Last Post: 01-11-2018, 10:10 AM
  3. "Problem Obtaining Data" error while loading Pivot Report with huge amount of data
    By mvmkandan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2015, 07:02 AM
  4. [SOLVED] Updating data for Pivot Tables
    By maxashton in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-19-2012, 09:57 AM
  5. Replies: 0
    Last Post: 09-01-2011, 04:25 PM
  6. Pivot Tables and VBA: Changing Contents in Data Area and updating the Data Source
    By kyrgyzstanart in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2011, 11:11 AM
  7. Replies: 0
    Last Post: 07-27-2005, 06:05 PM

Tags for this Thread

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