Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Apr 2003
    Location
    Edinburgh, Midlothian, United Kingdom
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to read a formula (Excel 2000)

    I have a Word document with an Excel Spreadsheet copied into it.

    It has a formula in it to work out Stamp Duty (which has recently changed) and I need to find out where the original excel document is so I can change the limit.

    This is the formula =VLOOKUP(C4,StampDuty,2,TRUE).

    Can I find out from this where I need to go to change the Stamp Duty limit?

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

    Re: How to read a formula (Excel 2000)

    First, click outside the Excel object to make sure it's not active.
    Then right-click it and select Worksheet Object | Open to open it in Excel.
    Select Insert | Name | Define...
    Click on StampDuty to see its definition.
    You can also press Ctrl+G, click on StampDuty and click OK.
    When you're done, select File | Close and Return to <document name>

  3. #3
    Star Lounger
    Join Date
    Apr 2003
    Location
    Edinburgh, Midlothian, United Kingdom
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to read a formula (Excel 2000)

    Thanks Hans

    Have done this.

    Have changed the document it listed - but its not doing what I want. If I do it in the original document it works - but it doesnt work in the one in the Word document. Any further thoughts?

    Thanks
    Carolyn

  4. #4
    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: How to read a formula (Excel 2000)

    Did you do it in the sheet of the embedded excel document?

    Dbl-click the embedded document and it should open excel, edit it in there.

    Steve

  5. #5
    Star Lounger
    Join Date
    Apr 2003
    Location
    Edinburgh, Midlothian, United Kingdom
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to read a formula (Excel 2000)

    I double clicked on it before I did the testing.

    It doesnt open properly in Excel - its still in Word but opens a bit of Excel round the edge?

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to read a formula (Excel 2000)

    When you double click it in Word, you should be able to go to Insert>Name>Define and change it there.

  7. #7
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: How to read a formula (Excel 2000)

    <P ID="edit" class=small>(Edited by macropod on 13-Apr-06 08:42. Added comment about multiple worksheets in embedded object.)</P>Hi Carolyn,

    The "bit of Excel round the edge" is actually the full-blown Excel application. From what you've described, the formula isn't pointing to an external workbook, so the StampDuty range will be in there somewhere. If you click on F5 (Goto) and type in (or select) 'StampDuty' the embedded worksheet should scroll to that range. After making your changes, you'll need to scroll back again before exiting the embedded object. Note that the 'StampDuty' range may actually be on a different worksheet in the same embedded object, so you might even need to change sheets to get back to yoyr starting point.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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