Setup 'Export to Excel' in Excel 2007 for https site

Hi,

I have a Windows 7 PC running IE8 and Office 2007.  When I try to export a table from our amazon account in IE8 it opens excel and puts some column header details in but not the data in the main table.  

I suspect this is an issue with Https as 'export to excel' works perfectly on other non secure sites/tables.  I have tried the Web query tool in excel and I get an amazon message saying there was a problem and to go back to the previous page.

Are there any settings or trusts that need to be created to allow this to happen.  We have an old XP PC running Office 2003 without any problems.

Many thanks in advance

Jon
 
qjumpAsked:
Who is Participating?
 
qjumpConnect With a Mentor Author Commented:
Closing this question as the issue has gone and I cannot determine which change actually corrected it.
0
 
xmlmagicianCommented:
try to add the https url on the trusted site list
0
 
qjumpAuthor Commented:
Hi,

Tried this without success, and it still appears as though the amazon table is not being detected as a table in the 'New Web Query' window.  There is no yellow box with a black arrow in it.

Thanks

Jon
0
 
qjumpAuthor Commented:
Question closed as issue resolved, but unable to determine the exact correction.
0
All Courses

From novice to tech pro — start learning today.