I have 2 Excel Spreadsheets and 1 Word document:
MS Excel—‘Excel Dump1’
MS Excel—‘Excel Update1’
MS Word—‘Word Test Document’
‘Excel Update1’ is connected to ‘Excel Dump1’ through formulas.
‘Excel Update1’ is connected to ‘Word Test Document’ through Mail Merge.
Suppose that ‘Excel Dump1’ has a new record added to it and is closed…
Is there a way to automatically refresh both ‘Excel Update1’ and then ‘Word Test Document’ to include the new records added… but then to only open (or keep open) ‘Word Test Document’?
If anybody can speak in simple terms and walk me though this one, it would be a huge help.
My applications are attached.