Prev: i deleted info in excel then saved. can i recover deleted info?
Next: Run macro only if
From: eva cheng on 25 May 2010 02:14
I am using excel 2003

How can I update the pivot table automatically when I open the workboolk ?

Thanks
--
eva cheng
From: reza on 25 May 2010 03:30
eva...

you can try with this link

http://www.vbaexpress.com/kb/getarticle.php?kb_id=80



"eva cheng" wrote:

> I am using excel 2003
>
> How can I update the pivot table automatically when I open the workboolk ?
>
> Thanks
> --
> eva cheng
From: sidm via OfficeKB.com on 25 May 2010 06:53
eva cheng wrote:
>I am using excel 2003
>
>How can I update the pivot table automatically when I open the workboolk ?
>
>Thanks

Pivot Table Options> Data Options You can choose the option to update
whenever the sheet is opened

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201005/1

 | 
Pages: 1
Prev: i deleted info in excel then saved. can i recover deleted info?
Next: Run macro only if