00154e7628d-5cac-4809-b9a5-a6f5cf4dabb0-0 Welcome to this demonstration of option one, 54e7628d-5cac-4809-b9a5-a6f5cf4dabb0-1 manually updating the pivot table data sources. f4302943-7322-4842-9b97-35f57afda739-0 This video provides a clear step by step demonstration of the update process. e438f01b-9ee3-4d1b-bca2-4d4874c29572-0 Its purpose is to visually guide users through each action, e438f01b-9ee3-4d1b-bca2-4d4874c29572-1 confirm the correct sequence of steps, and support accurate implementation of e438f01b-9ee3-4d1b-bca2-4d4874c29572-2 the Student Support Referral Tool updates. 735eb21a-9f6e-4b91-be05-2d44f9f2122d-0 Users are encouraged to view the entire demonstration before completing the 735eb21a-9f6e-4b91-be05-2d44f9f2122d-1 written steps to ensure confidence and accuracy when performing the required 735eb21a-9f6e-4b91-be05-2d44f9f2122d-2 tasks. b6111971-9212-4ac6-840f-b958436e4eec-0 Let's start by making a copy of our existing Student Support Referral b6111971-9212-4ac6-840f-b958436e4eec-1 Tracking tool. 18706787-ad5d-47ed-b4b5-5f1df84f356c-0 This ensures that we have a complete and accurate data set in the event that the 18706787-ad5d-47ed-b4b5-5f1df84f356c-1 data becomes corrupted during the following steps. 6e3bd097-62b6-45b0-96f0-14983a58f3b6-0 Now let's open the tool to update the Pivot Table data sources.
002665cb2b6-d27c-48fa-a24e-3060cf726801-0 Navigate to the Queue 2 Counts New Referrals tab. cb1d9804-c0a1-4c5d-83d1-567247feaa84-0 Locate the pivot tables. 9dd8222f-af1c-4dd7-b98d-fd4534092647-0 They are these colored areas on the worksheet. 1e93e949-d960-4b85-b2e7-bb536a3bbe43-0 Click directly inside the Pivot table area to activate the Pivot Table tools. 9f9233fa-8248-40e2-bb26-b1aeaecc0c9a-0 Selecting any cell within the pivot table allows Excel to recognize it. aa9897b0-0b85-4429-b5b7-dd661ff58f86-0 Navigate to the Pivot Table Analyze tab at the top of the screen and select aa9897b0-0b85-4429-b5b7-dd661ff58f86-1 Change Data Source. c65e81e7-3ab4-456a-a0ed-272af1024612-0 In the dialogue box. 9312593b-64a0-4a91-8ae8-95a1ae70f2c5-0 Place the cursor in front of the one in Queue one. 3d813c9d-2e4b-4dd7-9948-278864f20fbb-0 Delete the 1:00 and replace it with two. 455dc63a-ff5c-47a4-82b6-849efc31e33e-0 Do not change any other characters. f71c3025-b888-465d-977f-626b498cc8fa-0 Click on the next pivot table and select Change Data Source. dfa38359-4e2f-493c-9cbe-b5e27c8e9332-0 In the dialogue box. 2147a359-7e9c-47ba-a006-de6376b417e8-0 Replace the one with two. ef09989d-2412-4076-8cfa-a92dedd53bbb-0 Do not change any other characters. ecf971c9-ca61-4a88-98d2-b3414aaad2d9-0 Click on the next pivot
003table and select Change Data Source. 18906c7d-5039-4cc4-8f3c-9dac2cf6415b-0 In the dialogue box, replace the one with two, 18906c7d-5039-4cc4-8f3c-9dac2cf6415b-1 Do not change any other characters. 6cf5592a-4ed9-46e5-bd49-dbda3f50e02a-0 Click on the next pivot table and select Change Data Source. a35212e6-1258-488f-9e7b-16b1d8fa4dc1-0 In the dialogue box, replace the one with two. afdadddf-f52a-4a15-93fd-9bcc259352c5-0 Do not change any other characters. 6d89fd95-4a23-4648-b004-32bdb889b39a-0 Click on the next pivot table and select Change Data Source. 9090e427-f271-48b3-9135-371a9e3ba087-0 In the dialog box, replace the one with two. 900dac39-b7c3-4b25-ad94-3a228c858830-0 Do not change any other characters. 7948e725-fd27-40e1-b0f0-362a4ec77d03-0 Click on the next pivot table and select Change Data Source. 5eb7acf8-2b03-441a-b5b0-a77f294a06bc-0 In the dialog box, replace the one with two. 3aafc994-0b48-406a-b85c-89c6c15e4de9-0 Do not change any other characters. 1745f694-83b7-462c-a4a1-7ac09b5cd38a-0 If necessary, slide the scroll bar to expose the next 1745f694-83b7-462c-a4a1-7ac09b5cd38a-1 pivot table. 2ded2dc8-7b08-4d77-ad5e-a76d6ca2bbb6-0 Click on the next pivot table and select Change Data Source. f28d5db4-b616-443d-8eb6-cb6a0c03b5d4-0 In the dialogue
004box, replace the one with two. 6f477d2b-eba4-4381-aafb-d5eb537f9f57-0 Do not change any other characters. 591810ea-2053-4dff-b667-ac3e02e68132-0 Slide the scroll bar back and Scroll down to the last pivot table. a23ca831-1146-4781-9480-2834909f824f-0 Click on the pivot table and select Change Data Source. 7c8123c7-41df-4989-b9b7-20eb46ca04e9-0 You will notice that this dialogue box looks different. 396a8492-5c80-49bd-a67c-968556f93192-0 It shows SY 25 instead of Q1. 596bd075-8ca0-46d9-ab35-f421aa72f72c-0 Place the cursor behind the five. e89b9da0-3b9e-492c-9f23-c2da0e06e833-0 Delete the 52Y and S and replace with Q2. 3d907c96-d077-4ead-9552-5aabbe17b83e-0 Navigate to the top of the page and click Refresh, 3d907c96-d077-4ead-9552-5aabbe17b83e-1 then Refresh All to update the data in the pivot tables. 17ceb9a8-7b9a-4875-9280-40af1cdb38bc-0 Click on the tab for Q3 counts, New Referrals and repeat the process of 17ceb9a8-7b9a-4875-9280-40af1cdb38bc-1 updating the data source for each pivot table, replacing the one with three. efae0c25-367e-4f17-a297-6692e7b2c2bd-0 On the last pivot table, replace SY 25 with Q3. 3482d672-2a67-4a39-a7a7-7e58b19af558-0 Click on the
005tab for Q4 Counts New Referrals and repeat the process of 3482d672-2a67-4a39-a7a7-7e58b19af558-1 updating the data source for each pivot table, replacing the one with four. ec660a0a-ba6e-47d4-b72d-cd90294cd42e-0 On the last pivot table, replace SY 25 with Q4. ccfe8bdc-5ce7-4322-a8dd-80bffea5f7bc-0 Then refresh your data. 2e8c0a7a-8630-4da4-9bf3-5e365ac5ac0c-0 When done, you will have successfully updated the 2e8c0a7a-8630-4da4-9bf3-5e365ac5ac0c-1 Student Support Referral Tracking tool. 59a2736c-adb9-45d2-9a9b-0a5377689eba-0 This concludes the demonstration for option one. 8412fdf5-41c7-4276-813c-e6807200f1fc-0 You have now seen each step exactly as it is outlined in the written guide. 9ae9f7d9-094d-497b-b9a3-a642a7cad18c-0 Following this sequence ensures that all pivot tables reference the correct data 9ae9f7d9-094d-497b-b9a3-a642a7cad18c-1 sources and that your campus teams have access to accurate referral counts.