Creating a TOC with Hyperlinks Programmatically

Today’s author is Dennis Wallentin, XL-Dennis, of http://xldennis.wordpress.com/ A few weeks ago we posted a code example for creating a table of contents for your workbook. Dennis offers another approach with this code sample for creating a TOC with hyperlinks

See the rest here: 
Creating a TOC with Hyperlinks Programmatically

Linked Tables

Read more here:
Linked Tables

In our previous blog post, we discussed how easy it is to use the Copy/Paste feature of the PowerPivot [aka Gemini] add-in to bring in data from virtually any external source that cannot otherwise be accessed by means of an ODBC, OLEDB or Managed .NET provider. In these scenarios, business users are free to copy new or updated data at any time, but the source of the data is not retained in the model itself, and so multiple copies may need to be manually performed over the model’s life span in order to reflect changes to the sources. Now consider the following business scenario: an analyst needs to produce a forecast of their company’s sales by product over the next year.

Excel Services Getting Started – Pt4 Web Service APIs

This continues my previous checklists here , here and here on getting started with Excel Services. In this post, I’ll append a walkthrough for using the Excel Web Services APIs. 6.

The rest is here:
Excel Services Getting Started – Pt4 Web Service APIs

4. VSTO Bug Tracker : Getting the data into Excel

The next step is to get more of the bug data into Excel so we can start to analyze it.  To do this, we will use VSTO’s data bind to ListObject support. I’m going to approach this in a different “more advanced” way that will make sense later in the demo. Long time VSTO developer will know that the simple way to bind data to a list object in VSTO is to create an Excel Workbook project, add a data source, then drag and drop the data source onto the Excel Workbook

See more here: 
4. VSTO Bug Tracker : Getting the data into Excel

3. VSTO Bug Tracker : A UDF

Now that we have our web service, lets get started by writing a managed UDF that uses the web method “GetColumnValue”.  In fact, the UDF will mirror this web method and make it so we can use it in Excel formulas. First, add a new C# or VB class library project to your solution using File > Add > New Project. Name the project BugAddIn

Original post:
3. VSTO Bug Tracker : A UDF