Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Excel opens but not the worksheet!

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 12-01-2010
Member
 
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
Reply With Quote
  #2  
Old 12-01-2010
Member
 
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.
Reply With Quote
  #3  
Old 12-01-2010
Member
 
Join Date: Apr 2008
Posts: 4,091
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.
__________________
Ram requirement for various OS
Reply With Quote
  #4  
Old 12-01-2010
Member
 
Join Date: Jan 2008
Posts: 3,755
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.
Reply With Quote
  #5  
Old 12-01-2010
Member
 
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.
Reply With Quote
  #6  
Old 12-01-2010
Member
 
Join Date: May 2008
Posts: 4,826
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel opens but not the worksheet!"
Thread Thread Starter Forum Replies Last Post
How to fullscreen Excel Worksheet Calverta MS Office Support 5 27-01-2012 06:12 PM
Clicking on Worksheet on multiple Worksheets in the single Excel file not allow viewing the worksheet in Microsoft Excel 2010 Dipanwita Windows Software 8 04-12-2011 10:24 AM
Outlook reminders with excel worksheet Avinash Kaur Windows Software 5 16-03-2011 11:40 PM
How to Add Combo Box to a Worksheet of Excel? Pratim Windows Software 5 06-01-2010 05:07 PM
How to calculate GPA in Excel worksheet Lambard Windows Software 3 06-06-2009 09:29 PM


All times are GMT +5.5. The time now is 01:36 AM.