登录
 
主页技术资源库学习下载支持社区论坛
IT 专业人士的资源 >
> 
> 
Excel Web Services error attempted request on an invalid state. Unable to perform the operation

Отвечено Excel Web Services error attempted request on an invalid state. Unable to perform the operation

  • 2011年11月25日 11:30
     
     
    登录进行投票
    0

    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

     

     

     

全部回复

  • 2011年12月1日 9:30
    版主
     
     已答复
    登录进行投票
    0

    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.
     
  • 2012年2月13日 21:15
     
     
    登录进行投票
    0

    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

     
  • 2012年2月23日 7:42
    版主
     
     已答复
    登录进行投票
    1
     

    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.

     
  • 2012年2月23日 16:23
     
     
    登录进行投票
    0

    Worked perfectly! Thanks Agnes!

    For references this is what was changed:

     
  • 2012年6月28日 13:29
     
     
    登录进行投票
    0

    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