Sharepoint 2007 - "Export to Spreadsheet" not working over HTTPS

We have deployed sharepoint 2007 behind F5 LTM. Sharepoint uses a feature in which export to excel which is not working for us in HTTPS environment. Here is the info which i got export to excel feature.

 

********

 

9. Leverage Excel for data management

 

Exporting data to Excel is well-supported in SharePoint and makes graphing and printing convenient (via the Print with Excel and Chart with Excel options). But it's also possible (and may often be desirable) to export data to Excel just for the sake of manageability. The Excel Export function creates an Excel Web query linking to the original data. In this way, you can create spreadsheets that will accept data, and then push that data to SharePoint.

 

This can be done by generating an Excel spreadsheet, then linking the spreadsheet to SharePoint (by using Export and Link to Excel from a Datasheet Task Pane). Once this is done, data can be entered into the spreadsheet and pushed from the spreadsheet to Excel with the Synchronize List option.

 

*********

 

Everything works fine when the VS is configured on HTTP mode. The servers are listening on port 80. The problem is with HTTPS connection only. In standard setup we are redirecting all HTTP requests to HTTPS.

 

POST /it/sites001/_vti_bin/lists.asmx HTTP/1.1

 

Content-Type: text/xml; charset=utf-8

 

SOAPAction: http://schemas.microsoft.com/sharepoint/soap/GetListAndView

 

X-Office-Version: 12.0.6020

 

User-Agent: Microsoft Office/12.0 (Windows NT 5.1; Microsoft Office Excel 12.0.6020; Pro)

 

Host: mysite.mydomain.com

 

Content-Length: 340

 

Connection: Keep-Alive

 

Cache-Control: no-cache

 

Cookie: MSOWebPartPage_AnonymousAccessCookie=80

 

 

 

 

 

{C5B5DCE4-BF3E-4715-9BD8-1A8AA36A5064}

 

{38C6017E-7CE6-4AB3-B3F6-1280E26CD806}

 

 

 

 

HTTP/1.0 302 Found

 

Location: https://mysite.mydomain.com/it/sites001/_vti_bin/lists.asmx

 

Server: BigIP

 

Connection: Keep-Alive

 

Content-Length: 0

 

If i user the uri part above and connect to HTTPS then it is not working.

 

This is the .iqy file which gets generated when you do "export to excel"

 

WEB

 

1

 

http://mysite.mydomain.com/it/sites001/_vti_bin/owssvr.dll?XMLDATA=1&List={C5B5DCE4-BF3E-4715-9BD8-1A8AA36A5064}&View={38C6017E-7CE6-4AB3-B3F6-1280E26CD806}&RowLimit=0&RootFolder=%2fit%2fsites001%2fLists%2fSite%20Provisioning%20List

 

Selection={C5B5DCE4-BF3E-4715-9BD8-1A8AA36A5064}-{38C6017E-7CE6-4AB3-B3F6-1280E26CD806}

 

EditWebPage=

 

Formatting=None

 

PreFormattedTextToColumns=True

 

ConsecutiveDelimitersAsOne=True

 

SingleBlockTextImport=False

 

DisableDateRecognition=False

 

DisableRedirections=False

 

SharePointApplication=http://intranetpp.bmc.com/it/sites001/_vti_bin

 

SharePointListView={38C6017E-7CE6-4AB3-B3F6-1280E26CD806}

 

SharePointListName={C5B5DCE4-BF3E-4715-9BD8-1A8AA36A5064}

 

RootFolder=/it/sites001/Lists/Site Provisioning List

 

 

Can someone also help to understand how sharepoint work when you click on links on the site. If you remove http -> https then the pages remain as http only. Is there any way to make sure that https setup remain all the time?

 

I also read about url rewrite from http -> https. Is this necessary?

 

 

I would appreciate getting some help on this. We have production issues which needs to resolved ASAP.

 

 

Thanks in advance,

 

Vishal