January 2009 - Posts
Today’s author, Ben Rampson, a Program Manager on the Excel team, talks about cleaning up spreadsheets. I often receive files demonstrating issues customers are experiencing with Excel. Recently I have noticed a common problem in some of these files that
Read More...
Many of you might have heard or seen posts about a recent change to the Microsoft BI Vision & Strategy, namely, PerformancePoint will no longer be sold as a separate SKU but rather be part of the SharePoint Server enterprise offering, and the specific
Read More...
I thought this would be interesting to share to see how other Excel folks might have solved this problem. I got a question recently from a customer asking how to automatically take a set of values in one column, say: 1000 5000 600 and repeat each value,
Read More...
If you use Excel to track identification numbers (serial numbers, tracking numbers, etc.) you may find that if the IDs have more than 15 digits, Excel loses the digits after the 15th and makes them all zero. In other words, type "123456789123456789" into
Read More...
I've decided to start posting some of the replies I send to customers who write me asking for help on how to do something in Excel or Excel Services, especially those which I think might be solutions to problems others are likely to have. For my first
Read More...
Today's author, Eric Patterson, a Program Manager on the Excel team, describes how to use Excel Tables as a source for a mail merge – a great productivity tool for sending out holiday greeting cards! :) Eric wrote this before the holidays but unfortunately
Read More...
This is a common question we hear from customers. The answer: calculation ambiguity with linked cells. If you had a cell ='[Book1.xlsx]Sheet1'!$G$33 and you had two books named “Book1” open, there’s no way to tell which one you mean.
Read More...
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
Read More...
