|
|
Data visible in formula bar, but not in cells
Several coworkers just switched to Excel 2007 from 2003. They are having
problems with data that should be visible in some rows of cells, but are only
visible in the formula bar (as each cell is selected). However, if they
click anywhere in the formula bar of one of those cells, the data suddenly
appears in all cells within that row.
I suspect that their computers aren't powerful enough to handle 2007,
because their supervisor, myself and others do not have the same problem.
Is there any solution to this problem?
--
GD
|
|
0
|
|
|
|
Reply
|
 Utf
|
4/16/2010 2:47:02 PM |
|
There is a known bug relating to data visibilty concerning the Freeze Panes
and scrolling. This may be your issue.
This post from Microsoft provides some (but not many) details
http://support.microsoft.com/kb/970547
--
If this helps, please remember to click yes.
"GD" wrote:
> Several coworkers just switched to Excel 2007 from 2003. They are having
> problems with data that should be visible in some rows of cells, but are only
> visible in the formula bar (as each cell is selected). However, if they
> click anywhere in the formula bar of one of those cells, the data suddenly
> appears in all cells within that row.
>
> I suspect that their computers aren't powerful enough to handle 2007,
> because their supervisor, myself and others do not have the same problem.
>
> Is there any solution to this problem?
>
> --
> GD
|
|
|
-1
|
|
|
|
Reply
|
Utf
|
4/16/2010 4:30:01 PM
|
|
|
1 Replies
1226 Views
(page loaded in 0.085 seconds)
Similiar Articles: Data visible in formula bar, but not in cells - microsoft.public ...Several coworkers just switched to Excel 2007 from 2003. They are having problems with data that should be visible in some rows of cells, but are o... Formula refers to empty cells even when cells contains data ...Printing cells that are blank, because there is a formula ..... contain something (that formula), so those cells ... Data visible in formula bar, but not in cells ... formula for visible cells - microsoft.public.excel.worksheet ...Data visible in formula bar, but not in cells - microsoft.public ... Several coworkers just switched to Excel 2007 from 2003. They are having problems with data that ... Printing cells that are blank, because there is a formula ...Printing cells that are blank, because there is a formula ..... contain something (that formula), so those cells ... Data visible in formula bar, but not in cells ... selecting and copying visible cells only - microsoft.public.mac ...Filling cells with filtered data to another sheet. - microsoft ... Select the data ... Visible Cells, Columns or Rows in MS ... how to select only visible cells, or how to not ... Validation dropdown list is not coming visible - microsoft.public ...... enter the formula ... Menu bar not working (but visible ... Arrows Not Visible. Occasionally, data validation dropdown arrows are not visible on the worksheet, in cells ... Menu bar not working (but visible) - microsoft.public.outlook ...Validation dropdown list is not coming visible - microsoft.public ..... box, enter the formula ... Menu bar not working (but visible) - microsoft ... Problem with footer data with Excel 2003 and 2007 - microsoft ...Data visible in formula bar, but not in cells - microsoft.public ... Several coworkers just switched to Excel 2007 from 2003. They are having problems with data that ... Excel Macro: insert formula into first blank cell in column & ...... data, however, I'm not sure how to make a macro that finds the first blank cell in a partially populated column, enters a formula ... formula into the visible cells ... bar ... Sum Function Visible Cells only - microsoft.public.excel.worksheet ...... F9, it does not recalculate. I have to go into the cell with the UDF formula and click the tick on the formula bar ... cell is not empty ... Sum Function Visible Cells only ... Data visible in formula bar, but not in cells - microsoft.public ...Several coworkers just switched to Excel 2007 from 2003. They are having problems with data that should be visible in some rows of cells, but are o... Formula appearing as Value in Formula Bar - data visible formula ...I have a vba routine that enters formulas in two cells In one cell the formula appears correctly (you see the formula in the Formula bar when cursor is in cell ... Text not visible in cell only in Formula Bar (excel 2003) - MS ...I clicked again on cell and saw text in > the > formula bar but it is not visible in cell? ... Want to paste data only in visible cell of Microsoft Excel: FullTimepass: MS ... MS EXCEL • View topic • Cell Text not fully visible in Formula BarI clicked again on cell and saw text in the formula bar but it is not visible in cell? 2.Data visible in formula bar, but not in cells Several coworkers just switched ... Excel cell contents not visible - but show in formula bar and ...The data will 'reappear' when 'select all' and then 'copy to ... re: Excel cell contents not visible - but show in formula bar and print preview 7/24/2012 12:08:54 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
66 followers. 