Refresh Data

[Guest]

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"

 

[JP]

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

 

[Ronald Dodge]

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

 

[rajarak15]

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







- Show quoted text -

Hi,

I've imported data from an Access 2003 DB to an Excel 2003.
I also use "Named Range" in the spreadsheet for my pivot tables.

As soon as I create a Named Range, my "Refresh Data" icon in the
spreadsheet is greyed out!!

I want to refresh the external data and to update pivot table based on
named range.

Please let me know if you can help me in enabling the same.


Regards,
KK