Question: "Help! I use Word and Excel to prepare documents for the same clients annually. For 2006, I will use the 2005 Word file and save it (using Save As) into a new 2006 file.
"I have many Excel tables linked to my Word documents, so I usually find the first Excel table in the document, double-click on it to open the Excel document, and save the Excel document into the new 2006 file (using Save As). Then, I update that first table, which is now in the 2006 file.
"My problem is that there are many more Excel tables in my document and all the other tables are still linked to the 2005 Excel document. I usually just delete each table (linked to the 2005 file) as I come to it and re-copy & paste (with link) the same table, from the 2006 file. I know you can break the links or change the source of the links, but I have been able to break only one table's link at a time, which takes as long as cutting, recopying & repasting.
"Is there any way of re-linking the entire Excel document to the new 2006 file? The file is exactly the same as the previous year, except that it now says '2006' instead of '2005,' so each worksheet is the same and has the same name. Can anyone out there help?" -- Diana