Results for:
Performance

• Working backward: rows to text files

  24 Feb 2011

  You may remember this graphic from my previous post : It was totally staged. A fabrication. Well, the PowerPoint templates are the original files - so it wasn't completely faked. But I added all of the text files back into the folder in order to create the image. As I worked on the previous post, I realized...
• Programmability Improvements in Excel 2010

  27 Jan 2010

  Thanks to Danny Khen for putting together this post. What’s new? Excel has been a platform for developing business solutions for a long time now. Developers write code to customize and extend Excel in many ways – automating Excel operations, user interface customizations, data entry forms and extending...
• More on Performance Improvements in Excel 2010

  8 Sep 2009

  In this second post about our investments in Excel 2010 performance I’m going to wrap up talking about the challenges and opportunities we embraced for this release, specifically on the topics of large data set scenarios, calculation performance and investment in new multi-core features. Large Data Set...
• Performance Improvements in Excel 2010

  3 Sep 2009

  Thanks to Chad Rothschiller for putting together these posts on performance. In this release of Excel we spent dedicated research and development resources on improving performance. In addition to the usual optimizations and tuning efforts we make post “code complete”, we spent time during the development...
• Improvements to Chart Performance

  20 Aug 2009

  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...
• Excel VBA Performance Coding Best Practices

  12 Mar 2009

  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...
• VBA + Excel Performance: Your Feedback Requested...

  7 Jan 2009

  The Excel blog is back after a short break for the holidays. Happy New Year! Today's post comes from Chad Rothschiller, a Program Manager on the Excel team, who is looking at ways to improve performance in the next version of Excel. The Excel development team is currently investigating a number of scenarios...
• What is the fastest way to scan a large range in Excel?

  3 Oct 2008

  Today's author, Dany Hoter, a Product Planner on the Excel team, talks about some performance characteristics he recently discovered using various methods to manipulate large ranges using VBA. Problem description You have a large range in Excel with data. Let's say it contains 100,000 rows and 50 columns...