@abach wrote:
Do you mean "Refresh Data"? You may want to search for an .xlb file and rename it. Restart Excel and see if the menu item is enabled.
@abach wrote:
Do you mean "Refresh Data"? You may want to search for an .xlb file and rename it. Restart Excel and see if the menu item is enabled.
The window is named 'Query Refresh'. The message in the window is:
"This workbook contains queries to external data that refresh automatically.
Queries are used to import external data into Excel, but harmful queries can be used to access confidential information or write information back to a database.
If you trust the source of this workbook, you can enable automatic query refresh. If you disable automatic query refresh, you can later refresh queries manually, if you are satisfied that the queries are safe."
Two buttons are shown:
Enable automatic refresh
Disable automatic refresh
The problem is that what ever button you click, the same message appears everytime the program is run.
The window is named 'Query Refresh'. The message in the window is:
"This workbook contains queries to external data that refresh automatically.
Queries are used to import external data into Excel, but harmful queries can be used to access confidential information or write information back to a database.
If you trust the source of this workbook, you can enable automatic query refresh. If you disable automatic query refresh, you can later refresh queries manually, if you are satisfied that the queries are safe."
Two buttons are shown:
Enable automatic refresh
Disable automatic refresh
The problem is that what ever button you click, the same message appears everytime the program is run.
Thanks for responding so quickly. I am using a web query.
Here is the code
TmpV = "http://www.futuresource.com/ifs/quotes.asp?cID=wsj&symbols=usd"
TmpW = "http://www.futuresource.com/ifs/quotes.asp?cID=wsj&symbols=rhg"
Application.ScreenUpdating = True
Worksheets("MKT").QueryTables(1).EnableRefresh = True
Worksheets("MKT").QueryTables(1).Refresh BackgroundQuery:=False
Worksheets("MKT").QueryTables(2).Refresh BackgroundQuery:=False
For Each QryTbl In Worksheets("MKT").QueryTables
QryTbl.Refresh
Next
DoEvents
In Excel 2000, the message 'Refresh Query' appeared once when I first ran the program.
I created a worksheet and wrote the code you provided. I get the 2 tables, one for Treasury and the other for Copper. Prompted once, checked the "Do not show" and never was prompted again.
Did you create this workbook in Excel 2003 and open it in Excel 2000?
You don't need the Application.Screenupating=True line in your code unless you've turned it off elsewhere.
My problem is that I never get the message 'Do not show'. I continually get the message that I detailed, word for word, and which only contains the 2 buttons I described.
Why does my Office 2003 not have the checkoff for 'Do not show'.
Yes, the Application.Screenupating=True was turned off in an earlier part.
Thank you for your prompt response.
Do you have an idea of how I may overcome this problem?
g_pitch
5 Posts
0
November 10th, 2005 13:00
The window is named 'Query Refresh'. The message in the window is:
"This workbook contains queries to external data that refresh automatically.
Queries are used to import external data into Excel, but harmful queries can be used to access confidential information or write information back to a database.
If you trust the source of this workbook, you can enable automatic query refresh. If you disable automatic query refresh, you can later refresh queries manually, if you are satisfied that the queries are safe."
Two buttons are shown:
Enable automatic refresh
Disable automatic refresh
The problem is that what ever button you click, the same message appears everytime the program is run.
No .xlb exists on my system.
abach
1.7K Posts
0
November 10th, 2005 13:00
g_pitch
5 Posts
0
November 10th, 2005 18:00
"This workbook contains queries to external data that refresh automatically.
Queries are used to import external data into Excel, but harmful queries can be used to access confidential information or write information back to a database.
If you trust the source of this workbook, you can enable automatic query refresh. If you disable automatic query refresh, you can later refresh queries manually, if you are satisfied that the queries are safe."
Two buttons are shown:
Enable automatic refresh
Disable automatic refresh
The problem is that what ever button you click, the same message appears everytime the program is run.
No .xlb exists on my system.
abach
1.7K Posts
0
November 10th, 2005 18:00
g_pitch
5 Posts
0
November 10th, 2005 20:00
Here is the code
TmpV = "http://www.futuresource.com/ifs/quotes.asp?cID=wsj&symbols=usd"
TmpW = "http://www.futuresource.com/ifs/quotes.asp?cID=wsj&symbols=rhg"
Application.ScreenUpdating = True
Worksheets("MKT").QueryTables(1).EnableRefresh = True
Worksheets("MKT").QueryTables(1).Refresh BackgroundQuery:=False
Worksheets("MKT").QueryTables(2).Refresh BackgroundQuery:=False
For Each QryTbl In Worksheets("MKT").QueryTables
QryTbl.Refresh
Next
DoEvents
In Excel 2000, the message 'Refresh Query' appeared once when I first ran the program.
abach
1.7K Posts
0
November 10th, 2005 22:00
I created a worksheet and wrote the code you provided. I get the 2 tables, one for Treasury and the other for Copper. Prompted once, checked the "Do not show" and never was prompted again.
Did you create this workbook in Excel 2003 and open it in Excel 2000?
You don't need the Application.Screenupating=True line in your code unless you've turned it off elsewhere.
Message Edited by abach on 11-10-2005 07:12 PM
g_pitch
5 Posts
0
November 11th, 2005 00:00
My problem is that I never get the message 'Do not show'. I continually get the message that I detailed, word for word, and which only contains the 2 buttons I described.
Why does my Office 2003 not have the checkoff for 'Do not show'.
Yes, the Application.Screenupating=True was turned off in an earlier part.
Thank you for your prompt response.
Do you have an idea of how I may overcome this problem?
Thank you, g_pitch