Results 1 to 9 of 9
  1. #1
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Paste link from Excel (2000)

    After reinstalling Office, I seem to have lost some of my preferred settings. When I paste-link a named range from XL into a Word doc:

    1. The border formatting from the spreadsheet is lost. Instead, Word replaces the lot with its mindless universal single line table border. What I want (and used to have) is no borders at all as a default for tables AND a faithful reproduction of all of the XL cell borders.

    2. A reliable copying of styles from XL to Word. I used to be able to circumvent the bug of Word replacing XL's Normal style with its own. I used a custom style called XLNormal in my spreadsheets and Word would leave it alone, rather than changing XL's 10 point (Normal) font size to its own 12 point (Normal) font size. This ability also seems to have gone.

    I use links of the type:
    { LINK Excel.Sheet.8 "c:My DocumentsProfits.xls" "MyNamedRange" a r }
    which used to work OK with my old installation. Any tweaks appreciated.

    thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Paste link from Excel (2000)

    Edit | Paste Special..., Formatted text (*.rtf) seems to do a reasonably good job of preserving the Excel formatting. If you want to preserve it exactly, paste as an Excel worksheet object or as a picture.

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste link from Excel (2000)

    Yes, I noticed that an actual Paste did the job pretty well. What I'm after is a Paste Link, which I used to be able to use to get the same fairly reliable result. This is the ability which seems to have "gone west" with my new install. The formatting is as good as lost using linking. ???

    Alan

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Paste link from Excel (2000)

    Sorry, no idea. Paste Special with the Paste Link option behaves nicely on my system without special effort from me, I haven't tweaked the settings to get it that way.

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste link from Excel (2000)

    Hmmm... thanks Hans. I just realized that Word links containing valid named ranges (as opposed to explicit cell references) no longer work now either. But thanks for your confirmation - it definitely points to something broken on this new installation.

    Alan

    Edited - This is quite weird. Just tried a fresh document and now I can reference named ranges AND the table borders appear as they should... just like they used to. I still can't get rid of that annoying overriding of the 10 pt font size. I know my old style trick used to fix that one. <img src=/S/thinks.gif border=0 alt=thinks width=15 height=15> <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Paste link from Excel (2000)

    Weird indeed. I still think that, as you write, there is "something broken on this new installation". If I paste link from Excel as formatted text, the cells keep the font from Excel. Or would that be a difference between Office 2000 and Office XP?

  7. #7
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste link from Excel (2000)

    It's certainly an acknowledged bug in 2000. From the Word Help file:

    "When I paste text from Microsoft Excel, the font size changes.
    When you paste 10-point text from Microsoft Excel into a Word document, Word uses the font size of its Normal style for the pasted text. For example, suppose the font size for the Normal style is 12-point. If you paste 10-point text from Microsoft Excel, Word changes the text to 12-point.

    If you want to retain the font size of 10-point text pasted from Microsoft Excel, change the font size after you paste the text into Word." ... <img src=/w3timages/censored.gif alt=censored border=0> astounding fix that one!

    Maybe they fixed it properly XP, but I'm sure my style trick managed it too. But now I'm thinking that might have been in a former life or a parallel universe or something. <img src=/S/confused.gif border=0 alt=confused width=15 height=20> <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

    Alan

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste link from Excel (2000)

    Hi Alan:
    I just checked with my copy of Word & Excel, both 2000. I have "normal" in Excel as 10 pt. Arial &, in Word, 12 pt. TNR. Whether I paste directly, or whether I Paste Special/Paste Link (default is HTML), the font retains it's type & size. If I Paste Special/Paste Link as RTF, then the font size changes.

    Has your default Paste Link changed? That would also be weird.

  9. #9
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste link from Excel (2000)

    Thanks Phil. I think now *, that this is in the category of gremlims. I can now reproduce the results that both you and Hans have achieved. I think the default HTML paste format is better than the RTF I was using, especially since I can't use my style trick anymore, to fool Word into overriding with its Normal style font size. I think your method will suit nicely from now on.

    Alan

    * Interlude - Descartes walks into a bar. The barman asks "Will you be having a beer?" Descartes replies "I think not." Then he vanishes into thin air.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •