The following video shows (in a somewhat grainy manner) the Addin in motion. There are also captions explaining each step (the caption that says "There's a new toolbar" actually means "There's a new Ribbon Tab" - old habbits die hard I guess..

Video: Remote Ranges - Excel 2007 and Excel Services integration

I will upload the Addin to the blog soon, so you can install it and try it out.