How do I link Microsoft® Excel® and Word documents in CCH® ProSystem fx® Engagement or Workpaper Manager?
Creating links between Microsoft® Excel® worksheets and Word documents is a common practice either through OLE (Object Linking & Embedding) or embedding a Microsoft® Excel® sheet in Microsoft® Word. For the best results, the following recommendations have been written:
- When creating an OLE link between documents inside of Engagement or Workpaper Manager:
- All of the linked documents need to be inserted and opened from the same Engagement or Workpaper Manager binder prior to linking in order for these files to pass and link properly when synced to other local file rooms.
- If the documents are linked are stored outside of the binder you will have issues when the file is passed to a machine that does not have access to the linked document path.
- "The document contains links that may refer to other files. Do you want to update this document with the data from the linked files?" when opening Microsoft® Word workpapers from CCH® ProSystem fx® Engagement or Workpaper Manager.
- customers should be using the Paste Link > Microsoft Office Excel Worksheet Object format.
- Other link options (such as Unformatted Text and Formatted Text) should not be used, as this creates a link that may not be as stable as the Microsoft® Excel® Worksheet Object.
- All of the linked documents need to be inserted and opened from the same Engagement or Workpaper Manager binder prior to linking in order for these files to pass and link properly when synced to other local file rooms.
- Worksheet tab names in Microsoft® Excel® should not contain spaces.
- Spaces in a tab name may cause the Named Range to be replaced with absolute cell references causing the OLE links not to expand when rows and columns are added in Microsoft® Excel®.
- After creating the OLE link, the Layout option of the link should always be In Line With Text.
- To check this, right-click on the link (in Microsoft® Word), and select either Picture or Format Object, depending on the version of Microsoft® Word. Look at the Layout tab, and make sure that the Wrapping style is set to In Line With Text.
- After creating the OLE link, do not resize or move the link.
- Resizing or moving the link will cause the Wrapping style setting to change, resulting in an unstable link.
- All sizing and formatting should be done within Microsoft® Excel® prior to linking to Microsoft® Word.
- If encountering a formatting issue or display issue with the OLE table in Microsoft® Word please follow the article to troubleshoot:
- To make the OLE links create with the proper Wrapping style, set the default link insert format to In Line with Text.
- To do this, select File > Word Options > Advanced. In the Cut, Copy, and Paste section, set the option for Insert/Paste Pictures as to In line with text.
- Embedding Microsoft® Excel® objects.
- This process is done by selecting Insert > Object > Microsoft Office Excel Worksheet.
- This places a mini-spreadsheet into the Microsoft® Word document.
- This mini-spreadsheet has some basic Microsoft® Excel® functionality, such as formulas. However, no CCH® ProSystem fx® Engagement, Workpaper Manager, or TB Link functionality is available within this area.
- Having issues with the linked Word document opening slowly?
- Try to open the linked Excel documents first and then the Word document.
- This should speed up the process as the Word would have to open and refresh the Excel file in the background if opened alone, but can use the already open instance when already in a visible instance of Excel.
- Try to open the linked Excel documents first and then the Word document.
Note: When converting documents from DOC to DOCX, it is important to understand that there are limitations that occur with OLE linking. When using the DOCX format, the options for pasting links as Formatted Text, Unformatted Text, and Unformatted Unicode Text cannot be used. The link locations will not be updated. It will cause errors on opening when the file is synchronized between users. For more information, see the article how do I manually convert .xls / .doc documents to the newer .xlsx / .docx format in Engagement.
Solution Id | 000188099/sw28766 |
---|---|
Direct Link |