Linking Cells from Excel to Word - Fill Color cell issue.

Hi All,

Thanks very much for your time, I hope I am posting in the right spot, and that I'm clear enough for someone to help me. If not, I apologize.

Excel Example:
A B
1 Bonds 2.6
2 Stocks 1.7

Row 1 - Fill color - BLANK
Row 2- Fill color - BLUE

Scenario:

I have 1 excel file, 1 word file in which I have special copied cells from Excel to automatically update on Word. I have just a regular data chart like above, A1-E1, 36 columns down. Simple numbers data, nothing fancy.

Problem:

When I copy B1 2.6, to Word, it shows up with a BLUE underline under it (almost as if it's copying a small part of B2's top of the cell).

How do I fix this? I've played with margins, font size, even though I don't have much room in these areas due to my report on word. My word file shows the linked number (2.6) perfectly fine, updates great, nothing wrong with the link, however it shows a blue underline on it, and really makes my word file look like crap with all these underlines. I wish it would just copy the cell and nothing else, but for some reason the cells below color is seeping through and causing all these underlines.

Can anyone help me, or need more detail if I wasn't clear? I very much appreciate your time.

Thanks,
Robert

Hi RGDraper

I'm not going to help very much, I'm afraid. I cannot reproduce your problem, but I am wondering if the 2.6 is being treated as a hyperlink which Word underlines in blue?

Just a thought

Regards
Alastair

Hi Alastair,

Thanks for your reply. The actual link is not Hyperlinked (this would look terrible on a report). It's Special Pasted from Excel.

Here's an image of my problem:
Example.jpg

As you can see under 34.6, 43.5, and 23.2 there's a small red line under the data value, due to the chart alignment in Excel. It's taking a small piece of the cell located below, and I don't understand why? I just want the contents of the cell. Seems like bad programing to me, regardless of the Margins.

Thanks again for all your time on this issue. I'm on a couple forums now, and it seems no one has answers including Microsoft employees.

Cheers,
Robert