I found the web query methodology problematic when using authentication on the
notes server since Excel would force you to login to get access to the data. I
found that by modifying the $$ViewTemplate form for the exported view to have
the content type of application/vnd.ms-excel, I get the same export capability
without needing the web query or having to relogin.
This solution works with Excel 2003 and we have used this setting for some time
with our agents for exporting excel data.
I found the web query methodology problematic when using authentication on the notes server since Excel would force you to login to get access to the data. I found that by modifying the $$ViewTemplate form for the exported view to have the content type of application/vnd.ms-excel, I get the same export capability without needing the web query or having to relogin.
This solution works with Excel 2003 and we have used this setting for some time with our agents for exporting excel data.