Give it Pivot

Power up Excel's PivotTables with this excellent add-in.

Microsoft Excel's PivotTable reports feature is a handy way to view and study large amounts of data quickly from several perspectives. It lets you rotate rows and columns of data to see different summaries, filter the data in various ways, or display the details for any area of your choice. Its chief drawback is an inability to edit data when using it. Excel4U's Pivot4U 2.0 is a handy Excel add-in that lets you enter and edit data directly in PivotTables. You can change the value of data in cells, subtotal rows, or Grand Totals columns. When you're done, Pivot4U automatically recalculates all totals.

Pivot4U installs easily and politely, thanks to a standard Windows installer, and it appears among the add-ins on the Excel toolbar when you open an Excel document. The controls are extremely simple: turn Pivot4U on or off, turn Auto Formatting on or off, and Purchase, which you can use to buy and register the software. There's no Help file per se since it's an add-in, nor is one needed, really; if you're using PivotTables, Pivot4U will probably make sense the first time you open it. You simply set the cursor in any cell, change its value, and Pivot4U automatically recalculates all totals. Pivot a table to a new summary, and Pivot4U has already entered the correct total.

Pivot4U is a fully functional Excel add-in that's free to use for 14 days and is $39.95 to buy. It works with all versions of Windows from 95 to 7, including server editions.

CNET Top 5
Companies Apple could buy with their billions
Apple's sitting on a massive pile of cash. Here are five interesting ways they could spend it.
Play Video
 

Member Comments