Re: Refresh Data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JP <jpena@xxxxxxxxxxxxxxxxxxx>
Date: Mon, 19 Nov 2007 06:18:17 -0800 (PST)

Do you mean a pivot table? You should be using dynamically named
ranges to define the input for your pivot table, so when you refresh
it automatically picks up new data.

http://www.ozgrid.com/Excel/DynamicRanges.htm

Or are you referring to an external query?

HTH,
JP

On Nov 19, 8:41 am, Beep Beep <BeepB...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I have a workwheet that is using a lookup table. Everything works fine
except when I update (change) the data in the lookup table. I have confirmed
the location of the lookup table but just does not want to update the data in
the worksheet.

The help command tells me to use the refresh data command, however it seems
to have disappeared. Also won't just closing out the file and reopening it
update the data"

Prev by Date: RE: Numbering cells in a range
Next by Date: Importing VBA file into Excel
Previous by thread: Re: Showing the same line when going to another sheet
Next by thread: Re: Refresh Data
Index(es):
- Date
- Thread

Relevant Pages

Re: Refreshing Pivots in multiple tabs
... If Tools>options>Calculation>is set to Automatic, then there should be no need for any pause, as the calculations will have been performed by the time the next refresh occurs. ... understandably, the main pivot will refresh again. ... >>> problem comes when a user would deletes or even hides a tab or copy ...
(microsoft.public.excel.misc)
Re: Macro to Auto-refresh a pivot table
... table to change when my worksheet changes automatically without having ... to hit the refresh button. ... an existing pivot table. ... Lastly, turn the macro recorder off, and look at the code. ...
(microsoft.public.excel.programming)
RE: Code to Refresh inbound data sheets, then Refresh Pivot Tables
... It only updates the data sheets w/new & the Pivots w/old data. ... Then refresh all of the end user's custom pivot tables. ... MsgBox "All Data Sheets are updated, click ok to update Pivot tables" ...
(microsoft.public.excel.programming)
Re: Pivot table hanging on to deleted values
... Debra has a great addin for Pivot Tables, ... "Roger Govier" wrote: ... then do a Refresh of the PT before you try to ...
(microsoft.public.excel.misc)
RE: refreshing pivot tables with a macro
... Sub PTRefresh() ... 'Refresh all pivot tables in this workbook one at a time ... my macro to refresh the pivot tables if possible - currently it does not. ...
(microsoft.public.excel.misc)