Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query Update
I have an Excel file which use a Web Query to update data which is hosted
from a MS SharePoint site. The update query was working fine until a few days ago. When I click the "Update Data" button, code stops at the following line Selection.QueryTable.Refresh BackgroundQuery:=False When I go the SharePoint site directly and right mouse click and choose Export to Excel, Excel opens and then gives me the following message: Data could not be retrieved from the database. Check the database server or contact your database administrator. Make sure the external database is available and then try the operation again. The database is up and running. Does anyone have any ideas of what the problem might be. Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UPDATE Query | Excel Worksheet Functions | |||
update DB via MS Query from WS | Excel Discussion (Misc queries) | |||
Update Query | New Users to Excel | |||
Update Web Query | Excel Discussion (Misc queries) | |||
After Query Update | Excel Programming |