On Monday, Excel MVP Kirill Lapin (aka KL) shared his macro to create a standard pivot table from multiple workbooks (as opposed to worksheets in the same workbook). I promised you a second pivot table macro, and here it is -- in today's example, Kirill combines data from a sales list and price list, stored [...]

If you want to create a pivot table from data on different worksheets, you can use a Multiple Consolidation Ranges pivot table. However, that creates a pivot table with limited features and functionality. Last year, Excel MVP Kirill Lapin (aka KL) shared his brilliant code to create a Union query and build a fully functional [...]

If you've added comments to an Excel worksheet, you have a couple of built-in options for printing the comments.

Show the comments on the worksheet, and print them as displayed.
Print the list of comments at the end of the worksheet, on a separate printed page.

Printing the comments on the worksheet is okay if [...]

Last week, I posted Bob Ryan's Excel macro for formatting a pivot table in Classic style. Bob's macro formats the first pivot table indexed on the active sheet.
Dim pt As PivotTable
Set pt = ActiveSheet.PivotTables(1)
Ideally, you'd only have one pivot table on a worksheet, to prevent problems [...]

My friend and client, Bob Ryan, from Simply Learning Excel, has just published a hands-on, no fluff, Excel book -- Simply Learning Excel 2007: Learn the Essentials in 8 Hours or Less. To celebrate the book launch, I asked Bob to share one of his favourite Excel tips with you, and you can read [...]

If the customer name is missing from an Excel worksheet order form, you'll waste paper if you print that order form, and then have to reprint it.

Previously, you saw instructions for automatically showing an error message before printing, if data is missing from an Excel worksheet.

Well, it took a long time (okay, half [...]

If you add pictures to an Excel workbook, the file size can increase pretty quickly. And if you're updating the pictures occasionally, perhaps for a product catalogue, you'd have to remember to update all the Excel files that have those pictures.
Instead of adding the pictures to the Excel file, Ron Coderre has created a sample [...]

As the storm clouds rolled in yesterday afternoon, I tweeted about saving my Excel files more frequently, as a safety precaution. There were a couple of responses, asking why I didn't use Excel's AutoSave feature, and Jon Peltier reminded me to use AutoSafe -- Jan Karel Pieterse's free add-in.
I mentioned AutoSafe in my Excel New [...]

In a workbook, you might have some sheets that everyone uses, and other sheets that only one or two people need to use, for Admin functions.
For example, the workbook shown below has a data entry sheet for orders, and two Admin sheets -- one for lists and one for workbook options.

To make it obvious which [...]

Occasionally, I get calls from clients who don't understand why their Excel file isn't working. They're clicking buttons, or selecting from drop down lists, but none of the usual magic is happening. Is the file broken?
When you open a workbook in Excel 2007, a security warning bar might appear above the worksheet, telling you that [...]