I am looking ahead to the day I will have reached my network drive allowed
capacity, and forced to offload all my data to a removable disk (CD or DVD).

Trouble is, my Excel files contain external references to files (mostly text
& other Excel files) on the network drive . When I archive the Excel and
link-target files together, how will I change the links to point to the files
in their new location (i.e., the removable disk)?