XML Map Refresh on Open

K

KCi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Query to import from Sharepoint 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Importing XML using Stylesheet doesn't allow refreshing 0
Connection/Refresh Control unavailable for imported XML data 0
Need Help with Macro Security 1
Need to stop automatic column re-sizing when importing XML data 0
Cannot Import XML Spreadsheet 2003 with XML Data Source 0
How to XML Map Repeating Rows? 2

Top