retain 'update remote reference' flag
 

I have embedded two excel spreadsheets into a word document. the first
spreadsheet retains the tick the above flag under tools/options/calculation
but the second spreadsheet always reverts to blank when you exit out of the
document