Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi All, I am having trouble opening an excel file. When I go to open it either by selecting it through the open file menu or double clicking it, the file opens but the worksheets don't appear. I know it has opened as the file name is in the menu under "window". Also it is possible to see the contents of the last cell which was selected as it appears in the formula bar at the top. The only trouble is the actual worksheets don't appear in the main window!! Any ideas on how to fix this? I am using Excel 2000 Many thanks in advance GW -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=526775 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try Format Sheets UnhideAll
Vaya con Dios, Chuck, CABGx3 "giantwolf" wrote: Hi All, I am having trouble opening an excel file. When I go to open it either by selecting it through the open file menu or double clicking it, the file opens but the worksheets don't appear. I know it has opened as the file name is in the menu under "window". Also it is possible to see the contents of the last cell which was selected as it appears in the formula bar at the top. The only trouble is the actual worksheets don't appear in the main window!! Any ideas on how to fix this? I am using Excel 2000 Many thanks in advance GW -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=526775 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Thanks but I've tried the Unhide option, nothing is hidden. As I say, if I pick a cell using the name box I can see the contents of that cell in the formua bar, I just can't see the worksheet in the main window. -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=526775 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Do you see a worksheet tab at the bottom of the main window?
Will the file open normally on another computer? Can you open other files normally on this computer? Do you see Column Letters and Row Numbers? but just a gray field with no cells defined?....if so try View Normal With security set to low, does the file require you to authorize macros?...if so try opening without doing it. hth Vaya con Dios, Chuck, CABGx3 "giantwolf" wrote in message ... Thanks but I've tried the Unhide option, nothing is hidden. As I say, if I pick a cell using the name box I can see the contents of that cell in the formua bar, I just can't see the worksheet in the main window. -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=526775 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I actually just found this problem when I was trying to solve a different
issue and know it was created by checking both the "Ignore other applications" and "Windows in taskbar" options at the same time. I'm funning Office Small business 2000 with Powerpoint 2003. -- Ramona "CLR" wrote: Do you see a worksheet tab at the bottom of the main window? Will the file open normally on another computer? Can you open other files normally on this computer? Do you see Column Letters and Row Numbers? but just a gray field with no cells defined?....if so try View Normal With security set to low, does the file require you to authorize macros?...if so try opening without doing it. hth Vaya con Dios, Chuck, CABGx3 "giantwolf" wrote in message ... Thanks but I've tried the Unhide option, nothing is hidden. As I say, if I pick a cell using the name box I can see the contents of that cell in the formua bar, I just can't see the worksheet in the main window. -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=526775 |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() CLR Wrote: Do you see a worksheet tab at the bottom of the main window? Will the file open normally on another computer? It has opened normally on my pc before and does open normally on others. Can you open other files normally on this computer? Yes Do you see Column Letters and Row Numbers? but just a gray field with no cells defined?....if so try View Normal No, nothing other than the contents of a particular cell in the formula bar With security set to low, does the file require you to authorize macros?...if so try opening without doing it. No macros in this file whatsoever hth Vaya con Dios, Chuck, CABGx3 "giantwolf" wrote in message ... Thanks but I've tried the Unhide option, nothing is hidden. As I say, if I pick a cell using the name box I can see the contents of that cell in the formua bar, I just can't see the worksheet in the main window. -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=526775 See answers to your questions above. I guess this might remain one of lifes little mysteries! -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=526775 |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Ramona Wrote: I actually just found this problem when I was trying to solve a different issue and know it was created by checking both the "Ignore other applications" and "Windows in taskbar" options at the same time. I'm funning Office Small business 2000 with Powerpoint 2003. Neither of these are checked and it doesn't fix it by checking them and then unchecking them. Thanks for the suggestion. -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=526775 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Opening Excel and chosen file from Explorer | Setting up and Configuration of Excel | |||
Opening Excel File | Excel Discussion (Misc queries) | |||
Excel getting Error - file format is not valid WHEN OPENING | Excel Discussion (Misc queries) | |||
opening file problem please help | Excel Discussion (Misc queries) |