Troubleshoot Reports + more Excel tips

Excel Weekly News from Contextures October 21, 2014

In this week's Excel news, you'll see how to troubleshoot with a report diagnostic display, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the articles. If you have suggestions for future topics, please let me know.

 -  Debra -

Dashboard Course

Mynda Treacy's Excel Dashboard course is open for registration, until this Thursday, October 23rd. 

I highly recommend this online course, which has excellent content, and great student support from Mynda.  Her new Power Pivot course is available too, and you can get both courses in a bundle. I'm going through her Power Pivot course right now, and it's a great way to get started with this powerful Excel feature.

BONUS: If you sign up for the course through this link, you can have a copy of any one of my Contextures Products.
When you sign up, type DebraD in the Code box, and email me your receipt number.

Excel Report Diagnostic Display

If you have several pivot table reports in a workbook, you can create a Diagnostics sheet, to make sure all the filters are set correctly, before you print the workbook. AlexJ shares his technique for setting up the monitoring sheet, to save you time and headaches.

Click here to see the details: Excel Report Diagnostic Display

Automatically Refresh a Pivot Table

If you change the source data for a pivot table, the new information doesn't automatically appear in the pivot table -- it has to be refreshed. You can manually refresh it, or change a setting, so some updates are automatic, or use programming to update automatically.

Click here to see the details: Automatically Refresh a Pivot Table

More Excel Tips

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

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

Video: Pivot Table From Multiple Sheets

If Excel data is on different sheets, you can create a pivot table using multiple consolidation ranges. This video shows you the steps to create the pivot table and set up page fields. The result is not as flexible as a regular pivot table, but it does create a summary of all your data.

Guess the Mystery Object

I found this old gadget recently, while cleaning out a drawer. I used it occasionally, long ago, and would need to find instructions before using it again. There is a Canadian quarter beside it (that's a caribou), to give you an idea of the size. It's two pieces of plastic, with a hinge. The wooden handled gadget goes with it. You can see the bottom layer in the close-up view.

Do you know what it is? Have you ever used one? I'll give you the answer next week.


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.




Privacy Policy


Contextures Inc., Copyright ©2019
All rights reserved.