"Open in Excel" is OK, "Open Snapshot in Excel" Timeout

Question

I have a workbook that I can  "View in Web Browser" just fine. It comes up almost immediately. There are a few spreadsheet tabs and a few images etc.

While viewing the workbook in the browser, I have the toolbar set to show and users have the capability of "Open in Excel" and "Open Snapshot in Excel".

"Open in Excel" comes right up in Excel, no delay

"Open Snapshot in Excel" times out after my 300 second timeout setting, and then gives a 500 error on screen

What is the system doing during the "snapshot" process that might time me out?  Any ideas on what I can do to not timeout?

thanks

Answer 1

Here is what I found in my ULS logs showing the timeout

10/29/2009 15:48:33.34  w3wp.exe (0x054C)                        0x1B50 Excel Services                 Excel Calculation Services     1swi Verbose  CachedFile.Dispose: Disposing: Microsoft.Office.Excel.Server.CalculationServer.CachedFile: (null) 0000004b-8859-12a5-0000-000050f7b00b

10/29/2009 15:48:33.34  w3wp.exe (0x054C)                        0x1B50 Excel Services                 Excel Calculation Services     3sll Medium   ExcelService.PostProcessRequest: web method: GetWorkbook, got exception Microsoft.Office.Excel.Server.CalculationServer.Interop.AbortException: GetWorbkook aborted     at Microsoft.Office.Excel.Server.CalculationServer.Interop.WorkbookInterop.GetWorkbook(WorkbookType workbookType)     at Microsoft.Office.Excel.Server.CalculationServer.SavedWorkbook.Microsoft.Office.Excel.Server.CalculationServer.ICachedFileProvider.SaveFile(CachedFile cachedFile)     at Microsoft.Office.Excel.Server.CalculationServer.CachedFile.SaveFile(ICachedFileProvider fileProvider)     at Microsoft.Office.Excel.Server.CalculationServer.LocalDiskCache.ReserveCachedFileAndMarkUsed(FileId fileId, ICachedFileProvider fileProvider)     at Microsoft.Office.Excel.Server.CalculationServer.SavedWorkbook.GetWorkbook(Session ses... 0000004b-8859-12a5-0000-000050f7b00b

10/29/2009 15:48:33.34* w3wp.exe (0x054C)                        0x1B50 Excel Services                 Excel Calculation Services     3sll Medium   ...sion)     at Microsoft.Office.Excel.Server.CalculationServer.SessionWorkbook.GetWorkbook(Request request, WorkbookType workbookType)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.<>c__DisplayClass63.<GetWorkbook>b__62(Session session)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.ExecuteWebMethod(CommandParameter parameter, WebMethodType webMethodType, CoreWebMethod coreWebMethod) 0000004b-8859-12a5-0000-000050f7b00b
10/29/2009 15:48:33.34  w3wp.exe (0x054C)                        0x1B50 Excel Services                 Excel Calculation Services     2m5g Warning  Request exceeded the allowed time limit of 300 seconds. It is being cancelled. [Session: 22.16prcq4VG8FQTTs96TKAY390.5.en-US5.en-US73.+0300#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-0060 User: ***********************] 0000004b-8859-12a5-0000-000050f7b00b

Answer 2

Hi ChrisB2305,

 

A possible cause of your issue is the current logged in user is different in SharePoint than Windows. Please make sure your use the same domain account to log in Windows and SharePoint.

 

If this is not the cause of your issue, please let me know more information for further investigation:

1.       What is the version of the SharePoint Server.

2.       Does the issue happen to you or all users.

3.       Does the issue happen on only the Excel file or all Excel files?

If only few Excel files have the issue, a quick workaround is that create new document and copy the content to new file.

And if only one Excel file does not contain sensitive data, please send the Excel file to the workspace so that I could try to make a local reproduce.

4.       Please collect a network monitor trace and a SPSReport and send to the workspace for further investigation (If you are not sure how to do that, please refer to steps at the end of the reply.)

Workspace URL: (https://sftasia.one.microsoft.com/ChooseTransfer.aspx?key=a79eacb0-6474-45b6-a862-547a113bdbc8)
Workspace Password: 5UtqwZGpO2

 

Here is the steps to capture a network trace log for your reference:

1)      Download Microsoft Network Monitor 3.3 if you don’t have Network Monitor tool installed.

http://www.microsoft.com/downloads/details.aspx?familyid=983B941D-06CB-4658-B7F6-3088333D062F&displaylang=en

2)      Install the Microsoft Network Monitor 3.3 on one of your desktop.

3)      Launch the Network Monitor.

4)      Create a New Capture in the toolbar.

5)      Click Start to capture the network traffic.

6)      Reproduce the issue.

7)      Click Stop to stop capturing the network traffic.

8)      Click Save as button to Save the network trace log as a cap file.

9)      Send the cap file to the workspace

 

To capture SPSReports, please follow the steps:

1)      Download the SPSReport tool from http://spsreport.codeplex.com/

2)      Reproduce the issue.

3)      Run the SPSReport.exe on the WFE and Application Server runs Excel Services.

4)      Choose option 3 (Full).

5)      On your system a CAB file will be generated in the %systemroot%\SPSReports\Portal\rpt\Cab directory called %COMPUTERNAME%_SPSReports.CAB.

6)      The CAB file will contain the reports generated by the SPS Reporting Tool.

7)      Send the cab file to the workspace below.

 

 

Lambert Qin

TechNet Subscriber Support in forum

If you have any feedback on our support, please contact [e-mail]  

---

Sincerely,

Lambert Qin

Posting is provided "AS IS" with no warranties, and confers no rights.

Answer 3

When creating the Network Monitor capture, would I run this on my desktop (end user machine) or on the SharePoint servers?

thanks

Answer 4

Hi ChrisB2305,

 

As the "Open in Excel" and "Open Snapshot in Excel" would open the Excel files in the client eventually, the Network Monitor trace should be captured from the desktop (end user machine).

 

Let me know if you need further information.

 

Lambert Qin

TechNet Subscriber Support in forum

If you have any feedback on our support, please contact [e-mail]  

---

Sincerely,

Lambert Qin

Posting is provided "AS IS" with no warranties, and confers no rights.

Answer 5

The issue has been resolved. There were dirty cells in the worksheet. I found this by trying to save the Excel 2007 file into Excel 2003 format. There were lots of compatibility problems listed, one of which that I had exceeded the 65,000 row limit. I did not have that much data. I used the dirty cells fix "Clear All" (on the Editing Ribbon) on unused columns and rows. The workbook now loads very quickly within Excel Services.