Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Blank workbook in normal view

Sometimes when I open a workbook it 'isn't there' in normal view. The
toolbars are visible, but the sceen is otherwise blank with no scroll bars.
If I switch to Print Preview, the document appears - but cannot be edited of
course, and if I switch to Full Screen it also appears - but there are no
toolbars so editing is limited. every time I return to Normal screen it
disappears again.

I have seen the suggestion on these forums that it could simply be 'off the
radar' - i.e. moved out of sight on the screen - but without scroll bars
there is no way of retrieving it.

Sometimes the same workbook opens normally one day, but not the next. I am
running 2003 but have a 2007 trial installed and the problem was there before
I installed the 2007 trial.

Any suggestions please?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Blank workbook in normal view

I bet that the window is just off the visible screen.

Window|Arrange|Tiled
and resize the way you like.



vic1 wrote:

Sometimes when I open a workbook it 'isn't there' in normal view. The
toolbars are visible, but the sceen is otherwise blank with no scroll bars.
If I switch to Print Preview, the document appears - but cannot be edited of
course, and if I switch to Full Screen it also appears - but there are no
toolbars so editing is limited. every time I return to Normal screen it
disappears again.

I have seen the suggestion on these forums that it could simply be 'off the
radar' - i.e. moved out of sight on the screen - but without scroll bars
there is no way of retrieving it.

Sometimes the same workbook opens normally one day, but not the next. I am
running 2003 but have a 2007 trial installed and the problem was there before
I installed the 2007 trial.

Any suggestions please?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Blank workbook in normal view

Sorry - I have tried every which way I know! I know the database is 'there'
because the text appears in the calculation line, wherever I click on the
blank screen.

Please can you be more specific about how I achieve Window|Arrange|Tiled?
I've tried selecting 'Tile Windows' from the menu you get when you right
click on the time in the bottom RH corner. Should I be doing something else?

I'm getting pretty desperate on this because nothing makes sense and I just
can't work with some data because it has 'disappeared'! Any replies
appreciated.

The only thing showing is the blue Windows background and the Ribbon. If I
click the Windows button and choose to open a different database, then this
will (or sometimes won't!) open normally in a window within the blue
backgound, complete with scroll bars etc as normal.

"Dave Peterson" wrote:

I bet that the window is just off the visible screen.

Window|Arrange|Tiled
and resize the way you like.



vic1 wrote:

Sometimes when I open a workbook it 'isn't there' in normal view. The
toolbars are visible, but the sceen is otherwise blank with no scroll bars.
If I switch to Print Preview, the document appears - but cannot be edited of
course, and if I switch to Full Screen it also appears - but there are no
toolbars so editing is limited. every time I return to Normal screen it
disappears again.

I have seen the suggestion on these forums that it could simply be 'off the
radar' - i.e. moved out of sight on the screen - but without scroll bars
there is no way of retrieving it.

Sometimes the same workbook opens normally one day, but not the next. I am
running 2003 but have a 2007 trial installed and the problem was there before
I installed the 2007 trial.

Any suggestions please?


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Blank workbook in normal view

In xl2003 (and below), there's an Window option on the worksheet menu bar.

Click on that first, then follow the instructions.

If you're using xl2007, maybe someone else will chime in--or you could look for
it yourself.


vic1 wrote:

Sorry - I have tried every which way I know! I know the database is 'there'
because the text appears in the calculation line, wherever I click on the
blank screen.

Please can you be more specific about how I achieve Window|Arrange|Tiled?
I've tried selecting 'Tile Windows' from the menu you get when you right
click on the time in the bottom RH corner. Should I be doing something else?

I'm getting pretty desperate on this because nothing makes sense and I just
can't work with some data because it has 'disappeared'! Any replies
appreciated.

The only thing showing is the blue Windows background and the Ribbon. If I
click the Windows button and choose to open a different database, then this
will (or sometimes won't!) open normally in a window within the blue
backgound, complete with scroll bars etc as normal.

"Dave Peterson" wrote:

I bet that the window is just off the visible screen.

Window|Arrange|Tiled
and resize the way you like.



vic1 wrote:

Sometimes when I open a workbook it 'isn't there' in normal view. The
toolbars are visible, but the sceen is otherwise blank with no scroll bars.
If I switch to Print Preview, the document appears - but cannot be edited of
course, and if I switch to Full Screen it also appears - but there are no
toolbars so editing is limited. every time I return to Normal screen it
disappears again.

I have seen the suggestion on these forums that it could simply be 'off the
radar' - i.e. moved out of sight on the screen - but without scroll bars
there is no way of retrieving it.

Sometimes the same workbook opens normally one day, but not the next. I am
running 2003 but have a 2007 trial installed and the problem was there before
I installed the 2007 trial.

Any suggestions please?


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I display color in excel in normal view? Hattricksi Excel Discussion (Misc queries) 2 August 11th 06 12:24 PM
column is hidden in normal view but not print view Bianca Excel Worksheet Functions 2 June 23rd 06 08:38 AM
Page break in normal view set at startup Stephen S Excel Discussion (Misc queries) 3 April 14th 06 11:46 PM
outlook view to normal view jenden New Users to Excel 2 December 5th 05 10:23 PM
Viewing footers and headers in normal view Chris Jones in Perth WA Excel Discussion (Misc queries) 2 June 7th 05 01:24 PM


All times are GMT +1. The time now is 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"