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/ Problem : It is not possible to copy more than one sheet to a new workbook or existing workbook if there is a List (Excel 2003) or a Table (Excel 2007) in one of the worksheets. How to reproduce: In a new workbook with two or more sheets, add a table or a list in one of the worksheets. Select more than one sheet with the CTRL key held down. (Be...

Today’s author is Derek Mang, owner of Systems Solution Developers Inc. You can find more useful tips from Derek on his website: www.officevbasolutions.com . This post shows you how to create a custom popup menu in Excel. Microsoft Excel has lots of popup menus that are made available to the user with a right-click depending on what your doing - hence the term context menu. Right-click on a cell and you get the Excel "cell" popup menu and its available choices. This menu is subject to customization...

Thanks to Chad Rothschiller for helping me put this post together. We’ve spent the last few weeks talking about improvements to the various visualization features in Excel. For the next few posts, I am going to cover some “under the hood” type improvements, things like performance, internal limits, and the like. For this post, I will focus on the work we did to make a 64-bit version of Excel. 64-bit Excel, simply put, is for building really really (really) big workbooks. 64-bit Excel is for those...

I’m back from my vacation (boy, Seattle is really gorgeous during the summer!). Thanks to Sam Radakovitz (Sam Rad) for filling in for me while I was out. And thanks to Ben Rampson and Robin Wakefield for putting together this final post on charting improvements in Excel 2010. In this post I’ll walk through some more of the new charting features available in Excel 2010. These include: PivotChart Interactivity Formatting Enhancements Parity Improvements Limit Increases Pivot Chart Interactivity In...

When you open workbooks downloaded from the Internet in Excel 2010, you’ll enter into the new Protected View . While in this mode, Excel runs in a “sandbox,” which means that you are now better isolated from any malicious code that could be contained within the file. In the past, you had to decide if you trusted the author/origin of the document before viewing the contents. Now, with Protected View, you can make a more informed decision before exposing your computer to potential vulnerabilities....

The Power Tips feature of the Excel Team Blog has started with useful articles from MVPs Ron de Bruin and Jan Karel Pieterse. Thank you both! For everyone else who is interested in contributing to this blog, here’s a quick reminder how the feature works. What’s a Power Tip? A Power Tip can be a code sample, or some other Excel trick that you have learned along the way, and that you think might be useful to others. They can be old favorites or new discoveries. Who can submit Power Tips? Anyone! Can...

Thanks to Ben Rampson for putting this post together. In today’s article I will outline some of the significant new chart improvements that impact performance. In Office 2007 the graphics engine used by Office Charts was replaced with one that could support more complex rendering. A downside of this change was slower performance in certain scenarios relative to Office 2003. For example, supporting anti-aliasing in Office 2007 allows the chart to render smooth lines; however, the computation for smoothing...

Last month, we blogged about Project Gemini, a cool new add-on to Excel and SharePoint that lets you do some powerful data analysis. Well, the first preview release of Gemini is out this month as part of the SQL Server 2008 R2 August CTP. The Gemini product team has started a new blog http://blogs.msdn.com/gemini . Check it out! It has information on how to download the Gemini bits and try it out with Excel 2010.

Over the next three posts this blog will cover some of the charting changes that have been made in Office 2010, many of which are the direct result of customer feedback. As part of the Office 2007 release we overhauled charting throughout Office; however an OM for Word and PowerPoint was not provided. In response to your feedback, in Office 2007 SP2 and Office 2010 we’ve exposed a unified/consistent charting OM within Word and PowerPoint, so that you can write solutions against any of the applications...

A nice video on the SharePoint blog that answers the question: “ what is sharepoint? ”.