Office BlogZ

	Roadmap for Apps for Office, VSTO, and VBA VSTO 2 06/18/2013 Note: This post is simultaneously published both to the VSTO blog and to the apps for Office blog. To learn more about apps for Office, visit http://dev.office.com. With all the buzz around the new apps for Office program...
	Workbook Window States: Maximized, Restored, Minimized, Limbo Dick Kusleika 06/18/2013 I have been seeing some strange behavior in Excel 2010. I run 2010 on at least three machines and this only happens on one. It just so happens that the one machine is the one I have the least control over. To my knowledge, windows inside of Excel...
	Need Microsoft Office 365 SharePoint Training or Consulting? We have it! Jeff Cate \| Kevin Pine 06/17/2013 Is your organization looking for training and/or consulting on SharePoint Online in Microsoft Office 365? Well, your search is over!Office 365 SharePoint is an increasingly popular way to incorporate the benefits and...
	A New Events-In-Progress DAX Pattern Chris Webb 06/13/2013 I’ve been working on a very complex SSAS Tabular implementation recently, and as a result I’ve learned a few new DAX tricks. The one that I’m going to blog about today takes me back to my old favourite, the events-in-progress problem. I’ve blogged...
	Webinar: Simplifying your Excel Data David Gainer 06/10/2013 In this week’s webinar you’ll learn how to make a massive sheet of numbers something that can tell a story with just a few clicks. We’ll also show you a better what to show data in a presentation. See trailer now, or...
	Xojo: An Old New Kid on The Block Dennis Wallentin 06/08/2013 Until 4th June this year the company had the name Real Software Inc and their product, a cross-platform developing kit, had the name Real Studio. However, the company name is now Xojo Inc and the product’s name is Xojo. Bob Keeney, founder...
	Gartner EA Conference Summary in Top Influential Tweets Mike Walker 06/06/2013 I usually don’t post recaps of events in their tweets but since I was unable to do full coverage of the event I have picked out what I thought to be the most influential tweets. Lots of good nuggets from...
	TDD I Learned… Code Katas Rod Paddock 06/06/2013 Continuing to make my way through Roy Osherove’s TDD course. There’s an interesting exercise that he introduces to help practice and gain the muscle memory required to do TDD well – the Code Kata. Wikipedia attributes...
	My thoughts on the SharePoint App Model, Office 365, SharePoint Store and the Business of SharePoint Apps Today Andrew Connell 06/05/2013 A few weeks ago I had the opportunity to be the keynote speaker at the SharePoint Summit in Toronto, Canada. Months before when I received the invitation, I was doing a lot of work and thinking around the new SharePoint app model. It wasn't the...
	Excel Styles and formats Simon Murphy 05/31/2013 Hopefully we all know what a disaster zone this area is so I won’t dwell on that is this post. I have a specific question related to an ongoing support incident raised with MS. We have some (admittedly old) workbooks with unusual style...
	Join Access sessions at TechEd in June Erik Rucker 05/13/2013 Join us in New Orleans for Microsoft TechEd North America June 3-6 and in Madrid, Spain for Microsoft TechEd Europe June 25-28. Scott McFadden and Jeff Conrad from the Microsoft Access product team will present on the new Access web app features...
	Lost queries from this week - were they yours? Stephanie Krieger 05/08/2013 Hi everyone! This neglected site is really a legacy site ... I'll be moving it to a new site soon which won't be neglected as this one has been. But in the meantime, I'm so happy that folks keep sending Office questions! BUT - I just returned...
	Virtual Machine Tips for running SharePoint Bil Simser 04/22/2013 Just a few simple Virtual Machine tips when developing in SharePoint My VMs are 40GB in size and pre-allocated. After installing SharePoint, SQL Server, and Visual Studio and all the tools I need I have about 10GB for data which is more than...
	RavenDB – Up and Running @ North Houston .NET User Group Alonso Robles 04/19/2013 I had a lot of fun showing the North Houston .NET User Group how to get RavenDB up and running. Below you will find the enter seven slide presentation. The code used during the presentation is available on my GitHub. This … Continue...
	5th Method’s Jonathan Wynn to Speak on Staffing Your SharePoint Deployment. Bill English 04/18/2013 The 2013 Best Practices Conference for SharePoint is excited to announce that Jonathan Wynn from 5th Method will be speaking on How to Staff Your SharePoint Deployment. Here is the full abstract to his pre-conference session: Are you the midst...
	Announcing: Peltier Tech Chart Utility Jon Peltier 04/14/2013 After months of development, and weeks of frantic testing and fixing and documenting, it’s finally here: The Peltier Tech Chart Utility Six weeks ago I promised that it was coming. I thought it was two weeks away, but I kept thinking of...
	OneNote in schools Chris Pratley 04/12/2013 I came across a couple of very interesting videos from two different schools using OneNote in the classroom and with faculty. I thought you might enjoy. You really see the power of pen/ink, freeform writing surface, capturing images and media, and...
	VBA IDE Tricks – 5 Ross McLean 03/24/2013 A collection of tips for working with user forms this week. 1. Custom Colours. You can define a set of custom colours to use with a forms controls – better still these colours will persist across sessions of the IDE, so you can use them...
	PowerShell: get your external IP address Serge van den Oever 03/16/2013 Needed this in a script to automatically add a firewall rule to my Azure SQL server: $externalIP = (New-Object net.webclient).downloadstring("http://checkip.dyndns.com") -replace "[^\d\.]"
	The SharePoint Team Blog has moved SharePoint Team 02/25/2013 Body: Earlier today, the SharePoint team blog moved to a new home on the Microsoft Office Blogs site:http://blogs.office.com/b/sharepoint/ Going forward, all new SharePoint posts will be published at this location, please make sure to update your...
	Not-So-Lazy Static Constructors in C# 4.0 Avner Kashtan 02/25/2013 A coworker pointed me towards an interesting blog post by John Skeet about the changed behavior of static constructors in C# 4.0 (yes, I know, it’s been a few years
	MVP 2013 Global Summit Maarten van Stam 02/18/2013 In my previous posts I provided a couple of tips based on my experiences from previous Summits. I already mentioned that not all things are the same for each of the Summits. This is also the case for the 2013 edition of the MVP Global Summit. One ...
	Surfing Lessons in Capitola Don Campbell 09/19/2012 I took Abby and Shelby to another surfing lesson yesterday. They had a blast! Look at Shelby hot-dogging.
	Deploying SharePoint on Azure Virtual Machines Whitepaper Paul Stubbs 09/07/2012 There is a ton of interest to run SharePoint on Windows Azure virtual machines. While we are still in preview mode we will continue to put out guidance and help on how to run your SharePoint workloads in Windows Azure. This whitepaper gets you...
	Sharepoint 2013, What’s new ! Mohamed Zaki 08/24/2012 As Microsoft published Sharepoint 2013 preview edition, here is a list with the new stuff in that version as published on this technet article. the new features are grouped into the following categoriese Branding Business Connectivity Services...
	A look into the user experiences around apps for Office and SharePoint Brian Jones 08/06/2012 We're going to have a few posts this week up on the Office Next blog that drill into the new app model from three perspectives: the end user; the developer; and the administrator. This first post that goes into the end user experience is now...
	Dipping Your Toes in the SharePoint 2013 and Office 2013 Preview Goodness Jan Tielens 07/18/2012 If you haven’t been living beneath a rock in the last two days, you probably heard the news we released the SharePoint 2013 Preview and Office 2013 Preview. Since there is already a massive amount of content available on blogs, TechNet ...
	Windows phone tip: See more photos at once by pinching out to get to the ‘filmstrip’ view KC Lemson 05/24/2012 One of my favorite little features we did in Windows Phone 7 in the photos experience was what we call “filmstrip” view. Normally you’re in what we call Single Photo Viewer (SPV), where you see one photo at a time - for...
	SharePoint Connections Berchtesgaden in May Wouter van Vugt 04/17/2012 Body: Just under a month away and the awesome SharePoint Connections event will visit Germany. This year I will host three sessions on SharePoint development. Topics ranging from high level 'component based development' stuff to low level details...
	WordCamp Victoria 2012 Doug Mahugh 01/16/2012 Over the weekend, I attended my first WordPress event: WordCamp Victoria 2012. It was a great opportunity to learn more about WordPress and meet a bunch of people who are passionate about WordPress, blogging, travel, food, beer, sailing and other...
	SPGridView - syntax error: missing operand after ‘X’ operator Mauro Cardarelli 11/01/2011 I was building a custom SharePoint 2010 web part recently and was using the SPGridView to show results in a standard grid. I wanted to add sorting and filtering on the grid (my next blog post will show coding details on this) and used the...
	Getting back to blogging ….. Rohit Puri 09/24/2011 Looking forward to the SharePoint Conference in Anaheim, CA (October 3-6) Video - TechEd 2010 - What's new in Enterprise Search in SharePoint 2010
	SharePoint Server 2010 Business Intelligence Training live on TechNet! Erika Ehrli 09/02/2011 We’ve released a few popular training sets on MSDN and TechNet including: Get Started Developing on SharePoint 2010 SharePoint Advanced Developer Training SharePoint Enterprise Search Developer Training SharePoint Enterprise Content...
	Todd’s Speaking Schedule at SPTechCon Boston Todd Bleeker 06/01/2011 Wednesday, June 1 8:30-5:00: SharePoint 101 The Developer (W-2 in Back Bay A) This session is a day-long overview of development on the SharePoint 2010 platform. Increasingly, organizations are developing SharePoint based solutions. This workshop ...
	Get Started Developing for SharePoint Online & Office 365 Ty Anderson 05/27/2011 My company has been a subscriber of Microsoft’s current Office cloud offering (BPOS) for a over a year. It’s great in a lot of ways: It’s easy to administer It bundles Exchange, SharePoint, & Live Meeting It includes a nice single sign-on...
	SP1 Fix Affecting 64 bit Solutions in Access Frice 05/23/2011 We are on-track to deliver SP1 in mid-summer 2011 (here is the official announcement). We definitely recommend this update for all Office 2010 users. If you’re one of the few 64-bit Access users working with compiled Access databases...
	Working with VSTO 2008 Projects in InfoPath 2010 InfoPath Team Blog 04/14/2011 The InfoPath team is busy working on the next version of Office. While we’re offline, we’d like to take the opportunity to tackle some of the questions that we get asked frequently by InfoPath...
	Windows Azure Platform at Mix11 James Conard 03/18/2011 On April 12th – 14th Microsoft will hold the annual Mix conference in Las Vegas. The Mix conference is just that – a mix of topics ranging from design to development and from HTML5 to the cloud, with a few Phone and MVC sessions thrown...
	How to treat spaces/single quotes in Sheet names in REST Shahar Prish 10/05/2010 When using REST to access portions of a workbook, people sometimes use direct addressing (Sheet1!A1). I thought I’d drop a line about the icky way this works when you have single quotes in your sheet name. Reminder… First – a short reminder. This is...
	Another Approach to Risk Matrix Calculation Gord Schmidt 09/30/2010 I just read Alexander Burton's post on EPMSource.com entitled Encoding a Risk Matrix in Project Server. I saw where he was going with it, but I thought there might be an easier formula to produce the same output. My thought was to use numbers and...
	The Innovation Decision John Durant 08/11/2010 For over a decade I have enjoyed so very much being a leading voice for custom solutions that integrate with Microsoft Office. The last 7 ½ years of that time have been as a Microsoft employee gleefully carrying my blue-badge with me all...
	VSTO performance tips Misha Shneerson 06/03/2010 If you are writing a VSTO customization - make sure you aware of this performance tip courtesy of Steve Peters - developer on the VSTO team. This tip allows to prevent VSTO runtime from reflecting on your entry point assembly. We see considerable...
	Office 2010 Released to Manufacturing! Ryan Gregg 04/19/2010 On Friday we signed off on all of the Office 2010 products, including Outlook 2010 and have released them to manufacturing! A journey we started 3.5 years ago is complete! Outlook 2010 is the best version of Outlook ever, including a number of great...
	Webinar: How to Drive User Adoption When Migrating Exchange Public Folders to SharePoint Eric Legault 04/15/2010 Join me on April 22nd when I’ll share tips and tricks to help you succeed in your EPF migration project by ensuring high end-user adoption. REGISTER - https://www2.gotomeeting.com/register/932286555 This webinar is for you if your organization has...
	Implementing XSL predicates or filters on InfoPath Forms Server 2010 Don Reamey 01/21/2010 If you downloaded the beta version of InfoPath Forms Service as part of SharePoint 2010 then you will get the chance to try out filtering data in browser forms. Filtering is supported on the following controls: Repeating...
	2009 SharePoint Toolbox Review dwinter 12/21/2009 SharePoint Administration Toolkit (version 3.0 and version 4.0): We released the fully supported toolkit twice this year. The 3.0 release contained the first version of the SPDiag tool. We published a How-To...
	2009 SharePoint Toolbox Review Dan Winter 12/21/2009 SharePoint Administration Toolkit (version 3.0 and version 4.0): We released the fully supported toolkit twice this year. The 3.0 release contained the first version of the SPDiag tool. We published a How-To...
	Exchange Server Forums Chris Meirick 12/04/2009 There are many blogs, tutorials, and information sites available for Microsoft Exchange information. Where do you go if you have a non-urgent question regarding Exchange configuration, features, third-party applications or general Exchange and...
	VB Code Samples for the VSTO for Office 2007 Book Now Available Eric Carter 11/18/2009 I wanted to make sure everyone knows that VB code samples for the VSTO for Office 2007 book are now available. You can download them...
	SharePoint 2010 Developer Documentation Now Live on MSDN! Andrew May (Microsoft)10/19/2009 (Cross-posted from the SharePoint Developer Documentation Team blog.) By now you’ve probably been hearing some of the big news coming out of the SharePoint Developer Conference being held this week in Las Vegas. Doubtlessly, there’ll be...
	TFS 2008 export to Project 2010 beta1 Andrew Ma 09/21/2009 Last week, I was fighting with TFS 2008 export to Project for a while and was unable to find a resolution anywhere. Turns our that I had MS Project 2010 beta1 installed and upon switching to Project 2007, it started working again. Hope this might be...
	Time to Jump Ship Andrew Whitechapel 08/30/2009 I've been working in the Office Development space for over 10 years now, and I finally decided it's time for a change. So, I'm leaving my current team and heading over to a new job in Xbox. I expect that will change the nature of my blog posts - the...
	Office 2010: New Product, New Blog Jensen Harris 07/17/2009 Since we signed off on Office 2007 in October 2006, we've been hard at work on the next version, Office 2010. As successful has Office 2007 has been, it represented but a first step in our journey towards rethinking the user experience of Office....
	Publisher 2010 Tech Beta - read more on the Publisher Team Blog Jeff Bell 07/13/2009 The Publisher Team Blog is now the place to go for the product team's thoughts on Publisher, both released versions and public betas. I've just put up a post there on the Publisher 2010 Technical Beta that is now available to invited beta...
	A New Vision of Productivity Gus Collazo 03/11/2009 Just found this very nice online presentation by Stephen Elop, President of Microsoft's Business Division. He lays out his vision of how Microsoft can help increase productivity in our daily lives. In this economy, companies that step forward and...
	Microsoft Enterprise Search Roadmap with FAST John Roe 02/10/2009 Today at the Fast forward conference Microsoft announced their product roadmap for enterprise search. It includes two new products to be released with the Office 14 wave. The first is FAST search for SharePoint which is basically FAST ESP 5.3x tuned...
	Dallas Cowboy letter proved fake by calibri OfficeRocker 02/05/2009 Check out the story here about a Lucille Hester who was accused of fraud after reading out her half brother’s supposed posthumous letter. The letter said to be written by football star and former olympic sprinter, Bob Hayes, was read out...
	SharePoint Logging and Microsoft’s Trace Log Provider Mike Toole 01/26/2009 Ever wonder how to add entries to the Portal Log? Well, you can do this the easy way by using Microsoft.Office.Server.Diagnostics.PortalLog.LogString but there always seems to be those cases where you want more flexibility than just adding...
	Intro to Performance Point Server... speakTECH-BI 01/19/2009 Hey everyone, if you haven't had a chance to play with Performance Point Server yet, you really should give it a try. Here are a couple of videos to help introduce you to this technology. The first is a walkthrough the product by one of the product...
	Taking a risk Mark Bower 01/02/2009 For around the last year I have been really annoyed with myself for not living up to my full potential. Know the feeling? Perhaps the worst part about achieving some level of success in your chosen career, is that once you have something to lose you...
	MS Business Intelligence Conference Day 1 Greg Dolder 10/07/2008 So I'm up in Seattle, attending the 2nd Annual MS BI conference, and day 1 did not disappoint. Like a great number of attendees, I come to these events with a "show me something new" attitude. That desire was satisfied in...
	My Last Post Kevin Boske 07/17/2008 Friends, this is my last post. I've enjoyed being a part of the Office developer community for the past 4 years and meeting everyone over the past 10 years from the Microsoft side of the fence. My next part of the journey...
	The New World Dick Moffat 06/21/2008 I ran into an old client today at the grocery store (sounds like a song by Dan Fogelberg ?). He works in IT for the Hospital Authority in our city. Years ago I used Access to do some conversions for them from an old HR system...
	Thank you for all of the comments and suggestions Melissa Macbeth 05/31/2008 Dear readers, Thank you for all of your suggestions and feedback to this blog. There will not be any new posts to this blog in the near future. To see more about what is going on now in Outlook, I highly recommend the Outlook Team...
	I'm Back -- Just In Time To Move On... Mike Fitzmaurice 05/22/2008 The good news is that I'm going to be blogging again. The not-exactly-bad news is that I'll be blogging over at http://mikefizmaurce.wordpress.com. Actually, that's good news. I'll be blogging elsewhere...
	Office: Put Your Document Name on the Title Bar or the Clipboard The Office Letter 03/02/2008 We explain two macros that help you extract and use the full path and file name of your current document.
	Kerberos & Sharepoint Bruce Sandeman 02/28/2008 Some useful links that help guide a configuration of SharePoint when using Kerberos... How to configure a Windows SharePoint Services virtual server to use Kerberos authentication and how to switch from Kerberos authentication back to NTLM...
	ODC rocked the house! Joanna Bichsel 02/15/2008 The Office Developer Conference finished on Wednesday and it was unbelievable! Jay Paulus, Director of the Office Platform Strategy team kicked it off to a great start. Following that, Bill Gates talked saying: "Making Office into a...
	Cleaning things up Omar2 02/11/2008 So the site in final beta form was released yesterday. The last build attacked various small issues and also allowed us to clean up some of the code and implement some things in a better fashion. Blog AggregatorFor example, we...
	Best places to get XPS Info Andy Simonds 12/12/2007 Since I moved over to the Office team this blog (primarily focused on XPS) is not very active. If you are looking for the latest info on XPS, here are some helpful links: XPS implementation information at http://www.microsoft.com/xps XPS in...
	speakTECH acquires the OfficeZealot.com site Steve Hansen 10/16/2007 Office is so much more than the client tools that many of us started with and while we have done our best to keep up with the demands, OZ really needs some new blood and additional muscle to grow its feature set and deploy some much needed updates....
	Aberdeen Report: Companies See Increased Productivity Through the Convergence of Enterprise Applications and Desktop Tools Michael Kiselman 10/15/2007 In case you have missed this aricle on MoneyCentral: "The integration of desktop tools with enterprise applications is a two-way street that brings personal productivity, which in turn translates to improved corporate productivity. Aberdeen, a...
	Excel Services Calculation Issue Update & Fix! Luis Bitencourt-Emilio 10/10/2007 Please check out David's post for links to the fixes. http://blogs.msdn.com/excel/archive/2007/10/09/calculation-issue-update-fix-available.aspx...(read more)
	Purple Cafe Julie Kremer 09/07/2007 John Peltonen was right. I was wrong. However, we both agree that Andrew Whitechapel sucks for standing us up.
	Update for Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System (VSTO 2005 Second Edition) Now Available! Mike Hernandez 07/19/2007 Windows Vista vastly improves overall quality, security, and reliability as compared to previous versions of Windows. Though there are tremendous investments in Windows Vista to ensure backward compatibility, some system enhancements, such as User...
	New official Outlook Team Blog is up! Michael Affronti 06/13/2007 Hey hey - we've pooled our resources on the Outlook team and created a single Outlook Team Blog. We'll be having folks from the whole team posting and discussing tips, tricks, and resources about Outlook. Check it...
	It depends on what the definition of "this" is Robert Green 05/18/2007 I was perusing the VSTO MSDN forum a couple days ago and I saw Add a command button to the send email screen. This person (Bear23 to be exact) wanted to add a button to an Outlook 2003 Inspector. Well, not only do I know how to do this, but I have...
	Office Zealot is giving away an Acer Ferrari Laptop! Ryan Bedell 04/12/2007 We want to thank all the Office Zealot readers for their support over the years! We are giving away an Acer Ferrari laptop loaded with Windows Vista. We recently had a chance to review this laptop and now that we are done, it is...
	Word 2003 XML Viewer Control v1.0 released Oleg Tkachenko 03/26/2007 I was cleaning up my backyard and found this control I never finished. So I did. Here is Word 2003 XML Viewer Control v1.0 just in case somebody needs it. It's is ASP.NET 2.0 Web server control, which allows to display arbitrary Microsoft...
	My first only WSS3 blog Sharepoint info 03/24/2007 How to put Sharepoint slides into Sharepoint, you'll need office 2007 but, <a href="http://www.sharepointblogs.com/ssa/archive/2007/02/21/publishing-sharing-and-searching-powerpoint-files-in-sharepoint.aspx">here's...
	The Five Ways of Learning Melanie Spiller 02/10/2007 Have you ever felt that other people seemed to be collecting more information than you, and learning it faster and retaining it longer? Or maybe that you were the only one following along, and everyone else seemed to be scratching their heads? Or...
	Do You Share Diagrams On A Server? Eric Rockey 01/26/2007 Do you ever put Visio diagrams on a SharePoint site, Web site, or file server so you can easily share them with others? Are you making use of Visio 2007’s Data Link and Data Graphics features? If so, the Visio Product Planning department would like...
	Rebuilding Perfmon counters on XP Vijay Desai 10/20/2006 Perfmon is an extremely handy utility to track application performance. When tracing the performance of .NET applications(VSTO/IBF) on the Office platform, I find the counter counter "# of Stubs" provided by the performance object ".NET CLR...
	MSFP and Motorola Q come to Canada Michael Reinhart 10/12/2006 Check out my post on this topic.
	New icons of Microsoft Office 2007 Beta 2 TR Alexander Gorlach 09/18/2006 New icons of Microsoft Office seems very good, but still not in the vector format:
	Windows Live WiFi Laura J 08/25/2006 While I've been away from this blog, I've been working with the MSN Access team. We provide dial-up access to a ton of users across the United States but we've also been working on a stealth project that we're now ready to Beta -- Windows Live WiFi....