New tool available to edit Excel pivot tables

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.

You may like these other stories...

Regulatory compliance, risk management and cost-cutting are the big heartburn issues for finance execs in the C-suite. Yet financial planning and analysis—a key antacid—is insufficient.That's just one of the...
Continuing its efforts to simplify accounting procedures, the FASB has issued a proposed Accounting Standards Update on customer fees paid in a cloud computing arrangement. The newly-proposed update (Intangibles—...
How are you planning? What tools do you use (or fail to use) for forecasting? PlanGuru is a business budgeting, forecasting, and performance review software company based in White Plains, N.Y. AccountingWEB recently spoke...

Already a member? log in here.

Upcoming CPE Webinars

Aug 26
This webcast will include discussions of recently issued, commonly-applicable Accounting Standards Updates for non-public, non-governmental entities.
Aug 28
Excel spreadsheets are often akin to the American Wild West, where users can input anything they want into any worksheet cell. Excel's Data Validation feature allows you to restrict user inputs to selected choices, but there are many nuances to the feature that often trip users up.
Sep 9
In this session we'll discuss the types of technologies and their uses in a small accounting firm office.
Sep 11
This webcast will include discussions of commonly-applicable Clarified Auditing Standards for audits of non-public, non-governmental entities.