Excel 2007 - Spreadsheet does not appear

M

MatMan

I have received several spreadsheets from coworkers that, when opened
in Excel, do not appear. Excel boots up fine. I can "arrow" around
as if the spreadsheet was on the screen and cell contents show in the
contents line at the top of Excel but the spreadsheet is not showing.
How can I:

1. Get the spreadsheet to appear?
2. Set up Excel so that this does not happen again?

I've fixed this in the past by dumb luck - which I have an abundance
of - but it's frustrating and I don't have a clue what I did to fix
the problem.

Can any of you fine folks help?

Thanks,
Pat Quick
 
B

Bernard Liengme

If you can see the cell contents in the FORMULA BAR it could be that you
have a display problem. Have you tried changing the font typeface and
colour?
best wishes
 
M

MatMan

I think you're talking about having the same colored font at the cell
in which the contents appear (like white font in
a white cell). That's not the case with my problem.

I can see the cell contents in the formula bar. The problem is, I
can't see any of the spreadsheet on the Excel
display. It's all blue; similar to when you minimize the current
spreadsheet and it leaves a tile in the lower left
corner of the screen. Except, there is no tile to maximize. I opened
another spreadsheet in Excel, reviewed
it and closed just that new spreadsheet. When the spreadsheet
closed, the problem sheet appeared. It must be
pure magic or something.

I appreciate your help and will listen to anything else you have to
say to get me fixed.

Thanks,
Pat Quick
 
J

jaf

Hi Pat,
It may be hidden. I don't have Excel 2007. If there is a windows menu check for hide/unhide.
It also may be minimized outside the visible window.
Open the VBA editor. Copy and paste this line into the immediate window then hit the enter key.

Windows(1).WindowState = xlMaximized

The active work book is always windows(1)

John


I think you're talking about having the same colored font at the cell
in which the contents appear (like white font in
a white cell). That's not the case with my problem.

I can see the cell contents in the formula bar. The problem is, I
can't see any of the spreadsheet on the Excel
display. It's all blue; similar to when you minimize the current
spreadsheet and it leaves a tile in the lower left
corner of the screen. Except, there is no tile to maximize. I opened
another spreadsheet in Excel, reviewed
it and closed just that new spreadsheet. When the spreadsheet
closed, the problem sheet appeared. It must be
pure magic or something.

I appreciate your help and will listen to anything else you have to
say to get me fixed.

Thanks,
Pat Quick
 
B

Bernard Liengme

Is it possible to send me the file (just remove TREUNORTH. form my email
address)
Bernard
 
R

Ron Brion

I have the exact same issue. It has to be a setup problem since other's can view the spread sheet on their computers. What I've done is copied the cells that I can't view and Paste Special -> values, and it works. If you figure this out let me know. Thanks, Ron



Bernard Liengme wrote:

If you can see the cell contents in the FORMULA BAR it could be that you have
23-Dec-08

If you can see the cell contents in the FORMULA BAR it could be that you
have a display problem. Have you tried changing the font typeface and
colour
best wishe
--
Bernard V Liengm
Microsoft Excel MV
http://people.stfx.ca/bliengm
remove caps from emai


Previous Posts In This Thread:

If you can see the cell contents in the FORMULA BAR it could be that you have
If you can see the cell contents in the FORMULA BAR it could be that you
have a display problem. Have you tried changing the font typeface and
colour
best wishe
--
Bernard V Liengm
Microsoft Excel MV
http://people.stfx.ca/bliengm
remove caps from emai


Hi Pat,It may be hidden. I don't have Excel 2007.
Hi Pat
It may be hidden. I don't have Excel 2007. If there is a windows menu check for hide/unhide
It also may be minimized outside the visible window
Open the VBA editor. Copy and paste this line into the immediate window then hit the enter key

Windows(1).WindowState = xlMaximize

The active work book is always windows(1

Joh

I think you're talking about having the same colored font at the cel
in which the contents appear (like white font i
a white cell). That's not the case with my problem

I can see the cell contents in the formula bar. The problem is,
can't see any of the spreadsheet on the Exce
display. It's all blue; similar to when you minimize the curren
spreadsheet and it leaves a tile in the lower lef
corner of the screen. Except, there is no tile to maximize. I opene
another spreadsheet in Excel, reviewe
it and closed just that new spreadsheet. When the spreadshee
closed, the problem sheet appeared. It must b
pure magic or something

I appreciate your help and will listen to anything else you have t
say to get me fixed

Thanks
Pat Quic



On Dec 23, 3:27 pm, "Bernard Liengme" <[email protected]
wrote:

Excel 2007 - Spreadsheet does not appear
I have received several spreadsheets from coworkers that, when opene
in Excel, do not appear. Excel boots up fine. I can "arrow" aroun
as if the spreadsheet was on the screen and cell contents show in th
contents line at the top of Excel but the spreadsheet is not showing
How can I

1. Get the spreadsheet to appear
2. Set up Excel so that this does not happen again

I've fixed this in the past by dumb luck - which I have an abundanc
of - but it's frustrating and I don't have a clue what I did to fi
the problem

Can any of you fine folks help

Thanks
Pat Quick

I think you're talking about having the same colored font at the cellin which
I think you're talking about having the same colored font at the cel
in which the contents appear (like white font i
a white cell). That's not the case with my problem

I can see the cell contents in the formula bar. The problem is,
can't see any of the spreadsheet on the Exce
display. It's all blue; similar to when you minimize the curren
spreadsheet and it leaves a tile in the lower lef
corner of the screen. Except, there is no tile to maximize. I opene
another spreadsheet in Excel, reviewe
it and closed just that new spreadsheet. When the spreadshee
closed, the problem sheet appeared. It must be
pure magic or something.

I appreciate your help and will listen to anything else you have to
say to get me fixed.

Thanks,
Pat Quick





On Dec 23, 3:27=A0pm, "Bernard Liengme" <[email protected]>
wrote:
d

Is it possible to send me the file (just remove TREUNORTH.
Is it possible to send me the file (just remove TREUNORTH. form my email
address)
Bernard
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Started with SQLite and Visual Studio
http://www.eggheadcafe.com/tutorial...b-b6f46d4f2c6a/get-started-with-sqlite-a.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top