Browse by Tags

• CompatibilityChecker
• Development
• Development Related
• EwaCompanion
• General

• New published paper - advanced usage of Excel Services and File Format manipulations

  Sergei Gundorov (whom you may remember from a previous post ) has published a paper on MSDN where he talks about a very interesting solution his team wrote in the Microsoft IT department. The solution is probably one of the most advanced implementation Read More... Posted Tuesday, May 06, 2008 10:46 AM by Shahar | 1 Comments Filed under: Excel Services

• Hitting "Session Timeout" errors when you clearly are not supposed to be hitting them

  Scenario: You are working on preparing dashboards or uploading workbooks to your SharePoint site for usage with Excel Services. Every now and again, even though you are clearly interacting with the session, EWA will suddenly tell you that the session Read More... Posted Tuesday, March 18, 2008 2:09 PM by Shahar | 2 Comments Filed under: Excel Services

• COM Library for Excel Web Services - Use EWS from VBA!

  In the ODC 2008, I gave a demo of how to use Excel Web Services from a VBA client - the demo was basically just a managed library that wrapped a generated Web Services proxy. Since Microsoft no longer seems to supply a SOAP toolkit for office, this is Read More... Posted Wednesday, March 05, 2008 9:00 AM by Shahar | 1 Comments Filed under: Development, Excel Services

• Chapter of the 'Professional Excel Services' book is on MSDN.

  MSDN has just published a chapter from my book " Professional Excel Services ". You can find it on this link . This wouldn't happened without the great work of Siew Moi Kohr. Thanks Siew! Read More... Posted Tuesday, March 04, 2008 4:49 PM by Shahar | 1 Comments Filed under: Excel Services

• Single-select Dimension member Analysis Services Filter Web Part

  A long long time ago, in a building far far away, two Jedis developers called Sreepada Santhegudda and Sergei Gundorov showed me a solution they came up with for a single-select Analysis Services filter web part . While SharePoint ships with a set of Read More... Posted Saturday, March 01, 2008 9:09 PM by Shahar | 1 Comments Filed under: Development, Excel Services

• Performance Counters in Excel Services - what do they mean

  Excel Services comes with a few performance counters designed to let an administrator know the load under which Excel Services is operating. When all performance counters are added, the list inside the management console looks like this: Active Requests: Read More... Posted Sunday, December 16, 2007 6:34 PM by Shahar | 1 Comments Filed under: Excel Services

• Latest ESCC build (914) - also fixes Invalid Chars in workbooks... Sometimes..

  Got this question from somebody who just installed the new version.. Previous builds did not know how to auto-fix invalid characters - with this version you can turn on auto-fix - but it will only work in some cases... When click on the Invalid Character Read More... Posted Friday, September 14, 2007 5:34 PM by Shahar | 0 Comments Filed under: Excel Services, CompatibilityChecker

• Excel Services Compatibility Checker: Build 914 - AutoFix external references + finer control over available checks

  I uploaded version 914 onto the download page . This build adds two new features: Finer control over which features are available (and which are autofixed) as well as adding the ability to "fix" external references/RTD functions. The ribbon changed a Read More... Posted Friday, September 14, 2007 9:00 AM by Shahar | 2 Comments Filed under: Excel Services, CompatibilityChecker

• IE Crashing when trying to do certain things in SharePoint?

  Towards the end of the development cycle of Excel Services, we saw some incredibly intermittent, incredibly rare issues with Internet Explorer crashing when doing certain operations. There were also a few people complaining about this on our forums . Read More... Posted Monday, September 10, 2007 7:22 PM by Shahar | 2 Comments Filed under: Excel Services

• UDFs in the world of 64bit Excel Services installations

  Deepak posted a question on one of my posts and I thought that it was worth posting a blog entry about. I will try to break this down as simply as I can, since there are many permutations and it is not always obvious what's going on. There are also a Read More... Posted Monday, September 10, 2007 12:05 AM by Shahar | 0 Comments Filed under: Excel Services

• New Compatibility Checker build (904): Fixing External References that were not found.

  You can download the newest version from the download page . I posted an entry about ESCC being unable to find some cases of External Reference (also called Linked workbooks). This caused workbooks to be marked as compatible with Excel Services even though Read More... Posted Wednesday, September 05, 2007 3:23 PM by Shahar | 0 Comments Filed under: Excel Services, CompatibilityChecker

• Excel Services Compatibility Checker sometimes does not find External Links

  There have been a few internal queries about this and I think I have finally found the problem. The Excel Services Compat Checker will sometimes say that a workbook is compatible with Excel Services, and when that workbook is loaded on the server, it Read More... Posted Tuesday, September 04, 2007 1:04 PM by Shahar | 3 Comments Filed under: Excel Services, CompatibilityChecker

• EWA Companion Part 4: Refresh/Recalc functionality

  In the first part of this post series I showed the EWA companion and its various capabilities. In this part, I will delve deeper into the "Automatic Refresh/Recalc" capabilities of the companion. This feature is divided into two parts - refresh and recalc. Read More... Posted Wednesday, August 22, 2007 9:10 AM by Shahar | 1 Comments Filed under: Development, Excel Services, EwaCompanion

• EWA Companion Part 3: Open/Download functionality

  In the first part of this post series I showed the EWA companion and its various capabilities. In this part, I will delve deeper into the "Open" functionality of the EWA Companion web-part. There are a few reasons behind adding the Open command to the Read More... Posted Tuesday, August 21, 2007 9:11 AM by Shahar | 12 Comments Filed under: Development, Excel Services, EwaCompanion

• EWA Companion Part 2: Save As Functionality

  In a previous post I discussed the EWA companion and how to set it up for saving back to SharePoint. This post will show the next set of capabilities which is the ability to Save As (actually, it exports or saves under another name - the new workbook Read More... Posted Monday, August 20, 2007 9:00 AM by Shahar | 0 Comments Filed under: Development, Excel Services, EwaCompanion