Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2009
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hiiiiiiii
    Lemme go straight to the problem...I'm using office 2007. I am copying a cell from excel... and pasting the value in word using the paste special...So that whenever i change a value in excel, the correspoding change will be there in word file... But when i am inserting a row/column i am loosing the change because the cell is changing.. Now i would like to know is there any way to retain the same cell after inserting a row/column...

    I hope i am clear..Please help me....
    Thanx in advance
    Ranmahs

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post
    I typed a number into a cell in Excel, then copied that cell to the clipboard (Ctrl+C), then in Word, I chose Paste| Special| Paste Link| Excel Worksheet Object. The number appeared in the document as I expected. Then, I inserted additional rows and columns into the Excel worksheet, causing the number to change locations (cell address). Word lost the link. I believe that duplicates your issue?

    I was able to avoid losing the link by naming the cell before copying and pasting. In fact, I can drag the cell anywhere on the sheet, change the contents of the cell, insert columns, or insert rows - and the link in Word updates just fine. Try that and see if it works for you.

    Cheers,


    [quote name='ranmahs' post='767475' date='26-Mar-2009 01:33']Hiiiiiiii
    Lemme go straight to the problem...I'm using office 2007. I am copying a cell from excel... and pasting the value in word using the paste special...So that whenever i change a value in excel, the correspoding change will be there in word file... But when i am inserting a row/column i am loosing the change because the cell is changing.. Now i would like to know is there any way to retain the same cell after inserting a row/column...

    I hope i am clear..Please help me....
    Thanx in advance
    Ranmahs[/quote]
    - Ricky

  3. #3
    New Lounger
    Join Date
    Mar 2009
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thank you sir..
    It worked for me

Posting Permissions

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