I have a SharePoint 2010 Environment that uses
Exporting to Excel of a list uses wrong URL.
When I go to the a list, select the list to show the "office ribbon" and then select export to excel, excel will show the error "Excel cannot connect to the SharePoint List".
When I take a look at the IQY file that is created it contains the wrong url:
http://portal.<something>.com instead of
Changing the URL in the IQY file manualy to
https://portal.<something>.com and then opening it will excel is working fine, list data is exported to excel then.
Alternate access mapping is configured to use
https://portal.<something>.com as default, export to access is working normaly. I already deleted the
http://portal.<something>.com alternate access mapping once to see if this fixes the problem. No fix, even not after IISreset or rebooting the server.
Where or how is the export to Excel IQY file created and where is it possible to fix the URL it is putting in the IQY file?
View Complete Post