Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink in Excel 2007 spreadsheet cell, to a Powerpoint 2007 sli | Excel Discussion (Misc queries) | |||
excel 2007 spreadsheet | Excel Discussion (Misc queries) | |||
How do I track changes on an Office 2007 Excel spreadsheet | Excel Discussion (Misc queries) | |||
Excel 2007: very slow to load spreadsheet | Excel Discussion (Misc queries) | |||
How to inport works spreadsheet into excel 2007 | Excel Worksheet Functions |