Results 1 to 13 of 13
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel workbooks dont open as before (2007)

    Has anyone found a workaround for this problem? In Excel 2007, if you open an existing workbook/sheet by double-clicking the icon in explorer, it doesnt actually open the sheet until you click on one of the ribbon options.

    Rob

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel workbooks dont open as before (2007)

    Have you tried removing all files from the XLSTART directories (both of them) and then starting Excel? The directories are:
    C:Program FilesMicrosoft OfficeOffice12Xlstart
    Cocuments and SettingsusernameApplication DataMicrosoftExcelXlstart
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Mar 2004
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel workbooks dont open as before (2007)

    Hi

    Nothing in either of those directories. Since reporting the problem, I have installed the print to PDF add-in and that now appears but the problem existed before this and still exists.

    Rob

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel workbooks dont open as before (2007)

    Hi Rob,
    I have seen a few mentions of similar issues (usually involving having to minimise then restore the app) but no common solution or cause. The culprits I have seen mentioned seem to be:
    1. Add-ins or other files such as PDFMaker.xla - which is usually in one of the XLSTART directories, though you may want to disable all other add-ins to see if that helps.
    2. Insufficient RAM.
    3. Incorrect DDE settings under the File Associations in Windows Explorer. Usually this seems to involve the %1 missing from the setting.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel workbooks dont open as before (2007)

    A few other bits of information that might be useful to us:
    1. What OS are you running?
    2. Was this a clean install of Office or an upgrade?
    3. Do you have other versions of Office installed too?
    4. Does this happen with 2007 version files or only with older versions?
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    New Lounger
    Join Date
    Mar 2004
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel workbooks dont open as before (2007)

    Hi Rory

    Info below:
    A few other bits of information that might be useful to us:
    1. What OS are you running?
    Windows XP SP2 on a Dell Optiplex 745(almost brand new)

    2. Was this a clean install of Office or an upgrade?
    Not sure because it was done whilst I was on holiday but I'd guess upgrade as there are still Office 10 and 11 folders on the system.

    3. Do you have other versions of Office installed too?
    No.

    4. Does this happen with 2007 version files or only with older versions?
    Only happens in 2007. Worked fine with all other versions. I did wonder if it was related to the compatibility mode of the files(I might try converting one and see if it still happens). I also noticed it on another user's machine where it happened on files sent in email(didnt even open those) and that was a clean install.

    Rob

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel workbooks dont open as before (2007)

    I would definitely try:
    1. Create a new file in XL2007, add some stuff, save it and then open it from Explorer.
    2. Save an existing file as a 2007 version and see if the explorer issue remains.
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    New Lounger
    Join Date
    Mar 2004
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel workbooks dont open as before (2007)

    They do seem to open fine now. It is just the compatibility mode files that dont. Thanks Microsoft for fantastic backwards compatibility - maybe we should rename it incompatibility mode?

  9. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel workbooks dont open as before (2007)

    As a matter of interest, do the files open OK if you have Excel open already when you double-click the file in Explorer?
    Regards,
    Rory

    Microsoft MVP - Excel

  10. #10
    New Lounger
    Join Date
    Mar 2004
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel workbooks dont open as before (2007)

    Yes, still happens if other files are open.

  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel workbooks dont open as before (2007)

    I've seen this happen on occasion as well (with .xls files). But mostly they behave for me.

    Try this:

    Start, run,
    Excel.exe /unregserver

    followed by:

    Start, run,
    Excel.exe /regserver

    If you get a file not found error, use:

    "crogram filesMicrosoft OfficeOffice12Excel.exe" /unregserver
    "crogram filesMicrosoft OfficeOffice12Excel.exe" /regserver

    (yes, with quotes, change path to whereever your excel.exe is)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  12. #12
    New Lounger
    Join Date
    Mar 2004
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel workbooks dont open as before (2007)

    This does appear to have fixed it. Thanks

  13. #13
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel workbooks dont open as before (2007)

    Great!

    Thanks for letting us know.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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