Recalc/Refresh issue when posting to Google Spreadsheet using VBA, Google Form
===

I have a Google spreadsheet that has formulas on worksheet sheet1 that are based in a cell A1

A1 contains a formula =lastvalue("Form Responses!B").
Form Responses is a worksheet with the results set of a Google form. 

If I manually use the Google form to append data, the formula in A1 updates immediately as do the dependent formulas in other cells on worksheet sheet1. 

If I update the form using the following MS Access 2010 vba call that uses Microsoft's MicrosoftXML library the new value gets appended and saved to column B on the Form Responses worksheet as it should, but the workbook doesn't refresh or recalculate.

Any suggestions for making this happen?

vba code:
    Dim httpRequest As XMLHTTP
    Dim sGoogleDoc As String
    Dim sKW as string
	
	
    Set httpRequest = New XMLHTTP
    
    sGoogleDoc = "http://spreadsheets.google.com/formResponse?formkey=XYZFORMKEY;ifq"
    sKW = "new value"
	
    httpRequest.Open "POST", sGoogleDoc, False
    httpRequest.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
    httpRequest.send "entry.0.single=" + sKW + "&pageNumber=0&backupCache&submit=Submit"

thanks in advance. 