http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/Mike Arcuri - More business intelligence in Office 2007http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/en-usThu, 07 May 2009 01:06:20 GMTThu, 07 May 2009 01:06:20 GMTEvNet (EvNet, Version=1.0.3608.3122, Culture=neutral, PublicKeyToken=null)Is this video still available??http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=468293Thu, 07 May 2009 01:06:21 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=4682930http://channel9.msdn.com/468293/WebViewBug.aspx?EVT=0Is this video still available??roframj0http://channel9.msdn.com/468293/Trackback.aspxExcel 2007 has new, rich,&nbsp;<EM>semantic</EM> formatting features---adding both visuals <EM>and</EM> meaning. Very impressive! All those gradients will export to XAML with high fidelity one day...:Dhttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=174933Wed, 05 Apr 2006 06:43:26 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1749330http://channel9.msdn.com/174933/WebViewBug.aspx?EVT=0Excel 2007 has new, rich,&nbsp;semantic formatting features---adding both visuals and meaning. Very impressive! All those gradients will export to XAML with high fidelity one day...:Drasx0http://channel9.msdn.com/174933/Trackback.aspxThanks for the comments and questions.&nbsp; Here are some answers and pointers.<BR><BR><STRONG>dahowlett</STRONG> - If you're interested in using charts and Excel information in web portals,&nbsp;that will be possible with Excel Services in Office 2007.&nbsp; You may want to watch some of <a href="http://channel9.msdn.com/ShowPost.aspx?PostID=164703>my earlier Channel 9 video</a>, and look at some of the <a href="http://blogs.msdn.com/excel/search.aspx?q=services&amp;p=1">Excel Services posts on the Excel blog</a> to learn more.<BR><BR><STRONG>TrayJoe </STRONG>- If I look sleepy it's because of the 5 month old boy and 2.5 year old girl at home.&nbsp;&nbsp; :-)<BR><BR><STRONG>ohgood</STRONG> - Looks like you've gotten some replies on your post already.&nbsp; There are new file formats for Office 2007, but they will be fully documented and open XML.&nbsp; I'm sure other products that read Office 2003 files will add support for these new formats in no time.&nbsp; Plus, people will still be able to save files in the older formats.&nbsp; If you have more quesitons, you might follow up Brian Jones (at his Office 2007 file format blog: <a href="http://blogs.msdn.com/brian_jones/">http://blogs.msdn.com/brian_jones/</a>).<BR><BR><STRONG>Andretzu and Simo</STRONG> - We're being very careful about backward compatability with older versions of Excel.&nbsp; For answers to these specific questions, you may want to ask David Gainer (at his Excel 2007 blog: <a href="http://blogs.msdn.com/excel/">http://blogs.msdn.com/excel/</a>)<BR><BR>- Mike Arcurihttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=174484Mon, 03 Apr 2006 21:21:29 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1744840http://channel9.msdn.com/174484/WebViewBug.aspx?EVT=0Thanks for the comments and questions.&nbsp; Here are some answers and pointers.dahowlett - If you're interested in using charts and Excel information in web portals,&nbsp;that will be possible with Excel Services in Office 2007.&nbsp; You may want to watch some of my earlier Channel 9 video, and&#8230;mike_arcuri0http://channel9.msdn.com/174484/Trackback.aspxconsidering Tables don't exist in '03, there shouldn't be a problem there anyway.<BR><BR>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.<BR><BR>and you can't change formulas in PivotTables anyway.<BR><BR>http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=174205Mon, 03 Apr 2006 05:23:27 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1742050http://channel9.msdn.com/174205/WebViewBug.aspx?EVT=0considering 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.pringles0http://channel9.msdn.com/174205/Trackback.aspxLooks cool.<BR><BR>I have a questions about the new table cell naming (ie where cell refrences like &nbsp;$E2 are replaced with&nbsp; names like [2004 prices] (<a href="http://channel9.msdn.com/Showpost.aspx?postid=177827&amp;pvrid=269>http://channel9.msdn.com/Showpost.aspx?postid=177827&amp;pvrid=269</a>).<BR><BR>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?http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=174111Sun, 02 Apr 2006 18:40:33 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1741110http://channel9.msdn.com/174111/WebViewBug.aspx?EVT=0Looks cool.I have a questions about the new table cell naming (ie where cell refrences like &nbsp;$E2 are replaced with&nbsp; names like [2004 prices] (http://channel9.msdn.com/Showpost.aspx?postid=177827&amp;pvrid=269).If I build a table in Excel 07 and my formulas are automaticaly translated this&#8230;Simo0http://channel9.msdn.com/174111/Trackback.aspxNice stuff.<BR><BR>When's the last time Mike got a day off and more than 5 hours sleep?&nbsp; Looks like he could use a vacation.http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=174094Sun, 02 Apr 2006 17:03:28 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1740940http://channel9.msdn.com/174094/WebViewBug.aspx?EVT=0Nice stuff.When's the last time Mike got a day off and more than 5 hours sleep?&nbsp; Looks like he could use a vacation.TrayJoe0http://channel9.msdn.com/174094/Trackback.aspxWhat about the row limit when importing?&nbsp; Does it still just truncate at 65K rows?&nbsp; Would be nice to be given the option to continue loading to the next sheet!<br>http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=174060Sun, 02 Apr 2006 12:41:55 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1740600http://channel9.msdn.com/174060/WebViewBug.aspx?EVT=0What about the row limit when importing?&nbsp; Does it still just truncate at 65K rows?&nbsp; Would be nice to be given the option to continue loading to the next sheet!Andretzu0http://channel9.msdn.com/174060/Trackback.aspx<BLOCKQUOTE><div>ohgood wrote:</div><div>I've been confused lately, with all the talk of Open Documents, and such. Will Office2007 break the OpenOffice compatibility ? </div></BLOCKQUOTE><BR>What OpenOffice compatibility?<BR><BLOCKQUOTE><div>ohgood wrote:</div><div>I understand there are DRM possibilities with Office2007, and if _that_ is the only restricting portion of the app, it could still be valuable. </div></BLOCKQUOTE><BR>You can apply DRM to any office document today, on Office 2003. <BR><BLOCKQUOTE><div>ohgood wrote:</div><div>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 </div></BLOCKQUOTE><BR>Uh? With an open file format how can they disallow other apps to read the files?<BR><BLOCKQUOTE><div>ohgood wrote:</div><div>that use the better alternative(s).</div></BLOCKQUOTE><BR>"better alternative(s)"? Such as...?http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=173797Sat, 01 Apr 2006 04:03:47 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1737970http://channel9.msdn.com/173797/WebViewBug.aspx?EVT=0ohgood 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,&#8230;PaoloM0http://channel9.msdn.com/173797/Trackback.aspxWow! Excel 2007, and Office 2007 in general,&nbsp;is going to be great! Wonderful.<BR><BR>I'm looking forward to the next Office 12 videos! Thank you for this video, Scoble!http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=173660Fri, 31 Mar 2006 19:09:33 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1736600http://channel9.msdn.com/173660/WebViewBug.aspx?EVT=0Wow! Excel 2007, and Office 2007 in general,&nbsp;is going to be great! Wonderful.I'm looking forward to the next Office 12 videos! Thank you for this video, Scoble!Christian Liensberger0http://channel9.msdn.com/173660/Trackback.aspxI'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).<br><br>Just a thought.<br><br>Keep up the work.:)<br>http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=173636Fri, 31 Mar 2006 18:18:57 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1736360http://channel9.msdn.com/173636/WebViewBug.aspx?EVT=0I'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&#8230;ohgood0http://channel9.msdn.com/173636/Trackback.aspxMike 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?http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=173541Fri, 31 Mar 2006 11:50:01 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1735410http://channel9.msdn.com/173541/WebViewBug.aspx?EVT=0Mike 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?dahowlett0http://channel9.msdn.com/173541/Trackback.aspx<BLOCKQUOTE><div>scobleizer wrote:</div><div><BR>No, I was bored out of my mind! Heheh.<BR><BR>Sorry, I get excited by charts and graphs. :-)</div></BLOCKQUOTE><BR><BR>Yeah, I've noticed you seem somewhat partial to some productivity apps, which is understandable given your occupation .&nbsp; Keep it up!<BR><BR>Oh, and try to teach your camera-steadying techniques to whoever shot that previous video...http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=173455Fri, 31 Mar 2006 00:43:44 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1734550http://channel9.msdn.com/173455/WebViewBug.aspx?EVT=0scobleizer 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 .&nbsp; Keep it up!Oh, and try to teach your camera-steadying techniques to whoever shot that previous video...SlackmasterK0http://channel9.msdn.com/173455/Trackback.aspx<BLOCKQUOTE><div>SlackmasterK wrote:</div><div>Nice stuff. Scoble, you weren't by any chance excited by all this, were you?&nbsp; I couldn't really tell... :)</div></BLOCKQUOTE><BR><BR>No, I was bored out of my mind! Heheh.<BR><BR>Sorry, I get excited by charts and graphs. :-)http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=173448Fri, 31 Mar 2006 00:03:51 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1734480http://channel9.msdn.com/173448/WebViewBug.aspx?EVT=0SlackmasterK wrote:Nice stuff. Scoble, you weren't by any chance excited by all this, were you?&nbsp; I couldn't really tell... :)No, I was bored out of my mind! Heheh.Sorry, I get excited by charts and graphs. :-)scobleizer0http://channel9.msdn.com/173448/Trackback.aspx<BLOCKQUOTE><div>ZippyV wrote:</div><div> <P>Has the number-of-columns-limit been changed already or not?</P></div></BLOCKQUOTE><BR><BR>You get 16,384 columns and 1,048,576 rows now.http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=173436Thu, 30 Mar 2006 22:57:39 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1734360http://channel9.msdn.com/173436/WebViewBug.aspx?EVT=0ZippyV wrote: Has the number-of-columns-limit been changed already or not?You get 16,384 columns and 1,048,576 rows now.DigitalDud0http://channel9.msdn.com/173436/Trackback.aspxNice stuff. Scoble, you weren't by any chance excited by all this, were you?&nbsp; I couldn't really tell... :)http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=173428Thu, 30 Mar 2006 22:48:44 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1734280http://channel9.msdn.com/173428/WebViewBug.aspx?EVT=0Nice stuff. Scoble, you weren't by any chance excited by all this, were you?&nbsp; I couldn't really tell... :)SlackmasterK0http://channel9.msdn.com/173428/Trackback.aspxI love excel charting capabilitieshttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=173363Thu, 30 Mar 2006 20:24:47 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1733630http://channel9.msdn.com/173363/WebViewBug.aspx?EVT=0I love excel charting capabilitiesmeysun0http://channel9.msdn.com/173363/Trackback.aspx<P>Has the number-of-columns-limit been changed already or not?</P>http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=173356Thu, 30 Mar 2006 20:00:17 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1733560http://channel9.msdn.com/173356/WebViewBug.aspx?EVT=0Has the number-of-columns-limit been changed already or not?ZippyV0http://channel9.msdn.com/173356/Trackback.aspxThanks for reponding to the feedback and putting up another Office 2007 video.<BR><BR>Mike has a "ship it" award, I wonder what product that is for?http://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=173317Thu, 30 Mar 2006 18:00:33 GMThttp://channel9.msdn.com/posts/scobleizer/Mike-Arcuri-More-business-intelligence-in-Office-2007/?CommentID=1733170http://channel9.msdn.com/173317/WebViewBug.aspx?EVT=0Thanks 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?Zeo0http://channel9.msdn.com/173317/Trackback.aspx