Pivot table tip

By Neil Shorney, Director, Naturally Sales Ltd.

When creating a Pivot Table in Excel 2007 or 2010, they can be opened in Excel 2003, but will be read-only. To create a pivot table which is editable in 2003, 2007 and 2010, create it with Excel 2003. You can then edit it with all versions.

We look at pivot tables in more detail in Intermediate Microsoft Excel.