Reply
 
Thread Tools Display Modes
  #1   Report Post  
ryanpa ryanpa is offline
Junior Member
 
Posts: 0
Default Preserve formatting using paste link - Excel - Word

Hi

I'm using Excel and Word 2007.
I have a spreadsheet which contains data for a monthly report which contains charts and data tables, these are formatted to the size and layout I transfer to the word document.

I have used paste special / paste link, and use the excel format options.

When I use prepare links in word I have the "Preserve formatting after update" ticked.

Problem
1/ When pasting content it does not maintain the correct sizing, usually is smaller 97%, I have to use format object and re-size to 100%.

2/ Sometimes the content will be much larger or smaller and resize will not work, I have to re-paste the link to correct the sizing.

Can anyone suggest a method that will provide consistent results?

Many Thanks Phil
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste Link Excel cells in Word Losing Columns WebColin70 New Users 0 January 4th 10 05:11 PM
Help wanted - how to paste link from Excel to MS Word fields Pekka New Users 0 December 29th 07 12:45 AM
Paste link graph from excel to word. Beal Microsoft Word Help 0 July 19th 07 03:56 PM
Paste link from Excel to Word does not reflect whole sheet AO Microsoft Word Help 1 May 24th 07 06:47 PM
Paste a range of Excel cells into Word as a link, cell outlines vi Sam Page Layout 1 July 31st 05 02:20 AM


All times are GMT +1. The time now is 01:41 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"