| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to open after auto refresh(Query) | Excel Discussion (Misc queries) | |||
| REFRESH DATA in all Worksheets upon open of workbook | Excel Discussion (Misc queries) | |||
| Refresh business query on open | Excel Discussion (Misc queries) | |||
| Auto Open, Refresh, Save, Close | Excel Discussion (Misc queries) | |||
| Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
Threaded Mode
