M
Mike
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
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