locked
Excel cannot link to updated SharePoint List RRS feed

  • Question

  • I use iqy file to export a SharePoint (2007) List to an Excel 2007 workbook and build templates based on the data. It works fine until after the data in the List is updated. The List is updated from a make-tabe query in Access. Every time I need to update the data in the List, I delete the List and generate a new List using the same name. Howeve, the link would not work after updating. When I look the Command text in Excel connection properties, it seems that the strings for VIEWGUID and LISTNAME changes with every data update. Is there a way to fix this problem?

    Tuesday, June 5, 2012 5:12 PM

Answers

  • Hi sstww,

    The VIEWGUID and LISTNAME will be changed if you have generated a new list using the same name. And you should also change the VIEWGUID and LISTGUID in the iqy.

    You may change the GUID programmatically by the list name in the iqy such as using SharePoint WebServices.

    Thanks,


    Lambda Zhao

    TechNet Community Support

    Friday, June 8, 2012 6:10 AM