I need to be able to export a project list to Excel and overwrite the contents in an existing Summary Report with the exported list. Is this possible? I am using SharePoint 2013 and Excel 2010.
I need to be able to export a project list to Excel and overwrite the contents in an existing Summary Report with the exported list. Is this possible? I am using SharePoint 2013 and Excel 2010.
I think you can get it in from External Data in Excel, and selecting sharepoint as a source
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
I tried. It doesn't give me the SharePoint option in External Data sources.
http://www.microsoft.com/en-gb/downl....aspx?id=39379
This should help
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks