hi Is there a way to sync a list to a excel. I have a list that will be periodically updated. I want the list's data to be extracted to the excel ( sync it on its own without the user publishing it ). From the generated excel, I need to create a dashboard. What should I do...

Hi, i have a question. for creating dash board you can do it directly from list,why you want to create dash board from excel sheet which has values copied from the list?ullasjoshi

Hi, Try to create a time job and update the excel file based the list periodically. How to create time job, please refer to http://msdn.microsoft.com/en-us/library/cc406686(office.12).aspx Hope this helps Thanks! Stanfford