Excel Linked Object Formating

T

Tried and blue

Background:
I'm using Office 2002(XP). I have a budget in Excel and Narrative in Word.
The budget is repeatedly tweaked while the narrative is being written. I have
linked individual cells from the excel sheet which update when changes are
made.

Problem:
Every time a change is made to any of the numbers in the excel sheet. Word
updates the numbers, but also generates hard returns both before and after
ALL linked numbers in the word document. Anyone know a work around for this?

Thanks,
TB
 
S

Shauna Kelly

Hi

I'm assuming you have sentences in your Word document like "This year's
marketing budget is $3.30, which is 10% more than last year's budget." where
the $3.30 and the 10% come from Excel.

If that's the case, then do Alt-F9 and inspect the fields that are bringing
in the data. Try changing them so they have \a \t \u switches after the
range, eg:
{ LINK Excel.Sheet.8 "H:\\ShaunaKelly's Documents\\test.xls"
"Sheet1!R1C1:R2C1" \a \t \u }

This will link a value from an Excel workbook automatically, as text only,
and as Unicode text.

Next time you need a new link, copy the cell in Excel. Then, in Word, do
Edit > Paste Special. Choose to paste as a link, and to paste as Unicode
text.

For more information, look up the LINK field in Word's help and look at the
other switches available to you.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
 
Top