New tool available to edit Excel pivot tables

Posted by accountingweb on May 13 2008 674 printer friendly

Excel4U.Net Solutions is offering a way to eliminate one of the frustrations of using Microsoft Excel—the inability to make changes directly in the data area of a pivot table.

Pivot tables sort, count and total the data stored in one table or spreadsheet and create a second table showing the summary. They are often used to extract statistical information from raw data. The pivot table is linked to the source data and the cells of the table can be read, but not changed.

Installing Pivot4U allows users to click on the "add-ins" table of Excel, then select Pivot4U. Click on any cell in the pivot table to change its value. Recalculations are automatic.

Pivot4U requirements are Microsoft Office 2007 and .NET Framework 2.0. Go to excel4u.net to try an evaluation version for 14 days.

Voice of the Editor

Even though any accounting auditor would tell you it seems like there are an awful lot of tax accountants out there, surely one-third of the country isn't made up of tax preparers, so it's rather startling news to learn that one-third of Americans like to do their taxes. Who knew?

This Week on AccountingWEB

Bill Walter of Gross, Mendelsohn & Associates and Harold Gaar of TravisWolff LLP weigh in on mobile technology use while employees are at work.

WestArk RSVP and Fayette County Community Action Agency – organizations that received grant funding through the IRS Tax Counseling for the Elderly (TCE) program – spoke with AccountingWEB about how they assist senior citizens in their communities.

CPA Robert Raiola, who heads the Sports & Entertainment Group of Fazio, Mannuzza, Roche, Tankel, LaPilusa, LLC, talks NFL player income taxes with AccountingWEB.

Retiring KPMG Centennial Professor of Accounting at the University of Texas at Austin McCombs School of Business Robert May, PhD talks with AccountingWEB about his rewarding forty-three-year career.