Skip to main content
Microsoft 365

Microsoft 365 Blog

Recent articles

Published 
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 
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 
2 min read

Windows 7 Volume License and Trial Availability 

Last month we made Windows 7 available to customers with Software Assurance and to MSDN and TechNet Subscribers. Today I am happy to announce two more ways for businesses to get Windows 7 for their deployment and evaluation. Volume License Availability, at a Discount Starting today, businesses can order upgrades to Windows 7 from a
Published 
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 
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: