Mega Code Archive
Select the calculating options
<![CDATA[
Click the Office button, and then click Excel Options.
In the left pane, click Advanced.
Click the When calculating this workbook list arrow, and then select the option:
Update links to other documents. (Default on).
Set precision as displayed.
Use 1904 date system.
Save external link values.
]]>