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
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/15285/re-linking-excel-spreadsheets "