Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-19-2015, 01:59 PM
mruetz mruetz is offline Strange Issue with Excel Linked Data in Word Windows 7 64bit Strange Issue with Excel Linked Data in Word Office 2007
Novice
Strange Issue with Excel Linked Data in Word
 
Join Date: Dec 2011
Posts: 10
mruetz is on a distinguished road
Question Strange Issue with Excel Linked Data in Word

I have been working on this report in Word where is has linked values from Excel and all has been going fine until I ran into this situation.

I have some text in a cell in Excel for example as follows:
This is sentence 1. This is sentence 2.
It is linked to Word and displays fine in Word, as you would expect:
This is sentence 1. This is sentence 2.
If I change, the data in Excel to put in hard return between the 2 sentences (by hitting Alt-Enter). The data in Excel looks now like this:
This is sentence 1.
This is sentence 2.



However, when I update the link in Word it put quotes around the item:
"This is sentence 1.
This is sentence 2."

Is there anyway to supress these quotes. It has me stumped. If I remove the hard return in Excel and I update the link in Word the quotes go away. Any ideas?

Thanks, Matt
Reply With Quote
  #2  
Old 03-19-2015, 04:05 PM
Guessed's Avatar
Guessed Guessed is offline Strange Issue with Excel Linked Data in Word Windows 7 32bit Strange Issue with Excel Linked Data in Word Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

How did you paste in the link?

I just tested in Word 2013 using a Paste Special (linked) in HTML Format and the quotes didn't appear when I added a second row to the Excel cell.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 03-19-2015, 04:45 PM
mruetz mruetz is offline Strange Issue with Excel Linked Data in Word Windows 7 64bit Strange Issue with Excel Linked Data in Word Office 2007
Novice
Strange Issue with Excel Linked Data in Word
 
Join Date: Dec 2011
Posts: 10
mruetz is on a distinguished road
Default

I did a Paste Special (linked) in unformatted text, but using HTML does seem to work. Thanks!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked Excel Object - Resizing Issue Element PowerPoint 0 02-26-2015 04:16 AM
Word 2010 Field widths from linked Excel data. DPB Word 1 06-25-2014 09:31 PM
Strange Issue with Excel Linked Data in Word data linked from excel sheet megatronixs Word VBA 1 08-19-2012 11:09 PM
Strange Issue with Excel Linked Data in Word Excel data using mailmerge issue kilosub Mail Merge 12 05-05-2011 12:27 AM
Problem with Covnverting Linked Excel Data to Text trapdoor Word 0 05-25-2009 07:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft