Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tjeerd
 
Posts: n/a
Default This query returned no data

I have created an excel 2003 web query to a web application on the intranet.
To access the web application a name and password are required.
How can I integrate my login name and password into the web query allowing
excel to access the web application and automatically refresh the data?
When I hit 'refresh data' now I get the error:
This query returned no data. To modify the query, click OK, click the name
of the external data range in the name box on the formula bar, and click Edit
Query on the External Data toolbar.

I appreciate any help!

Tjeerd Klaassens
The Netherlands
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Web Query Help... Jambruins Excel Discussion (Misc queries) 1 July 29th 05 06:56 PM
MS Query Data Source Change rasinc Excel Discussion (Misc queries) 2 July 27th 05 07:09 PM
Query Wizard - Filter Data - Dropdown missing? jameshalligan Excel Discussion (Misc queries) 0 July 26th 05 11:21 AM
Get External Data Web Query new worksheet Nina Excel Discussion (Misc queries) 0 April 14th 05 07:08 PM
Query of External Data Excel GuRu Excel Discussion (Misc queries) 2 January 3rd 05 07:43 PM


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"