Question QUESTION: My Excel Interface is importing external source data.
I have created manual button to refresh the excel sheet when ever user changes/updates the external source data values.I just want to make this function/event as automatic event.I tried with on-time method but my excel application is getting hanged,I really apreciate if you provide me solution to acheive automatic
ANSWER: Hi Babu,
There is no need for a macro, you can set the query properties so that it updates itself at an interval you choose.
---------- FOLLOW-UP ----------
QUESTION: Thanks for your reply,I did not understand you reply can you eloberate it.what does query properties meant?where it is
Answer Hi Babu,
Apologies for not explaining!
In Excel 2003, click anywhere in the querytable. Then make sure the "External data" toolbar is visible (View, Toolbars, External data). The Second button on that toolbar is named "Data Range Properties. Use that button.
Excel 2007: Select Table, click on the Table Tools tab, find the same button in the "External Table Data" group (top-right button in that group).
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
