+ Reply to Thread
Results 1 to 2 of 2

update the underlying data source of a pivot table

  1. #1
    Ben Hall
    Guest

    update the underlying data source of a pivot table

    is there any functionality to update or change the underlying data set using
    the pivot table itself. i.e. i have pivot table that consolidates a large
    budget, and want to update certain items in the pivot table display... can
    these changes be pushed back to the data set.

  2. #2
    Max
    Guest

    Re: update the underlying data source of a pivot table

    From a trawl through google archives,
    perhaps this J-Walk tip would be relevant:
    http://j-walk.com/ss/excel/usertips/tip068.htm
    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --
    "Ben Hall" <Ben [email protected]> wrote in message
    news:[email protected]...
    > is there any functionality to update or change the underlying data set

    using
    > the pivot table itself. i.e. i have pivot table that consolidates a large
    > budget, and want to update certain items in the pivot table display... can
    > these changes be pushed back to the data set.




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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