How to treat spaces/single quotes in Sheet names in REST

When using REST to access portions of a workbook, people sometimes use direct addressing (Sheet1!A1). I thought I’d drop a line about the icky way this works when you have single quotes in your sheet name. Reminder… First – a short reminder. This is how Excel Services REST works when trying to access a range:…


It’s been a while… Welcome Windows Live Embedding!

This has been a long time coming. But I finally have something new for you guys. It has been all over the news/twitter/blogs by now, but one of the new features we added is the ability to embed Excel workbooks in your blogs/sites. There’s a pretty straightforward explanation about this here: Embedding Excel Web App…


Restplorer – visual exploration tool for Excel Services 2010 REST capabilities

At the beginning of the year, I wrote a little web app that lets you get embed code for REST URLs/elements in Excel Services in a very easy way – instead of crafting the URL yourself, or navigating through ATOM feeds, you get a nice UI to do that. Well.. Not really “nice” as much…


Excel Services Gadget download

This is the download page for the Excel Services gadget described in these set of posts. (Download link is right below this line – where it says “Attachments:”) ExGadget.gadget


“Scratch pad” mode in Excel Services 2010 – how to bring it back

One of the things that were a side-effect of the massive re-write we did on the Excel Web Access component (EWA) to enable editing scenarios and better scrolling was the fact that, when in view-mode, we could allow the user to type directly into the cells of the workbook (as opposed to the way we…


Charts based on dynamic ranges in Excel Services 2010

Hey folks, been asked about this a few times already, so thought I would post – if you are using any of the betas, you will notice that your charts based on dynamic ranges that used to work in 2007 no longer work. This has been fixed and will be available in the RTM bits….


How to get favorites listed when searching in the Start menu

There aren’t many Vista features I am missing in Win7, but one that I most definitely miss is having favorites appear when searching the start-menu. Now, you can add a favorites menu item to Start, but that’s not all that helpful for me – what I want is to be able to search in the…