ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 - Spreadsheet does not appear (https://www.excelbanter.com/excel-discussion-misc-queries/214536-excel-2007-spreadsheet-does-not-appear.html)

MatMan

Excel 2007 - Spreadsheet does not appear
 
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

Bernard Liengme

Excel 2007 - Spreadsheet does not appear
 
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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"MatMan" wrote in message
...
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




MatMan

Excel 2007 - Spreadsheet does not appear
 
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





On Dec 23, 3:27*pm, "Bernard Liengme"
wrote:
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
--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email

"MatMan" wrote in message

...



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- Hide quoted text -


- Show quoted text -



jaf

Excel 2007 - Spreadsheet does not appear
 
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


"MatMan" wrote in message ...
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





On Dec 23, 3:27 pm, "Bernard Liengme"
wrote:
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
--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email

"MatMan" wrote in message

...



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- Hide quoted text -


- Show quoted text -



Bernard Liengme

Excel 2007 - Spreadsheet does not appear
 
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

"Bernard Liengme" wrote in message
...
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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"MatMan" wrote in message
...
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






Ron Brion

Can't view excel spreadsheet
 
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 wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"MatMan" wrote in message
...

Previous Posts In This Thread:

On Tuesday, December 23, 2008 3:27 PM
Bernard Liengme wrote:

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 wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"MatMan" wrote in message
...

On Tuesday, December 23, 2008 4:40 PM
jaf wrote:

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 = xlMaximized

The active work book is always windows(1)

John


"MatMan" wrote in message ...
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





On Dec 23, 3:27 pm, "Bernard Liengme"
wrote:

On Wednesday, December 24, 2008 5:53 AM
MatMan wrote:

Excel 2007 - Spreadsheet does not appear
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

On Wednesday, December 24, 2008 5:53 AM
MatMan wrote:

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 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





On Dec 23, 3:27=A0pm, "Bernard Liengme"
wrote:
d

On Wednesday, December 24, 2008 9:32 AM
Bernard Liengme wrote:

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/tutorials...-sqlite-a.aspx


All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com