Task list exports to excel automation
What I need and was looking for that is currently not available is a way to export a task list into a excel spread sheet for charting of the data. Once this is done any new entry into the task list would auto update to the excel sheet and thus the graph. My current application of this would be in SharePoint 2013 Online so as long as the task list, graph, and excel sheet are on the SharePoint site it would update
I've manually exported tasks from Outlook 2010 to Excel (both on the PC), but there was only a limited amount of information copied across. The lengthy reports on IT support tasks in the main free text area were truncated, so I was not able to use the spreadsheet to generate an overview.
Also I could not work out any way to uniquely identify each task and then use VB macros to update my spreadsheet.
I know this is not quite what Mike is asking, but I think the get management type overview stats from the task list is the same objective here.
Please can you make the online version of the tasks view a bit more user friendly and enable us to get some stats out?