Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Can't view data in cells

When some of my Office 2003 excel files are opened I can only see the data if
I select the cell and view the data in the data entry field at the top of the
worksheet.

How do I resolve this issue? I tried doing a repair several times and that
didn't work. I am trying to avoid uninstalling Office and reinstalling.

Thanks in advanced for your help.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Can't view data in cells

If the data is visible in the formula bar, but not in the cell, then check to
make sure that the font color is not the same as the cell background color.
--
Gary''s Student - gsnu200762


"Usmerlin" wrote:

When some of my Office 2003 excel files are opened I can only see the data if
I select the cell and view the data in the data entry field at the top of the
worksheet.

How do I resolve this issue? I tried doing a repair several times and that
didn't work. I am trying to avoid uninstalling Office and reinstalling.

Thanks in advanced for your help.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Can't view data in cells

The font is black and the cells are white. I just noticed that text that is
vertically justified is bunching up. Basically all the letters are together
as one black blob.

"Gary''s Student" wrote:

If the data is visible in the formula bar, but not in the cell, then check to
make sure that the font color is not the same as the cell background color.
--
Gary''s Student - gsnu200762


"Usmerlin" wrote:

When some of my Office 2003 excel files are opened I can only see the data if
I select the cell and view the data in the data entry field at the top of the
worksheet.

How do I resolve this issue? I tried doing a repair several times and that
didn't work. I am trying to avoid uninstalling Office and reinstalling.

Thanks in advanced for your help.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Can't view data in cells

Does this mean you can't see the cells in the window below the formulabar?

If yes, then try:
window|arrange|tiled
and then you can resize that window the way you want.

If no, maybe you could be more descriptive.

Usmerlin wrote:

When some of my Office 2003 excel files are opened I can only see the data if
I select the cell and view the data in the data entry field at the top of the
worksheet.

How do I resolve this issue? I tried doing a repair several times and that
didn't work. I am trying to avoid uninstalling Office and reinstalling.

Thanks in advanced for your help.


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Can't view data in cells

Yes that is problem. For example I have a calendar and the only thing in the
cells are numbers, which are not visible until I click on the cell and see
the number in the formula bar. This problem just recently occurred. Data I
could see in files before, I cannot see now until I select the cell and look
at the formula bar. I have had others open the files I am having issues with
and there is no problem on their end.

"Dave Peterson" wrote:

Does this mean you can't see the cells in the window below the formulabar?

If yes, then try:
window|arrange|tiled
and then you can resize that window the way you want.

If no, maybe you could be more descriptive.

Usmerlin wrote:

When some of my Office 2003 excel files are opened I can only see the data if
I select the cell and view the data in the data entry field at the top of the
worksheet.

How do I resolve this issue? I tried doing a repair several times and that
didn't work. I am trying to avoid uninstalling Office and reinstalling.

Thanks in advanced for your help.


--

Dave Peterson



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Can't view data in cells

I was trying to describe that you couldn't even see the cells. So my previous
suggestion won't work.

Do you use multiple monitors?

http://groups.google.co.uk/group/mic...09488256478b2d

or

http://snipurl.com/1crbf

Mike Brambley posts a link to a suggestion that worked for him.



Usmerlin wrote:

Yes that is problem. For example I have a calendar and the only thing in the
cells are numbers, which are not visible until I click on the cell and see
the number in the formula bar. This problem just recently occurred. Data I
could see in files before, I cannot see now until I select the cell and look
at the formula bar. I have had others open the files I am having issues with
and there is no problem on their end.

"Dave Peterson" wrote:

Does this mean you can't see the cells in the window below the formulabar?

If yes, then try:
window|arrange|tiled
and then you can resize that window the way you want.

If no, maybe you could be more descriptive.

Usmerlin wrote:

When some of my Office 2003 excel files are opened I can only see the data if
I select the cell and view the data in the data entry field at the top of the
worksheet.

How do I resolve this issue? I tried doing a repair several times and that
didn't work. I am trying to avoid uninstalling Office and reinstalling.

Thanks in advanced for your help.


--

Dave Peterson


--

Dave Peterson
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Can't view data in cells

Dave,

Thank you very much for that link. I will have to switch monitors out, but
I unchecked "extend my Windows desktop onto this monitor" and opened the
files I was having issues with and they are now working properly.

Thanks again, I appreciate it.

Mike

"Dave Peterson" wrote:

I was trying to describe that you couldn't even see the cells. So my previous
suggestion won't work.

Do you use multiple monitors?

http://groups.google.co.uk/group/mic...09488256478b2d

or

http://snipurl.com/1crbf

Mike Brambley posts a link to a suggestion that worked for him.



Usmerlin wrote:

Yes that is problem. For example I have a calendar and the only thing in the
cells are numbers, which are not visible until I click on the cell and see
the number in the formula bar. This problem just recently occurred. Data I
could see in files before, I cannot see now until I select the cell and look
at the formula bar. I have had others open the files I am having issues with
and there is no problem on their end.

"Dave Peterson" wrote:

Does this mean you can't see the cells in the window below the formulabar?

If yes, then try:
window|arrange|tiled
and then you can resize that window the way you want.

If no, maybe you could be more descriptive.

Usmerlin wrote:

When some of my Office 2003 excel files are opened I can only see the data if
I select the cell and view the data in the data entry field at the top of the
worksheet.

How do I resolve this issue? I tried doing a repair several times and that
didn't work. I am trying to avoid uninstalling Office and reinstalling.

Thanks in advanced for your help.

--

Dave Peterson


--

Dave Peterson

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Can't view data in cells

I'm not sure if this'll help, but you may want to review Chip Pearson's site:
http://cpearson.com/excel/MultipleMonitors.aspx

Usmerlin wrote:

Dave,

Thank you very much for that link. I will have to switch monitors out, but
I unchecked "extend my Windows desktop onto this monitor" and opened the
files I was having issues with and they are now working properly.

Thanks again, I appreciate it.

Mike

"Dave Peterson" wrote:

I was trying to describe that you couldn't even see the cells. So my previous
suggestion won't work.

Do you use multiple monitors?

http://groups.google.co.uk/group/mic...09488256478b2d

or

http://snipurl.com/1crbf

Mike Brambley posts a link to a suggestion that worked for him.



Usmerlin wrote:

Yes that is problem. For example I have a calendar and the only thing in the
cells are numbers, which are not visible until I click on the cell and see
the number in the formula bar. This problem just recently occurred. Data I
could see in files before, I cannot see now until I select the cell and look
at the formula bar. I have had others open the files I am having issues with
and there is no problem on their end.

"Dave Peterson" wrote:

Does this mean you can't see the cells in the window below the formulabar?

If yes, then try:
window|arrange|tiled
and then you can resize that window the way you want.

If no, maybe you could be more descriptive.

Usmerlin wrote:

When some of my Office 2003 excel files are opened I can only see the data if
I select the cell and view the data in the data entry field at the top of the
worksheet.

How do I resolve this issue? I tried doing a repair several times and that
didn't work. I am trying to avoid uninstalling Office and reinstalling.

Thanks in advanced for your help.

--

Dave Peterson


--

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
XL2003, how can I set the view to show only the cells with data S Thomas Setting up and Configuration of Excel 3 September 18th 06 04:56 PM
View only Highlighted Cells Sreeku Excel Discussion (Misc queries) 0 August 9th 06 02:56 PM
Excel-cannot view info placed in cells crayon Excel Discussion (Misc queries) 1 January 16th 06 08:42 PM
Help me! There is problem with cells view... :-) Excel Discussion (Misc queries) 1 April 28th 05 01:16 PM
How do I view formulas by values not by which cells they use to c. excelhelp Excel Discussion (Misc queries) 1 December 6th 04 12:30 AM


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

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

About Us

"It's about Microsoft Excel"