I built an Access database which to export the daliy (new) figures to Excel to
the desktop. One of the queries is for pulling all the information for a
Credit Manager (CM). I then need to link this data to a summary spreadsheet.

So each day I want to go to my database, pick the CM's data, export and
replace
the old info with the new, and keep the links I have created when I exported
the first one. When I exported the first, I linked it to a number of
spreadsheets. Any thoughts? I get an error telling me that It cannot expand
the named range. If I rename it then I would have to reset all my links.