Excel Weekly News from Contextures Apr 01, 2014

Pivot table formulas + more Excel tips

In this week's Excel news, you'll see two types of pivot table formulas, and other tips. Thank you for reading the Excel news!

-  Debra ddalgleish@contextures.com

## Image Changes Size After Preview

Recently, I had a problem with worksheet images changing size, after I used the Print Preview window. One logo started as a small square in the corner, and expanded to fill most of the worksheet!

I hope you never run into this oddity, but you can click here to see what I did to fix the problem: Excel Images Change Size After Preview

## Calculated Field vs Calculated Item

After you create a pivot table, you can enhance the results by writing your own formulas, to create calculated fields and calculated items. What's the difference between those formulas? When should you use a calculated field and when should you create a calculated item?

Click here to see how to set this up: Calculated Field vs Calculated Item

## Worst Error Message Ever?

I've seen some confusing error messages in Excel, but this one was definitely the least helpful one that I've ever encountered. It's hard to see, in the screen shot below, but there weren't any words, just the yellow triangle. Have you ever seen anything like this?

Click here to see the details: Least Informative Excel Message Ever

## More Excel Tips

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

• Chandoo challenged us to solve an Excel problem, and find the products with the maximum change in monthly sales. There were 170 comments, with a wide variety of solutions.
• Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.

## Video: Edit a Recorded Macro

It's easy to record a macro while you do something in Excel, such as formatting a pivot table. To make the code more flexible, make a few changes, to remove the specific references.. In this video you'll see the steps for recording a pivot table formatting macro, and then editing the recorded macro.

## Flock of Birds

Last week, while we were driving home, a huge flock of birds swarmed from the field beside the highway. Fortunately, I was holding the camera, and managed to snap a couple of pictures. I was glad that the sun roof and windows were closed!

__________________________

### Contextures Products

Save time with our "Done For You" Excel products.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

________________________

__