• Excel File opened in Word (Excel 2002)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Excel File opened in Word (Excel 2002)

    Author
    Topic
    WSdjbooks
    AskWoody Lounger
    October 26, 2006 at 1:16 pm #436632

    We have some very inexperienced users here at our firm and this has happened a few times now. They are opening Excel files in Word, working on them and then saving them. Once that happens, you can no longer open the file in Excel. Is there any way to fix the Excel file instead of having to copy and paste from Word back to Excel where you lose a lot of formatting, formulas, etc.?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      October 26, 2006 at 1:30 pm #1035732

      No, unfortunately. Restoring a recent backup is the only way to retrieve the original workbook.

      Still, I find this strange, even for inexperienced users. When you try to open an Excel workbook in Word, you get a warning that it has to be opened using a converter; the default option in this dialog is the No button (meaning don’t open).
      I you open the workbook anyway, then try to save it, you get a warning that the document will be saved in Word format, and again the default option is the No button (meaning don’t save).

      Reply | Quote
      • WSdjbooks
        AskWoody Lounger
        October 26, 2006 at 5:16 pm #1035776

        Well I think we hold the record for the worst users.

        Thanks for the reply. I figured that was the answer but was just double-checking to make sure I wasn’t missing anything.

        Reply | Quote
      • WSAndrewO
        AskWoody Lounger
        October 29, 2006 at 6:32 am #1036079

        Hans

        It may sound strange – but I report that my users also overwrite Excel files and have never quite got their heads around using Explorer to find files.

        Microsoft has taken to issuing so many dire warnings that users are confused in many more places than just this.
        For instance – try working with a csv in Excel and imagine what our beginner makes of the messages at exit time.

        Reply | Quote
    Viewing 0 reply threads
    Reply To: Excel File opened in Word (Excel 2002)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.