Link to home
Start Free TrialLog in
Avatar of leblanc
leblanc

asked on

Excel Assignment Schedule template

I am using the Assignment Schedule template from Excel 2013. How do I edit the formula or content of the Assignment box (the pivot table) in the Assignment Detail worksheet. Thanks
Capture.JPG
Avatar of leblanc
leblanc

ASKER

Nobody can help me out?
Avatar of Patrick Matthews
That appears to be a Slicer, not a PivotTable...

In any event, posting images of your file is not tremendously helpful.  Posting the actual file would be much more useful.
Avatar of leblanc

ASKER

Sure. It comes with Excel. Here it is again (see attached). Also, I am having problem in changing the title of the column from Instructor to People. Each time I did that, when I clicked on refresh, the Instructor column disappeared. Thanks.
Assignment-schedule1.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Stacy Brown
Stacy Brown
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of leblanc

ASKER

Thank you for the fix. I see that each time I added a row with data in the Assignment Schedule tab, it updated the table in the Assignments Data tab with the refresh of the Assignment slider. What function linked the Assignment Schedule with the Assignment slider? I tried to start this spreadsheet from scratch and it did not update the data like this spreadsheet. Thanks
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial