Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Tampa, Florida, USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find location of excel object (Word 2002)

    I created a document template a couple of years ago, and inserted an Excel spreadsheet object as an icon. I now need to go back and edit the Excel spreadsheet, but I can't find its location. Clicking on the icon still opens the spreadsheet, but I can't ascertain where it is stored. Thank you for any help!

    Erica

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

    Re: Find location of excel object (Word 2002)

    Hi Erica

    I'm guessing that you actually embedded (rather than linked) the Excel data into the document. This means that it is quite independent of the original spreadsheet, which may not even exist anymore. You can still open the embedded worksheet from the Word doc, then resave the copy that appears in Excel.

    Alan

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

    Re: Find location of excel object (Word 2002)

    Hi Erica:
    The first thing I'd try is to press Alt+F9 to show the field codes. If the spreadsheet is linked, you should see the path. If it's not linked, & the original exists, you can search for it using Windows Find feature. Click the taskbar, press F3, & then type in the name. If you can't recall the name & the icon doesn't have the name of the spreadsheet, then you might be able to search for it using wildcards, & limiting the time (a few years ago) & location to look for *.xls.

  4. #4
    Star Lounger
    Join Date
    Feb 2001
    Location
    Tampa, Florida, USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find location of excel object (Word 2002)

    You are right - pressing ALT F9 as Phil suggests below reveals EMBED Excel sheet. Thanks for your help!
    Erica

  5. #5
    Star Lounger
    Join Date
    Feb 2001
    Location
    Tampa, Florida, USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find location of excel object (Word 2002)

    Hi Phil - You were right. The Excel sheet wasn't linked. Thank you very much for your help!

    Erica

  6. #6
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Find location of excel object (Word 2002)

    Sometimes when you insert a foreign object into a Word .DOC files, the original path seems to linger in the file's metadata. I've seen this with pictures, but in a test embedding an Excel file from a network location into Word 2002, I didn't get the path (it shows various properties from the Excel file, but not the path). Since every version of Word is different, it's possible that your older-format file has more or different information buried in it.

    If you are curious, you can try this: File>Open..., change the file type to "Recover Text from any file (*.*):" and then open your document. You will see lots of gibberish, but you may be able to spot the path of the original file. Note: The next time you use File>Open..., make sure to change the file type back to Word Documents (or whatever), because this setting is "sticky" and may cause severe panic when applied to an important document. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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