Excel Roundup 20131111

Here are a few of the Excel articles that I read last week, that you might find useful:

Microsoft has improved the Office Web Apps, and you can read the details on the Excel Team’s blog. The feature that looks most interesting to me is the real-time collaboration in Excel files — you can’t do that in the desktop version.

If you use the MOD operator in Excel VBA, you could run into problems with large numbers. Chip Pearson suggests some alternative formulas and code that you can use.

Dick Kusleika ran into some problems while running code on a pivot table that has calculated items. Lots of problems are caused by pivot table calculated items, in my experience!

If you read any other interesting Excel articles last week, that you’d like to share, please add a comment below.

Please include a brief description, and a link to the article.

________________________

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.