• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Re-linking Excel spreadsheets

by on
in Admin Pro Forum

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, reco...(register to read more)

To read the rest of this article you must first register with your email address.

Email Address:

Leave a Comment