Results 1 to 6 of 6

Thread: Excel opens but not the worksheet!

  1. #1
    Join Date
    Aug 2006
    Posts
    287

    Excel opens but not the worksheet!

    I am using the Microsoft Office 2003 with the Windows XP (Pro). I mostly use the Excel 2003 in the MS Office. I was working fine with all my Excel documents. Now I am having the strange problem. When I click on shortcut of Excel, the Excel opens but not the Worksheet.!! The area remains black (more like Grey), almost similar when we close out all worksheets but left Excel open. All I have to do is click on "Open" and get the sheets back up that way but this is not helpful when I have to open many sheets. i am finding that clicking on OK every-time is very tedious job. Does anyone know how to fix it..?? Please help me soon.!!
    Dimension 1100 (FMY032J) mini-tower
    2.53ghz Intel Pentium 4
    80 gig nfts HDD
    512 RAM
    Main circuit board: Dell 0CF458
    BIOS: Dell A00
    Display: Intel(R) 82865G Graphics Controller [Display adaptor]
    Multimedia: Sound MAX Integrated Digital Audio
    Windows XP Home SP2

  2. #2
    Join Date
    Apr 2008
    Posts
    2,139

    Re: Excel opens but not the worksheet!

    Have you tried to open the Excel File by going into the original folder? The shortcut gets corrupted very soon. I would like to suggest you that check the excel.exe situated in the original file. If that is working properly then you will have to delete the existing shortcut and then put the new shortcut. You can find your original file in the "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" (by default). If you are able to open this .exe file than you don't have to worry about. Just create the new shortcut for the Excel.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,089

    Re: Excel opens but not the worksheet!

    Several times the Excel opens but not the worksheet situation occurs when there is already a program of Excel is running. I would like to suggest you to close the Excel application and then get into the Task Manager. In Windows XP you can enter into the Task Manager just by pressing Ctrl+Alt+Del. Once you enter the task manager, click on the processes tab. Check whether any process of Excel is still running. If there is any process than close that process. You can do this by clicking on that process and then clicking on the End Process button located at the bottom. Now start the Excel application by clicking on the shortcut. Hope that this time it will open the worksheet too.

  4. #4
    Join Date
    Jan 2008
    Posts
    3,758

    Re: Excel opens but not the worksheet!

    In Windows Explorer, when you double-click a Microsoft Excel workbook, you may receive the following error message when Excel does not open the file :
    "Cannot find the file 'path' (or one of its components). Make sure the path and filename are correct and that all required libraries are available".
    In this case your Excel may actually open, but the file will not open. A second instance of Excel may start if the Excel is already running. This problem may occur if the Ignore other applications setting in Excel is selected. So uncheck that option and your problem will be solved.

  5. #5
    Join Date
    Sep 2005
    Posts
    1,306

    Re: Excel opens but not the worksheet!

    I was having the same problem in Microsoft Office Excel 2003 and I was able to isolate the problem. I have followed the steps :
    • In Microsoft Office Excel 2003 or earlier versions of Excel click Options, on the Tools menu.
    • Then click the General tab.
    • Click to clear the Ignore other applications check box, and then click OK.

    After doing this settings you should able to open workbooks by double-clicking them in Windows Explorer.

  6. #6
    Join Date
    May 2008
    Posts
    4,834

    Re: Excel opens but not the worksheet!

    If you are having the Setup CD of MS Office then you can repair your excel application using that CD. Your data will remain safe. You can do this by going to the Add / Remove programs in the Control Panel. Then select the Microsoft Office program and click on the change. After clicking on the change, it will bring up a window with the 3 options. That will be uninstall, repair,...or something else. Select the repair option. It will ask to insert the Setup CD, and you will have to put it now. And the whole application will get repaired.

Similar Threads

  1. How to fullscreen Excel Worksheet
    By Calverta in forum MS Office Support
    Replies: 5
    Last Post: 27-01-2012, 06:12 PM
  2. Replies: 8
    Last Post: 04-12-2011, 10:24 AM
  3. Outlook reminders with excel worksheet
    By Avinash Kaur in forum Windows Software
    Replies: 5
    Last Post: 16-03-2011, 11:40 PM
  4. How to Add Combo Box to a Worksheet of Excel?
    By Pratim in forum Windows Software
    Replies: 5
    Last Post: 06-01-2010, 05:07 PM
  5. How to calculate GPA in Excel worksheet
    By Lambard in forum Windows Software
    Replies: 3
    Last Post: 06-06-2009, 09:29 PM

Posting Permissions

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