#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 281
Default PivotTable

Hi All,

I have a PivotTable and i need to add daily information to my datasheet and
i want to know that how can i refresh the pivotTable with new data.

any help would be appriciated.

Thanks,
--
Farhad Hodjat
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default PivotTable

Hi

Depending upon your version of Excel, there may be different alternatives.
If you are using Excel 2003, then place your cursor in a cell of your data
sourceDataList
This will create a dynamic range which can the be used as the source for the
Pivot Table.

In Excel 2007, again choose a cell in your Data sourceInsert tabInsert
Table.
Again this will give a dynamic table that will be the source for the Pivot
Table.

The following will work for any version of Excel
InsertNameDefine
Name MyData
Refers to =OFFSET($A$1,0,0,COUNTA($A;$A),COUNTA($1:$1))

Right click on your Pivot TablePivot WizardbackSource=MyData

As you add more rows to your source data, they will automatically be
included within the Pivot Table.


--
Regards
Roger Govier



"Farhad" wrote in message
...
Hi All,

I have a PivotTable and i need to add daily information to my datasheet
and
i want to know that how can i refresh the pivotTable with new data.

any help would be appriciated.

Thanks,
--
Farhad Hodjat



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivottable on web tikchye_oldLearner57 Excel Discussion (Misc queries) 0 February 22nd 07 12:17 PM
Pivottable nc Excel Discussion (Misc queries) 4 October 4th 05 02:16 PM
Pivottable %'s jmenche Excel Discussion (Misc queries) 1 June 8th 05 02:40 PM
PivotTable Help G Excel Discussion (Misc queries) 3 May 31st 05 03:25 PM
PivotTable Marek G Excel Discussion (Misc queries) 1 May 7th 05 12:50 AM


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"