Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
David Billigmeier
 
Posts: n/a
Default How do you replace old data with new data without creating a new .

Hit the "Refresh Data" in the pivot table toolbar (looks like an exclamation
point)
--
Regards,
Dave


"Dena" wrote:

I have existing pivot tables and I want to replace the data source worksheet
with new data and the pivot tables update with the new information. I have
replace the data source but the pivot tables didn't update.

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
Import Data Keeps asking for Password Dominator Excel Discussion (Misc queries) 0 June 5th 05 11:25 PM
Find and replace data in an Excel chart object Cawen Charts and Charting in Excel 2 March 31st 05 06:47 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM
How Can I find and replace symbols in excel data ( white square) alawhizkid Excel Discussion (Misc queries) 1 December 14th 04 10:44 PM
replace data Susan Excel Worksheet Functions 1 November 30th 04 03:17 PM


All times are GMT +1. The time now is 12:32 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"