MS Word-Excel单元格，“更新链接"更改格式.如何保留格式? [英] MS Word - excel cell, "update link" changes format. How to preserve format?

问题描述

我有一个MS单词段落，其中包含一些链接到excel单元格的文本字符串.当我更新链接"时，该单元格失去其格式，在该单元格之前和之后添加了段落.在Word中检查更新后保留格式"选项似乎无效. 保留源格式"和合并格式"粘贴选项在此方面给了我相同的结果.

I have a MS word paragraph with a few text strings linked to excel cells. When I "update link", the cell loses its formatting, with paragraphs added before and after that cell. Checking the "Preserve formatting after update" option in Word does not seem to work. "Keep source formatting" and "Merge formatting" pasting options give me the same result with this.

我用alt + f9检查了Word中的源代码，并搜索了要添加到其中的内容

I checked the source code in Word with alt+f9, and searched for something to add to it

{ LINK Excel.Sheet.12 "Book1" "Sheet1!R1C1" \a \f 4 \h \* MERGEFORMAT }

我按照以下说明进行操作: https://support.microsoft.com/kb/220526 ，方法是在链接源代码中添加* CHARFORMAT \.它不起作用，可能是因为说明适用于Office 2000，而我使用的是2010.

I followed these instructions: https://support.microsoft.com/kb/220526, by adding * CHARFORMAT \ to the link source code. It did not work, likely because the instructions are for Office 2000 and I have 2010.

有人对此有解决方案吗?

Anyone have a solution to this?

谢谢

推荐答案

使用以下解决方案:

主页(标签)>粘贴>粘贴选项>选择性粘贴>粘贴链接>未格式化的文本

Home (tab) > Paste > Paste Options > Paste Special > Paste Link > Unformatted text

这篇关于MS Word-Excel单元格，“更新链接"更改格式.如何保留格式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！