The table will then refresh each time you open it. Tick the box to Refresh data when opening the file, then click Ok. Go to the Data menu in Excel and select Properties. So the live feed refreshes the data each time you open it, you will need to adjust the settings. Remember to save your file as something memorable so you can find it again in the future! Once the data has finished loading, you will see it in your spreadsheet. Your spreadsheet will then show that the data is loading. 15 minutes should do it! You should then be able to select the file.Ĭlick Ok in the pop-up box to import the data to the existing sheet. Top Tip: If you can't select the file, please wait for a bit of time for the data to process. txt file from your documents, then click Get Data. Open a blank Excel document and click into the Data tab. You can save it anywhere and under any name you wish. Save your document as a Plain text (.txt) file. ![]() Open a blank Word document and paste your live feed URL onto the page. In this case, I'm using the Attendance > Absentees > Persistent Absentees page.Ĭlick the Download button then select Live Feed.Ĭopy the URL from the pop-up box that appears. Go to the age you would like to set up a live feed from. ![]() For guidance on using a PC or Google Sheets, see the instructions in this article. These instructions cover creating a live feed from Arbor into Excel using a Mac.
0 Comments
Leave a Reply. |