none
Excel Web Services error attempted request on an invalid state. Unable to perform the operation

    Pregunta

  • Hi All,

    I Have create page on sharepoint services 2010. the page contain several web part. the web part connect to performance point Services, parameter on performance point services and excel web services. i have connect the parameter to webpart PPS and the parameter was link, but i found error when i connect the parameter to excel services. the message error is

    "Attempted request on an invalid state. Unable to perform the operation"

    before i have succed to connect it on the other VM and i was drop it, below the image

     

     

    • Cambiado Agnes SannieModerator martes, 29 de noviembre de 2011 7:04 Sharepoint related thread (Dari:Office Development)
    viernes, 25 de noviembre de 2011 11:30

Respuestas

  •  

    Hi Gaby,

    We did some research and the issue may be caused by the following issue:

    Warn on Refresh is enabled on the Excel Services trusted file location

    Please try to cleared the "Refresh warning enabled" check box on the trusted file location in the excel Service.

    Afterwards, please share your result in this thread.


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    jueves, 23 de febrero de 2012 7:42
    Moderador
  • Halo Yudhi.Hermawan,

    Menurut error message yang anda berikan, tampaknya hal ini disebabkan oleh Excel service. Untuk mencari  penyebab dari masalah ini, silakan coba langkah di bawah ini:

     1. Publikasikan Excel yang baru ke SharePoint anda, dan periksa apakah ini bekerja atau tidak;

     2. Cobalah untuk merestart Layanan Excel anda pada server.

     

    Bila anda masih mengalami kendala, silahkan memposting kembali dalam thread ini.


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    jueves, 01 de diciembre de 2011 9:30
    Moderador

Todas las respuestas

  • Halo Yudhi.Hermawan,

    Menurut error message yang anda berikan, tampaknya hal ini disebabkan oleh Excel service. Untuk mencari  penyebab dari masalah ini, silakan coba langkah di bawah ini:

     1. Publikasikan Excel yang baru ke SharePoint anda, dan periksa apakah ini bekerja atau tidak;

     2. Cobalah untuk merestart Layanan Excel anda pada server.

     

    Bila anda masih mengalami kendala, silahkan memposting kembali dalam thread ini.


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    jueves, 01 de diciembre de 2011 9:30
    Moderador
  • Hello, i have the same issue "Attempted request on an invalid state. Unable to perform this operation." doing the exact same things explained in the original post. I already tried both steps but no luck. Do you have any other option i can try?

    Thanks,

    Gaby

    lunes, 13 de febrero de 2012 21:15
  •  

    Hi Gaby,

    We did some research and the issue may be caused by the following issue:

    Warn on Refresh is enabled on the Excel Services trusted file location

    Please try to cleared the "Refresh warning enabled" check box on the trusted file location in the excel Service.

    Afterwards, please share your result in this thread.


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    jueves, 23 de febrero de 2012 7:42
    Moderador
  • Worked perfectly! Thanks Agnes!

    For references this is what was changed:

    jueves, 23 de febrero de 2012 16:23
  • Hi Gabriela,

    This didnt work for me. Any other thoughts ?

    I published Chart , Table , Parameter for excel sheet. Could see all are selected in Publish Options. I could see them visible as Items on top right next to View menu.

    I created a Web part page , inserted Excel Web Access , Filter webpart ( Text , Analysis services ) . Connected them to send multiple parameters but didnt work at all.

    Any other thoughts to fix this ? I really would like to fix this.

    Thanks,

    Aqueel

    jueves, 28 de junio de 2012 13:29