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
Capture.JPG
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.
In any event, posting images of your file is not tremendously helpful. Posting the actual file would be much more useful.
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
Assignment-schedule1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER