Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Excel Assignment Schedule template

Posted on 2013-10-28
Medium Priority
Last Modified: 2013-11-12
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
Question by:leblanc
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Author Comment

ID: 39607053
Nobody can help me out?
LVL 93

Expert Comment

by:Patrick Matthews
ID: 39608254
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.

Author Comment

ID: 39608410
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.
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

LVL 14

Accepted Solution

Stacy Brown earned 2000 total points
ID: 39608884
The data is changed by changing it on the Assignment Schedule Tab

You can change the slicer settings by right clicking the title area of the slicer and then choosing Slicer Settings.  You can also Clear Filters and Refresh all with a Right-click.

If you rename the Instructor field People on the Assignment Schedule Tab you then need to reselect PEOPLE as a field to be displayed and then in the ROW area Right-click People and choose move to the beginning.

I hope this helps.  See the modified attachment

Author Comment

ID: 39609321
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
LVL 14

Assisted Solution

by:Stacy Brown
Stacy Brown earned 2000 total points
ID: 39609466
It seems to be a pivot table with slicers added at the end.  So your main grid (People through Progress) is the pivot table.  The little mini-tables (Assignments through Courses) are the slicers.  The Pivot Table was made first then the rest.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

660 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question