Wednesday, August 5, 2009

Excel into a Word doc

Ever need to insert an Excel worksheet into a Word document and have them linked so that when you update the main Excel worksheet, it automatically updates the one in the Word document?

There are actually two ways to insert an Excel object into Word, linking and embedding. When you embed an Excel worksheet, the worksheet will not be updated when you update the main Excel file.

When you insert a linked worksheet, whenever you open the Word file, the linked Excel sheet will update it’s values to match the main external Excel file.


Post a Comment


Google Analytics

About Me




  • ads
  • ads
  • ads
  • ads

I-Techie Copyright © 2009 This Blog is Designed by Shahid Khan Sponsored by E-How