"Open in Excel" is OK, "Open Snapshot in Excel" Timeout
- 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- Moved byMike Walsh MVPMVP, ModeratorFriday, October 30, 2009 4:53 AMnow? (From:SharePoint - Excel Services)
- Moved byMike Walsh MVPMVP, ModeratorFriday, October 30, 2009 4:52 AMNo mention of excel services - probably "excel + SharePoint" only. Moving to Admin (From:SharePoint - Excel Services)
- Moved byMike Walsh MVPMVP, ModeratorFriday, October 30, 2009 12:54 PMUser's reply to original post indicates Excel Services ! So moving it back. (From:SharePoint - Setup, Upgrade, Administration and Operation)
Answers
- 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.
- Marked As Answer byLambert QinMSFT, ModeratorWednesday, November 04, 2009 1:30 AM
All Replies
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-000050f7b00bHi 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: 5UtqwZGpO2Here 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.
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 mtngfb@microsoft.com
Sincerely,Lambert QinPosting is provided "AS IS" with no warranties, and confers no rights.- Unmarked As Answer byLambert QinMSFT, ModeratorWednesday, November 04, 2009 1:30 AM
- Marked As Answer byChrisB2305 Tuesday, November 03, 2009 6:31 PM
- When creating the Network Monitor capture, would I run this on my desktop (end user machine) or on the SharePoint servers?
thanks 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 mtngfb@microsoft.com
Sincerely,Lambert QinPosting is provided "AS IS" with no warranties, and confers no rights.- 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.
- Marked As Answer byLambert QinMSFT, ModeratorWednesday, November 04, 2009 1:30 AM
