Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Jun 2001
    Location
    Netherlands
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Inserting Excel-cells readonly (word 2000)

    A collegue of mine is inserting Excell-cells into a word document, using Paste Special.
    According to her, in Word 97, there was a checkbox to make the cells hover above the text, without being able to edit the values.
    In Word 2000 this checkbox is gone.

    Does anyone know of a way to acchieve the same effect?

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

    Re: Inserting Excel-cells readonly (word 2000)

    I posted a reply to your other similar question, but you must have deleted the post about the same time I replied. Choose Edit/paste special & choose Picture, rather than the default HTML.

  3. #3
    New Lounger
    Join Date
    Jun 2001
    Location
    Netherlands
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting Excel-cells readonly (word 2000)

    Hi Phil,

    Thanks for your reply - Sorry I deleted while you were answering, she explained again to me and the old description didn't realy fit the problem <img src=/S/beep.gif border=0 alt=beep width=15 height=15>
    Your tip works for the read-only part, but the info in the sheet should be up-to-date with the info in the original Excel sheet.

    Is there a way to do that?
    Currently she inserts the cells as a "Microsoft ExcelWorksheet Object"... Is there a way to just set the object to R/O - that would solve the problem

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

    Re: Inserting Excel-cells readonly (word 2000)

    To keep the cells up to date, use the Paste Link option.

  5. #5
    New Lounger
    Join Date
    Jun 2001
    Location
    Netherlands
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting Excel-cells readonly (word 2000)

    Yup - that's where I went wrong

    Thanks!

  6. #6
    New Lounger
    Join Date
    Jun 2001
    Location
    Netherlands
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting Excel-cells readonly (word 2000)

    Okay - we're a long way...
    She's almost satisfied - all she wants now is that the object is immovable - fixed to a specific location in the document
    I tried setting the format to "In line with text", but it is still possible to move it up and down a few lines

    Any ideas?

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

    Re: Inserting Excel-cells readonly (word 2000)

    The only way to really lock something down is to place it in a section protected for forms:<UL><LI>Insert continuous section breaks before and after the Excel object,
    <LI>Note the number of the section that contains the Excel object,
    <LI>Select Tools | Protect Document...,
    <LI>Click the Forms option,
    <LI>Click the Sections... button,
    <LI>Uncheck all sections except the one with the Excel object,
    <LI>Click OK until you're back in the document.[/list]But unfortunately, protecting a document for forms disables many features even in unprotected sections, so this may be too drastic.

  8. #8
    New Lounger
    Join Date
    Jun 2001
    Location
    Netherlands
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting Excel-cells readonly (word 2000)

    Thanks, I will tell her that.

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

    Re: Inserting Excel-cells readonly (word 2000)

    Short of protecting the document which, as Hans noted, is the only way to lock it down but disables features, it depends upon how well she wants to lock it down. If the purpose is to prevent it from moving on the screen accidentally, or while the rest of the document is being edited, there is another way.

    If she selects the object, right clicks, & chooses Format/object..., a dialog box will come up. On the layout tab, click advanced. Uncheck the "move object with text option". In the same dialog box, you will see options for setting the vertical & horizontal alignment. Set the absolute position relative to Page or Margin for both settings. Now the table position will be relatively stable. However, an object is always anchored to a paragraph. If she turns on the Show/Hide button & selects the table, she'll see an anchor next to one of the paragraph marks. If this paragraph goes to the next page, the table will move also. It would be best to drag this anchor to a paragraph that will always remain on the same page as the table.
    Hope this helps,

Posting Permissions

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