+ Reply to Thread
Results 1 to 2 of 2

How can I update Source Data in Pivot Table

  1. 08-19-2019, 04:31 PM #1
    nebelnes
    nebelnes is offline
    Registered User
    Join Date
    08-19-2019
    Location
    St. Louis
    MS-Off Ver
    2016
    Posts
    1

    How can I update Source Data in Pivot Table

    Hello,

    Can someone please let me know if it is possible to enter values in pivot table so that my source data gets updated?
    For instance I created an empty column in the source data and I want to enter values in Pivot Table. Is it possible?

    thank you in advance!
    Reply With QuoteRegister To Reply
  2. 08-20-2019, 02:33 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: How can I update Source Data in Pivot Table

    Does this help ? https://www.contextures.com/xlPivot01.html
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Can I update data source from pivot table?
    By elbrujo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-02-2016, 10:25 PM
  2. using VBA to update a pivot table data source
    By bzl in forum Excel General
    Replies: 1
    Last Post: 06-03-2015, 04:38 PM
  3. Changing data source to update pivot table
    By jonesli in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-07-2014, 01:48 AM
  4. Update source data from pivot table
    By bryanbak3 in forum Excel General
    Replies: 0
    Last Post: 01-12-2012, 05:28 PM
  5. vba code to Update Pivot Table source data
    By ker9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2010, 04:37 PM
  6. [SOLVED] can I use a pivot table and update my source data (like Hyperion)
    By AK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2006, 02:55 PM
  7. update the underlying data source of a pivot table
    By Ben Hall in forum Excel General
    Replies: 1
    Last Post: 12-07-2005, 03:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1