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.
Pivot4U is an add-in for Microsoft Excel. Once installed, it allows you to enter or edit data in pivot tables directly. Just go to the Add-Ins tab of Excel, select Pivot4U On, set the cursor on any cell in the table and change its value. You can change data in the cells, subtotals row or Grand Totals column. Once the value is changed, all totals are recalculated automatically. Editing cells in pivot tables is fairly easy right out of the box.
Version 1.3 adds better compatibility with non EN-US regional settings.