The Microsoft 365 Marketing Team | Author at Microsoft 365 Blog

Published May 10, 2010

1 min read

Download Access 2010 Runtime, Database Engine Redistributable and Source Code Control

Download Access 2010 Runtime, Access Database Engine Redistributable (office connectivity components) 2010 and Source Code Control Add-in for Access 2010 today! Access Runtime 2010 Available in both 32-bit and 64-bit, you can download the Runtime here. It is currently offered in 13 languages and more languages will be offered at a later time. Access Database

Published May 4, 2010

2 min read

New Outlook Hotmail Connector released today

After several months of beta testing, Microsoft Outlook Hotmail Connector 14.0 has officially been released as a replacement for Outlook Connector 12. Outlook Hotmail Connector 14.0 is compatible with Outlook 2003, 2007, and 2010. Why use the Outlook Hotmail Connector? If you have been using Outlook Connector 12.1, you already know that it enables you

Published April 2, 2010

1 min read

Power Tip: Create an AutoNumber field that starts with a number greater than 1

Today’s guest blogger is Luke Chung, President and Founder of FMS, Inc. Luke has written and presented a wide range of topics related to Access over the years. In addition to their many Access related products, FMS offers a wealth of great Access papers, tips, and video on their site. In Microsoft Access tables, the

Published March 8, 2010

4 min read

How to create, view, and share Word 2007 templates

Many of you ask how to create templates, plus how to apply them to another document or share them with other people, so here are the instructions you need to get started! For guidelines on how to create templates that are easy to use or that will print correctly, and for tips on using some

Published February 24, 2010

1 min read

Scatter charts with PowerPivot

Rob over at http://powerpivotpro.com has a interesting post on scatter charts and PowerPivot: At right is a list of all chart types in Excel. But not all of them are supported as PivotCharts. Try to use XY (Scatter), Bubble, or Stock as a PivotChart, and you’ll get an alert saying you cannot create it with

Published January 13, 2010

1 min read

Build your own board game, create playing cards

We recently published an energy calculator template from one of our content partners in Canada, Microsoft Home Magazine. During that process, they let us know about a board game activity that they recently published on their site, and we love it! The online article provides useful how-to steps and it comes with Word and Excel

Published January 13, 2010

1 min read

Cross version compatibility between Access 2010 and Access 2007

Today’s guest writer is Lois Wang—PM for reports and version-to-version compatibility. I saw a question on the Access TechNet Forum the other day that I’d like to share with the community: “I can’t open accdb files in Access 2007 after they’ve been opened in 2010.” Access 2010 brings you many new features (Data Macros, Calculated

Published September 23, 2009

1 min read

Adding Every Other Cell in a Column

Today’s author is Bill Jelen, author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com, which includes more than 300,000 questions and answers about Excel. Jenny asks “Is there a quick way of adding every other cell ?, I have a column

Published September 21, 2009

2 min read

New and Improved Solver

Thanks to Eric Patterson for putting together this post. In Excel 2010, we have made a number of improvements to Solver that make it easy for beginners to get started and more advanced ones to find solutions to all types of problems. The purpose of this post is to review the improvements to Solver, and

Published July 7, 2009

3 min read

Use the VBA SaveAs Method in Excel 2007

Today’s author is Ron de Bruin , an Excel MVP. You can find more useful tips and links to Excel add-ins at his website: http://www.rondebruin.nl/ You see a lot of old SaveAs code that does not specify the FileFormat parameter. In Excel versions before Excel 2007, code without this parameter will not cause too many

Published June 30, 2009

3 min read

Week Numbers in Excel

Today’s author is, Ron de Bruin, an Excel MVP. You can find more useful tips from Ron and links to Excel add-ins at his website: http://www.rondebruin.nl/ There are four primary week numbering systems in use worldwide. Each system has subtle differences that you should be aware of. Excel can work with any of these systems:

Published March 12, 2009

6 min read

Excel VBA Performance Coding Best Practices

Today’s author, Chad Rothschiller, a Program Manager on the Excel team, is back with a follow up from his previous post on VBA and Excel performance. I want to start off this post by thanking everyone who sent in their examples in response to my January request. It is incredibly helpful to be able to

The Microsoft 365 Marketing Team Posts

Download Access 2010 Runtime, Database Engine Redistributable and Source Code Control

New Outlook Hotmail Connector released today

Power Tip: Create an AutoNumber field that starts with a number greater than 1

How to create, view, and share Word 2007 templates

Scatter charts with PowerPivot

Build your own board game, create playing cards

Cross version compatibility between Access 2010 and Access 2007

Adding Every Other Cell in a Column

New and Improved Solver

Use the VBA SaveAs Method in Excel 2007

Week Numbers in Excel

Excel VBA Performance Coding Best Practices

Get started with Microsoft 365