I'll do my best to describe my situation:

I'm trying to pull data from a spreadsheet that is stored online but is not displayed in table form therefore eliminating the possibility of using the "Get External Data From the Web" function in Excel 2010. Basically, there is a little excel icon that I can click that gives me the option to open or save the spreadsheet to my computer. This spreadsheet is updated monthly so ideally, the connection would be dynamic, not requiring me to refresh the connection manually. All I need is 4 numbers which are in 4 separate cells. I think this probably goes without saying, but I'm trying to import them into Excel 2010 and use them in a spreadsheet.

Any help would be greatly appreciated!

Mark