I have a Word file with some content linked-in from Excel:




{LINK Excel.Sheet.8 "C:\\Users\\tjgx84\\Documents\\Integration\\Angebo te.xlsx" "Supp_Data!R7C4" \a \t}


Everything works fine as long as the text in Excel does not contain a line break.

With a line break (Alt+Enter in xls) the text shows up with quotation marks, like this:



"This text comes from a Excel cell
and has a line break."


The quotation marks are really annoying and after a lot of trying and googling I start to think this is a bug.


I tested a lot of possible switches, such as \h, \p, \f4, \f5, \x, \* MERGEFORMAT but none of them seems to work at all.



Thx in advance to whoever can help.

I'm not seeing that behaviour in Office 2010 (I don't have an Office 2007 installation to test with). Have you tried repairing the Office 2007 installation (via Word Options|Resources|Diagnose)? Is your Office installation fully updated?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I'm working on a company issued pc which gets regular updates via a push service. Manual updates are disabled. MS Word 2007 shows 12.0.6758.5000 SP3 MSO 12.0.6755.5000

I had the same issue and just resolved it.

The key is to click in the text in Excel. I found this behaviour in text cells that had a line break in them. For example, imagine the quotation marks in the following do not exist:

"Text like this will not produce quotation marks"

"Text like this WILL produce quotation marks
"

To remedy this place your cursor on the line break in Excel and press delete to eliminate it. Both the quotation marks and line break in Word will disappear on next update.

Hi Igu

I had the same issue when I needed to include line breaks in material linked-in from an Excel cell to Word. Strangely, if there was a line break then the material appeared in quotes in Word.

The above was happening when using "paste special", "paste link", "unformatted text", but did not do so when choosing "formatted text (RTF)" or "HMTL format". These worked fine despite no RTF or HTML formatting in the source. Using the RTF version changed the switches to "\a \f 4 \r " and I noticed that these switches survived both further formatting in Word of the whole paragraph into which the material was inserted (causing the MERGEFORMAT switch to be added), and also survived saving the Word file and returning to it later.

Altering the switches manually having made them appear using Alt-F9 however, only worked temporarily and did not survive saving the word file and returning to it later. I believe Word must identify that the Link switches have been changed, and if so removes it altogether when saving. If this theory is correct then the only way to get the switches to work without adding quotation marks if the source cell has a "new line" is to use either of the above options in paste special.