Excel 2007 Problems

Posted by : Dexter Panganiban | ; Filed Under Random Post

You are invited to have my FREE RSS Feeds or you may Subscribe to me via emailfor latest information in this website.

There is an interesting post regarding Excel 2007 Bug, I am a big user of Excel and having problems as mentioned in atmaxplorer post is really disturbing. How did Microsoft release this series having this kind of problem? Microsoft excel is a widely used program. If somebody is using Microsoft Excel 2007 and does not know this problem, It will create him a big problem in calculation.

An example of the problem below:

If you multiply 850 by 77.1, the result should be 65535. However, Office 2007’s computations gives out an answer of 10000.

Try it yourselves:

=(850*77.1)

=SUMPRODUCT(850,77.1)

=SUMPRODUCT(850,77.1,2,0.5)

More discussion at the Microsoft Public Excel Google Group about the above mention problems. So I would say Excel 2003 is still the best for me. or maybe some would say that they still use Lotus.

Thanks to Atmaxplorer for the tip.

Iphone with Microsoft Word and Microsoft Excel Features
One of the features the reason why I bought my I-mate PDAL is because of it's Microsoft excel and Mi...
Excel Trick : What is the use of $ sign?
Did you know "$" sign is an important part of excel formula? I would try to teach how you could us...
Excel Tip : What If You forget your Excel Sheet Password ?
From time to time I am sharing some Tips about Microsoft Excel since I am a heavy user of this prog...
Excel Tricks : Hide Those %&@# Formula Errors
Excel Tips : How to Make your Worksheet Name To Appear Into the Cell

About the author

Dexter Panganiban : Dexter is a techie person that also blogs at his Personal Blog " Dexter Panganiban Site ", He is a Mechanical Engineer by Profession. He loves Search Engine Optimization and Making Money Online