How do I lock in formatting in Word from linked Excel data?

G

Greta

I have linked data from a specific cell in Excel to Word. When I Update
Link, the table I created in Word auto-formats to include carraige returns
before and after the number. Now the entire report in Word, using tables to
help preserve page layout, has been altered. How do I lock the Word table
cells so that it accepts the linked Excel data without altering the row
height (extra carraige returns)? PLS HELP!
 
M

macropod

Hi Greta,

If the unwanted carriage returns are in the excel data, the only course open to you is to modify the data in Excel.

Alternatively, if the problem is that the link is inserting unwanted CRs at the end of each group of records, you may find one of
the other link formats (eg plain text) is better suited to your needs.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking data in MS Word into Excel 5
Paste to excel from word - auto format problem 1
List all tables, including document structure 0
Excel - Wich Function should I use? 1
Integrating information from Word to Excel (not mail merge) 1
Excel does not accept text format! 0
Link Excel to word 2
Finding the height of a row in a word table from Excel 0

Top