Mike Arcuri - More business intelligence in Office 2007

Thanks for reponding to the feedback and putting up another Office 2007 video.

Mike has a "ship it" award, I wonder what product that is for?

Has the number-of-columns-limit been changed already or not?

I love excel charting capabilities

Nice stuff. Scoble, you weren't by any chance excited by all this, were you?  I couldn't really tell...

ZippyV wrote:

Has the number-of-columns-limit been changed already or not?

You get 16,384 columns and 1,048,576 rows now.

scobleizer wrote:

No, I was bored out of my mind! Heheh.

Sorry, I get excited by charts and graphs.

Yeah, I've noticed you seem somewhat partial to some productivity apps, which is understandable given your occupation .  Keep it up!

Oh, and try to teach your camera-steadying techniques to whoever shot that previous video...

Mike and others. Maybe a stupid question if so I apologize but...is there any easy way to extract the presentation element from Excel 2007and then include it in a portal style app as some sort of widget? It seems to me that would be a good thing for helping people share information and act as coordinated teams?

I've been confused lately, with all the talk of Open Documents, and such. Will Office2007 break the OpenOffice compatibility ? I understand there are DRM possibilities with Office2007, and if _that_ is the only restricting portion of the app, it could still be valuable. If the application itself disallowes any non-Office system to read the files at all, it will be a large problem for businesses and users that use the better alternative(s).

Just a thought.

Keep up the work.

ohgood wrote:

I've been confused lately, with all the talk of Open Documents, and such. Will Office2007 break the OpenOffice compatibility ?

What OpenOffice compatibility?

ohgood wrote:

I understand there are DRM possibilities with Office2007, and if _that_ is the only restricting portion of the app, it could still be valuable.

You can apply DRM to any office document today, on Office 2003.

ohgood wrote:

If the application itself disallowes any non-Office system to read the files at all, it will be a large problem for businesses and users

Uh? With an open file format how can they disallow other apps to read the files?

ohgood wrote:

that use the better alternative(s).

"better alternative(s)"? Such as...?

What about the row limit when importing?  Does it still just truncate at 65K rows?  Would be nice to be given the option to continue loading to the next sheet!

Nice stuff.

When's the last time Mike got a day off and more than 5 hours sleep?  Looks like he could use a vacation.

Looks cool.

I have a questions about the new table cell naming (ie where cell refrences like  $E2 are replaced with  names like [2004 prices] (http://channel9.msdn.com/Showpost.aspx?postid=177827&pvrid=269).

If I build a table in Excel 07 and my formulas are automaticaly translated this way. What happens when somebody attempts to open the sheet in Excel '03?

considering Tables don't exist in '03, there shouldn't be a problem there anyway.

PIVOTtables are in '03, but the table example he uses is new to '07. the closest thing to the Table in '03 is the ListObject, but the Table in '03 is a major step up from that.

and you can't change formulas in PivotTables anyway.

Thanks for the comments and questions.  Here are some answers and pointers.

dahowlett - If you're interested in using charts and Excel information in web portals, that will be possible with Excel Services in Office 2007.  You may want to watch some of my earlier Channel 9 video, and look at some of the Excel Services posts on the Excel blog to learn more.

TrayJoe - If I look sleepy it's because of the 5 month old boy and 2.5 year old girl at home.  

ohgood - Looks like you've gotten some replies on your post already.  There are new file formats for Office 2007, but they will be fully documented and open XML.  I'm sure other products that read Office 2003 files will add support for these new formats in no time.  Plus, people will still be able to save files in the older formats.  If you have more quesitons, you might follow up Brian Jones (at his Office 2007 file format blog: http://blogs.msdn.com/brian_jones/).

Andretzu and Simo - We're being very careful about backward compatability with older versions of Excel.  For answers to these specific questions, you may want to ask David Gainer (at his Excel 2007 blog: http://blogs.msdn.com/excel/)

- Mike Arcuri

Excel 2007 has new, rich, semantic formatting features---adding both visuals and meaning. Very impressive! All those gradients will export to XAML with high fidelity one day...

Is this video still available??