Page 1 of 2 12 LastLast
Results 1 to 15 of 25
  1. #1
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts

    Excel Spreadsheet in Word problem (XP)

    I have taken a spreadsheet that I made and put it in a Word document. But now I need to have the ability to enter a number at a spot in a paragraph that is above the spreadsheet and have that number appear in a cell in the spreadsheet. Someone said there is a way to do it with a bookmark, but did not know the details.
    Thanks

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

    Re: Excel Spreadsheet in Word problem (XP)

    This is tricky and very vulnerable. I would avoid it if possible. Bookmarks in a Word document tend to disappear if you type over them.

  3. #3
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts

    Re: Excel Spreadsheet in Word problem (XP)

    Thanks for the info. If the bookmarks have a tendency to disappear, then the people I am working with will be sure to do that, of course.
    But I do need to see if I can make this happen somehow, though. Can I create a single cell spreadsheet and embed it in the paragraph, and then have the number inserted there appear in my worksheet below?

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

    Re: Excel Spreadsheet in Word problem (XP)

    It might work if you create a workbook in Excel, save it and paste links to parts of the workbook into your document. I coulldn't get the data to update consistently with embedded spreadsheets, but perhaps someone else knows how to do that.

  5. #5
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts

    Re: Excel Spreadsheet in Word problem (XP)

    What I am wondering is if I embed 2 separate small worksheets in a Word doc, can I reference cells in Worksheet A in formulas that are in Worksheet B?

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

    Re: Excel Spreadsheet in Word problem (XP)

    As far as I know, you cannot refer to cells in another embedded worksheet in a formula the way you can refer to cells in another workbook. You can paste a link to a cell, but as I wrote in my previous reply, that didn't update consistently. But perhaps I'm missing something obvious.

  7. #7
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts

    Re: Excel Spreadsheet in Word problem (XP)

    Maybe I will play around with doing it with the bookmark, even though it is risky. Do you know how to reference a number in a Word bookmark when I am creating a formula in an embedded spreadsheet?

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

    Re: Excel Spreadsheet in Word problem (XP)

    Copy the number in the Word document to the clipboard, and preferably a space before and after it to reduce the chance of accidentally deleting the bookmark that will be created below.
    Activate the embedded worksheet.
    Activate a target cell.
    Select Edit | Paste Special...
    Select Paste Link, and select Text as type, then click OK.
    Word will create a bookmark for the number automatically
    You can refer to the target cell in formulas in other cells.
    If you change the number in the document, you can force an update by activating the worksheet and selecting Edit | Links, selecting the link and clicking Update Now.

  9. #9
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts

    Re: Excel Spreadsheet in Word problem (XP)

    Thanks for details. I will play with this a bit, but unfortunately it may not work for my present situation. I need something that would update automatically when the number in the document is changed. I am dealing with sales people who change an item at the top, depending on the client, and then I need for the worksheet below to change automatically. It's too much to expect these sales people to remember to update the link.

  10. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Spreadsheet in Word problem (XP)

    Why put it in a word document? Why not just keep it in an excel spreadsheet?

    Steve

  11. #11
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts

    Re: Excel Spreadsheet in Word problem (XP)

    It has 2 pages of text in addition to the spreadsheet, and figures in the text need to be referenced in the spreadsheet.

  12. #12
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Spreadsheet in Word problem (XP)

    Can't you create the text output in excel with the chart and its data?

    It seems to be a compromise between the two. I don't know enough about what you are doing to judge, but excel can handle text (I think) better than word can handle calculations.

    But the real question is do you use more WORD features or EXCEL features and how well can the "features" from word be emulated in excel and how well can the features in excel be emulated in word? Whichever one handles the brunt of the problems the best should be the application of choice even if you must do workarounds.

    Steve

  13. #13
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts

    Re: Excel Spreadsheet in Word problem (XP)

    I'm willing to look into doing it that way, but I am not familiar with the text capabilities of Excel. Can I create a text box so I am not putting text in small cells? I have 2 pages of text.

  14. #14
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Spreadsheet in Word problem (XP)

    Yes, you can even have the contents read from cell contents (if desired). If you create a formula instead of "hard Text" your formatting options are limited, however.

    Can you post an example of what you want with non-proprietary info, but of comparable info, so we can get a better idea of the goals and we can better suggest.

    I will warn you, I don't use word, so my solutions will tend to be excel (or excel VBA) solutions. (you know what they say, "If all you have is a hammer, everything looks like a nail"

    Steve

  15. #15
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    96
    Thanked 14 Times in 13 Posts

    Re: Excel Spreadsheet in Word problem (XP)

    OK here it is

Page 1 of 2 12 LastLast

Posting Permissions

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