Issue with excel sheet connection properties. RRS feed

  • Question

  • Hi Folks,

    I am new to connection in Excel 2007 Workbook. I have created chart based on Sharepoint list data in website1. Now, last week i have changed my website1 URL and suddenly this workbook chart is not refreshing. Also, "Browse..." button in Connection property got disable. Now, how do i point my connection to new URL, so i can get the updates. Please advice.



    • Moved by Mike Walsh FIN Tuesday, August 30, 2011 3:16 PM Seems not to be an Excel *Services* question - just Excel + SharePoint (From:SharePoint - Excel Services (pre-SharePoint 2010))
    Tuesday, August 30, 2011 2:46 PM

All replies

  • Hi Chintan,

    When you open the chart - Under Data- Connections Tab- Properties- Check the box, refresh Data when opening the file(Usage Tab) and then under Definitaion tab You will see a Section called Command text as mentioned below


    You will see the URL there , try to modify it and save it.

    Or else you might have to recreate the chart . Let us know if this helps. Thanks

    Thanks & Regards Posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, August 30, 2011 9:16 PM
  • Hi Zoeb,

    Thx for replying. I can click on Definition tab but all fields under it are disable / inactive.

    Pls suggest further.

    - Chintan

    Wednesday, August 31, 2011 12:52 PM