Results 1 to 10 of 10

pivot table not updating after entering figures into data set.

Threaded View

  1. 04-06-2020, 05:45 AM #1
    jitterbug888
    jitterbug888 is offline
    Forum Contributor
    Join Date
    04-01-2015
    Location
    Sydney Australia
    MS-Off Ver
    Office 365 latest
    Posts
    171

    pivot table not updating after entering figures into data set.

    Help!

    I created this pivot table on the 2nd sheet, to fill up when data is entered on the first sheet (date, invoice amount), but on entering data into the database, the pivot table doesnt seem to update even after CTRL ALT F5 or Refresh all...

    Normally the pivot table updates after refreshing and the chart fills up. Can you help me fix this please?

    kind regards,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate Field in pivot table not updating when adding new data into a table range
    By Debron101 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-05-2019, 03:47 AM
  2. [SOLVED] Need Help Updating Pivot Table Source Data
    By walt737 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-25-2019, 08:27 AM
  3. [SOLVED] Updating the source data of a Pivot Table
    By AhmedAbdelhai in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-28-2018, 05:13 AM
  4. [SOLVED] Pivot table not updating when using data validation
    By aimone111 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2015, 09:56 AM
  5. Problems updating Pivot Table with new data
    By Andres007 in forum Access Tables & Databases
    Replies: 1
    Last Post: 07-30-2014, 09:39 AM
  6. Help with Pivot table data updating issue
    By lgc.fico in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-24-2013, 10:56 PM
  7. [SOLVED] Updating source data while in Pivot Table
    By Carim in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2005, 10:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1