Find Pivot Table Source Data + more Excel tips
March 24, 2015
Find and fix the source data for a pivot table, when you run into problems. See how it works, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
After you create a pivot table, you might add or change records in the source data. Sometimes the pivot table does not update correctly, to show the new data. Or, you might not even be able to find the source data, in a large workbook.
To help with these problems, I've added a new page on my Contextures site, with tips for finding and fixing the source data for a pivot table.
Read the details on my website, and watch the video, to see how it works: Find and Fix Pivot Table Source Data
Here are a few of the Excel articles that I read recently, that you might find useful:
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
On a worksheet, you can enter dates and times that will update automatically, when the file opens. Those are helpful if you always want the current date, or date and time, to print. If you want the date/time to remain locked, you can use keyboard shortcuts to quickly enter them.
Click here to watch the short video that shows the date and time data entry tips: Enter Dates and Times
Now that spring has officially arrived, it's time to start the garden. It's still too cold to plant outdoors, but we bought some seeds, and little peat pots, and got started indoors. We planted tomatoes, lettuce, basil and parsley, and it will be fun to watch them grow.
Last Thursday, I got an email from Chris W., who has been through the 3 courses at Excel University -- an online Excel training course designed specifically for accountants. Chris was very impressed with the content, and the customer service, and said that I could share his comments:
That's it for this week! If you have any comments or questions, send me an email.
Last updated: January 25, 2020 4:29 PM