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"

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
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"

Did you use the "Import External Data" menu option from the "Data" menu to
import the table? If not, then the "Refresh Data" option in the menu would
be grayed out and chances are, it's an Excel table via either a pivot table
or some calculation table.

Me personally, I do not use the "Import External Data" cause it relies on
using MS Query, which then relies on using ADO within Excel. ADO within
Excel is a major memory leaker, which when I attempted to use it a few years
ago, it would work for so long, but then crash prior to all of the various
machine center reports were completed as a result of this memory leak that I
learned about from one of the MS KB articles. I therefore stuck to using
VBA to control the calculations of my various machine center reports.


One more thing to look at. If you have Personalize Menus enabled (default
to yes in Excel), then you may need to click on the double arrow down and
you should see it there at the bottom. To disable this personalized menu
option, right click on the tool bar not on a tool bar button, then click on
"Customize...". Click on the "Options" tab, then checkmark the "Always show
full menus" option.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"Beep Beep" wrote in message
...
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"