Pivot table refresh help!!!

mashhood

New Member
Joined
Dec 24, 2013
Messages
47
Hi all,

Im using excel 2007 . . . ;(

I have a data base with the name Cost of Goods sold (COGS). . . Its a Table made using excel Table option. . .

& I have a pivot table of this database in seperate sheet. . Pivot-COGS.

MY PROBLEM is that when ever i make changes in the database i have to refresh the pivot table every time to see the new change . . Is there a solution that will auto refresh the Pivot Table instead of manually doing it. . .

Dont want VBA or MACROS

Thanks and HAPPY NEW YEAR :)
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Watch MrExcel Video

Forum statistics

Threads
1,099,055
Messages
5,466,307
Members
406,474
Latest member
osama beskales

This Week's Hot Topics

Top