XML Map Refresh on Open
 

Hi All,

I have a spreadsheet stored on SharePoint, I have an XML Map in the workbook
that is being generated from another tool (SAS). I can get SAS to drop the
updated XML document where it needs to be, have the Connection Properties set
to 'Refresh data when opening the file'.
The problem however is, the data does not refresh unless I press the
'refresh all' button.
I'm using Excel 2007...
Any ideas why Excel is not refreshing the data when the spreadsheet is
opened from SharePoint?

Thx,
Casey