Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Linked Object Formating
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 |
#2
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Excel Linked Object Formating
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 "Tried and blue" Tried and wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loss of formatting with Excel linked object | Page Layout | |||
Linked Excel chart object question | Microsoft Word Help | |||
Update filepath on Linked Excel-object | Microsoft Word Help | |||
Embedded Linked Excel object | New Users | |||
how to keep formating from linked excel doc to word document | Microsoft Word Help |