locked
Refresh Workbook Connections via web service RRS feed

  • Question

  • Hi,

    Is it not possible to Refresh all workbook connections, and then save the workbook again afterwards using the web services (ExcelService.asmx). When I try to do it via code I get the following exception:

    This workbook contains external data or functions that can return personal information. when I call OpenWorkbookForEditing().

    The point is that I want to refresh the data in the excel file, and then save it to the library.

    I hope you can help, thanks.

     

    Thursday, September 9, 2010 11:45 AM

Answers

  • i wanted to write the changes back to the file after the refresh. 

    Found out that you have to check the file out first before you can openworkbookforediting(). 

    Another way to do it was to get the changes with GetWorkbook and then overwrite the file.

    But thanks anyways :-)

    • Marked as answer by mortenbpost Friday, September 10, 2010 8:44 AM
    Friday, September 10, 2010 8:44 AM

All replies