Consulting

Results 1 to 3 of 3

Thread: I want to make change in data model in manage data model of powerpivot by vba code

  1. #1
    VBAX Newbie
    Joined
    Jul 2010
    Posts
    2
    Location

    I want to make change in data model in manage data model of powerpivot by vba code

    I am writing a code to create pivot table, i recorded a macro that create a pivot table but the change i make with manage data model are not recorded, so i have to make changes in data model manually in powerpivot manage data model, then again i recorded the rest of what a pivot table does.
    so i want a way to make changes in data model in VBA

  2. #2
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,014
    Location
    Create a workbook with three sheets; "Existing," Desired," and "PivotTable," to show us the Data Models

    Use the "Go Advanced" button, and at the bottom of that page, the "Manage Attachments" button to upload that workbook.
    I always expect the student to do their homework and find all the errrors I leeve in.

    Please take the time to read the Forum FAQ

  3. #3
    VBAX Newbie
    Joined
    Jul 2010
    Posts
    2
    Location
    I have attached file
    the first sheet existing
    the second sheet desired with pivot table
    In manage data model i have added CaculatedColumn with formula =[Award]>0
    The adding of this column is not recorded in record macro of excel
    I want to add this column by VBA
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •