You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
One of our most senior developers on Excel Services, Shahar Prish, is busy writing posts in his blog on the new programmability features in the 2010 version of Excel Services. The first set of posts talk about REST and moving forward he will expand to the new JavaScript OM we added this release. Here are the links, if you care at all about building custom solutions for Excel and Excel Services they are a great read:
General posts about REST:
Welcome to the new Excel Services
So what does REST on Excel Services look like???
Discovery via the Excel Services REST APIs
Getting ranges via Excel Services REST as well as Charts and Discovery
Excel Services REST APIs – the basics
Advanced Excel Services REST API capabilities – passing parameters to a spreadsheet
How to seamlessly embed data from Excel Services spreadsheets into Word
The Excel Services Windows Gadget:
Introducing the Excel Services Windows 7 Gadget
Showing Excel ranges in the Excel Services Gadget
Bringing it all back home – using advanced REST functionality with the Excel Services Gadget
And the blog is starting to show how to actually code the gadget:
Coding the Excel Services Windows 7 Gadget – Part 1 - Settings
Comments: (3) Collapse
Question - I've done some research & I don't believe it is possible to do what I want to do, but I thought maybe you might know of some way that it can be done. I am wanting to import data from an Excel 2007 document that is copied (file, save as) each month into another Excel 2007 document where the distination cells change each month. The main data source (contains formulas) calculates how much is spent each month on elec, gas, elevator maintenance, etc. for different buildings & the final calculated numbers need to filter into the destination file/cells - this is why it changes each month, as bills are paid monthly. Is this possible?
How can I put in a formula using data from another page in my worksheet?
Comments: (loading) Collapse