LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
zobernjik
 
Posts: n/a
Default how to refresh pivot data


Hey all, I am new to pivot tables...

I have a spreadsheet with a number of worksheets and all of them are
pivot tables presenting data in a different way etc. and one of the
worksheets is the raw data the pivot is based on.

I have added a number of new records and now I would like to refresh
data within those pivot tables, just pressing the refresh option does
not do it, I am thinking since I am not connected to any source but
everything is being done "locally so to speak" I am updating the
currect excel spreadsheet that has to be a more complex way than that.

Anyway I can't quite work it ou.

Can somebody help me please

Thanks:)


--
zobernjik
------------------------------------------------------------------------
zobernjik's Profile: http://www.excelforum.com/member.php...o&userid=29358
View this thread: http://www.excelforum.com/showthread...hreadid=490669

 
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
how do I keep my data series colour when I refresh a pivot chart reghog Charts and Charting in Excel 1 November 29th 05 01:23 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Excel Pivot Table Refresh Question David D Excel Discussion (Misc queries) 2 August 25th 05 01:00 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Pivot Table Data Refresh patemarie Excel Discussion (Misc queries) 1 December 1st 04 04:35 PM


All times are GMT +1. The time now is 03:55 PM.

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

About Us

"It's about Microsoft Excel"