Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default Data is not refreshing-Excel 2003

I have a pivot table from a data source which I update monthly. I added data
for this month, but am unable to get the tables to update. I have check the
data fields in the wizard and seem to have the information correct, it is
just not pull in the new data into my table.

Any ideas?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Data is not refreshing-Excel 2003

Did you click on the "refresh data" icon on the pivottable toolbar.

Is there a chance that your pivottable is based on an exact range and your new
data isn't within that range?

Ronnie wrote:

I have a pivot table from a data source which I update monthly. I added data
for this month, but am unable to get the tables to update. I have check the
data fields in the wizard and seem to have the information correct, it is
just not pull in the new data into my table.

Any ideas?


--

Dave Peterson
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
Excel 2007 Conditional formatting not refreshing as it did in 2003 Elardus Excel Discussion (Misc queries) 1 September 24th 09 09:14 PM
Excel 2003: VLOOKUP not refreshing watermt Excel Worksheet Functions 3 September 18th 09 06:28 PM
Refreshing 2003 Pivot Table w/ Excel 2007 FloydN Excel Discussion (Misc queries) 0 March 16th 09 02:11 PM
Refreshing Data In Excel / VBA [email protected] Excel Discussion (Misc queries) 0 October 13th 05 10:53 AM
Refreshing Access data in Excel Jimmy G Excel Discussion (Misc queries) 0 December 21st 04 03:53 PM


All times are GMT +1. The time now is 10:49 AM.

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"