Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

Excel Services Calculation Issue Update & Fix!

Posted Wednesday, October 10, 2007 12:19 PM by LuisBE
Please check out David's post for links to the fixes. http://blogs.msdn.com/excel/archive/2007/10/09/calculation-issue-update-fix-available.aspx Read More...
1 Comments
Filed under:

Calculation Issue Post on Excel Blog

Posted Tuesday, September 25, 2007 11:31 PM by LuisBE
This same calculation issue affects Excel Services, and is being addressed concurrently. http://blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspx Read More...
1 Comments
Filed under:

Sponsor me for JDRF's Beat the Bridge!

Posted Friday, May 11, 2007 1:11 PM by LuisBE
Dear Friends and Family, I recently accepted the challenge to raise funds to support the JDRF Northwest - Nordstrom Beat the Bridge in its efforts to find a cure for diabetes and it's deadly complications. Every day 35 more children are diagnosed with Read More...
1 Comments

Excel Services Team Looking for Customer Connections!

Posted Thursday, May 10, 2007 11:00 AM by LuisBE
The Excel services team is looking for companies that are using Excel services and are willing to share their feedback with the team. Feedback can be in the form of visits to the customer sites, conference calls or special events that will be organized Read More...
0 Comments

New blog from an Excel Services Tester

Posted Tuesday, May 01, 2007 7:06 PM by LuisBE
Another one of our prolific Excel Services testers has started up a blog here: http://blogs.msdn.com/sherder/ Go check it out! I've been a little dark on the blog lately in order to focus 100% on planning for O14, but I'll be back soon! Read More...
0 Comments
Filed under:

Microsoft Office is Searching for Talented Devs!

Posted Wednesday, April 04, 2007 11:24 AM by LuisBE
Microsoft Office is looking for talented developers to work on cutting edge web-based technologies that integrate with Excel and Access. It’s a great opportunity to work on cool new features and build great products. You may have already heard about Excel Read More...
0 Comments
Filed under:

Excel Services step-by-step guides

Posted Tuesday, March 13, 2007 7:19 AM by LuisBE
Technet now has some interesting tutorials for Excel Services. Check them out at http://technet2.microsoft.com/Office/en-us/library/eea3ace8-0863-429a-b1e8-041254ed2fc41033.mspx?mfr=true Enjoy! Read More...
3 Comments
Filed under:

New MSDN Article on Extending Excel Services Through UDFs

Posted Tuesday, February 06, 2007 1:11 PM by LuisBE
From yours truly: Summary: Optimize version 1 of the Excel Services programmability framework to extend Microsoft Office Excel 2007 and Excel Services functionalities to work with SharePoint lists, query tables on Excel Services, external workbook references, Read More...
1 Comments

Enable Paging in Your Array Formula UDFs

Posted Thursday, February 01, 2007 1:04 PM by LuisBE
As I alluded to earlier, one way to overcome the limitation that array formulas do not dynamically resize to fit the dimensionality of the data being returned by your UDF is to use paging. Here is a simple way of enabling paging, without having to modify Read More...
0 Comments

Consuming Business Data Catalog Entities in Excel Services

Posted Wednesday, January 31, 2007 8:47 PM by LuisBE
One of the coolest (only?) SharePoint external data features is the Business Data Catalog (BDC). The BDC is brand new with SharePoint 2007, and is not yet fully integrated into Excel and Excel Services... though, if you've read one or two other entries Read More...
0 Comments

Excel Services Related Books in the Pipeline

Posted Thursday, January 11, 2007 3:08 PM by LuisBE
Here are a few books being worked on about Excel Services: http://www.amazon.com/Beginning-Excel-Services-Liviu-Asnash/dp/0470104899/sr=8-1/qid=1168539718/ref=sr_1_1/105-2258527-0791610?ie=UTF8&s=books http://www.amazon.com/Professional-Excel-Services-Shahar-Prish/dp/0470104864/sr=1-1/qid=1168539759/ref=sr_1_1/105-2258527-0791610?ie=UTF8&s=books Read More...
1 Comments
Filed under:

New Excel Services MSDN Forum!

Posted Tuesday, January 09, 2007 6:47 PM by LuisBE
MSDN has created a forum for Excel Services related discussion, you can find it at: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1208&SiteID=1 We're working on a more readable shortcut, and it's empty as of right now but you can expect Read More...
0 Comments
Filed under:

v1 Feedback & Requests for v2 of Excel Services!

Posted Tuesday, January 09, 2007 11:56 AM by LuisBE
<UPDATE: Reworded the post to stay away from any legal issues :o) > We are currently working on planning for the next version of Excel Services and I would greatly appreciate any v1 feedback as well as requests you would like to see implemented Read More...
7 Comments
Filed under:

Working Around Dimensional Limitations of Using Array Formulas for UDF Return Values.

Posted Tuesday, January 09, 2007 11:42 AM by LuisBE
As you have noticed, many of my samples below use an Array Formula in Excel to retrieve an array of data returned by your UDF code. The biggest issue with taking this approach is that you need to know ahead of time the exact dimensions of the data being Read More...
1 Comments

Using UDFs and Excel Formulas to Get a Query Table on Excel Services

Posted Monday, December 11, 2006 11:36 AM by LuisBE
As you may or may not know by now, one of the limitations in this version of Excel Services is the inability to publish workbooks containing Query Tables (tables that have external data as their source). There have been numerous blog posts on the web Read More...
1 Comments
Attachment(s): QT4Server.xlsx
More Posts Next page »
 
Page view tracker