Hello,
I'm viewing an .xls file in MS excel 2007 that contains a large formatted
table. When I insert a new copied row, my data in other cells disappear. To
view them, I would have to highlight the cell range or double-click on the
whole worksheet. I wanted to move a row to a different area of the table, so
I did the following:

1) Insert a new row.
2) Select the row I want to move and right click, and then choose cut.
3) Go to the row that I inserted in step 1 and right-click, and then choose
insert copied cells.

Some of my data in other row cells disappear (invisible). To reveal them,
I would have to either highlight them or double-click on the entire worksheet.

Any ideas why this is happening?

Does the double-click restore visibility permanently?

"Bagia" wrote:

Hello,
I'm viewing an .xls file in MS excel 2007 that contains a large formatted
table. When I insert a new copied row, my data in other cells disappear. To
view them, I would have to highlight the cell range or double-click on the
whole worksheet. I wanted to move a row to a different area of the table, so
I did the following:

1) Insert a new row.
2) Select the row I want to move and right click, and then choose cut.
3) Go to the row that I inserted in step 1 and right-click, and then choose
insert copied cells.

Some of my data in other row cells disappear (invisible). To reveal them,
I would have to either highlight them or double-click on the entire worksheet.

Any ideas why this is happening?

No, if I do another cut and paste copied cells, other cell contents will
disappear temporarily.

"June7" wrote:

Does the double-click restore visibility permanently?

"Bagia" wrote:

Hello,
I'm viewing an .xls file in MS excel 2007 that contains a large formatted
table. When I insert a new copied row, my data in other cells disappear. To
view them, I would have to highlight the cell range or double-click on the
whole worksheet. I wanted to move a row to a different area of the table, so
I did the following:

1) Insert a new row.
2) Select the row I want to move and right click, and then choose cut.
3) Go to the row that I inserted in step 1 and right-click, and then choose
insert copied cells.

Some of my data in other row cells disappear (invisible). To reveal them,
I would have to either highlight them or double-click on the entire worksheet.

Any ideas why this is happening?

Still trying to puzzle this one out. What do you mean 'contains a large
formatted table'? Are these just worksheet cells with formatting? What format
settings? Double-clicking restores the display until next cut/paste,
otherwise remain visible through close and reopen? Might want to experiment
with same settings in another workbook, see if you can replicate the
condition.

"Bagia" wrote:

No, if I do another cut and paste copied cells, other cell contents will
disappear temporarily.

"June7" wrote:

Does the double-click restore visibility permanently?

"Bagia" wrote:

Hello,
I'm viewing an .xls file in MS excel 2007 that contains a large formatted
table. When I insert a new copied row, my data in other cells disappear. To
view them, I would have to highlight the cell range or double-click on the
whole worksheet. I wanted to move a row to a different area of the table, so
I did the following:

1) Insert a new row.
2) Select the row I want to move and right click, and then choose cut.
3) Go to the row that I inserted in step 1 and right-click, and then choose
insert copied cells.

Some of my data in other row cells disappear (invisible). To reveal them,
I would have to either highlight them or double-click on the entire worksheet.

Any ideas why this is happening?

Sorry for not being clear. The table style is applied to the cell range.
That is correct, the issue occurs when I do a cut/paste. I either have to
double-click the entire worksheet or highlight the cells to have the data
visible again. If I don't do a cut and paste, then the data remains visible
until I close the file. I tried to replicate the problem on a new workbook,
but haven't been successful. I've managed to copy data range and paste it on
to a new workbook. Problem resolved. Thanks for your help.

"June7" wrote:

Still trying to puzzle this one out. What do you mean 'contains a large
formatted table'? Are these just worksheet cells with formatting? What format
settings? Double-clicking restores the display until next cut/paste,
otherwise remain visible through close and reopen? Might want to experiment
with same settings in another workbook, see if you can replicate the
condition.

"Bagia" wrote:

No, if I do another cut and paste copied cells, other cell contents will
disappear temporarily.

"June7" wrote:

Does the double-click restore visibility permanently?

"Bagia" wrote:

Hello,
I'm viewing an .xls file in MS excel 2007 that contains a large formatted
table. When I insert a new copied row, my data in other cells disappear. To
view them, I would have to highlight the cell range or double-click on the
whole worksheet. I wanted to move a row to a different area of the table, so
I did the following:

1) Insert a new row.
2) Select the row I want to move and right click, and then choose cut.
3) Go to the row that I inserted in step 1 and right-click, and then choose
insert copied cells.

Some of my data in other row cells disappear (invisible). To reveal them,
I would have to either highlight them or double-click on the entire worksheet.

Any ideas why this is happening?

We are having the same issue Office 2007 SP2 says it helps this issue,
however we have SP2 installed and it still happens. Mostly in Compatibility
mode, but still happens with just a 2007 spreadsheeet. If you hit CTRL+ALT+F5
for refresh that does recover the screen but it is only a workaround at this
stage.

"Bagia" wrote:

Sorry for not being clear. The table style is applied to the cell range.
That is correct, the issue occurs when I do a cut/paste. I either have to
double-click the entire worksheet or highlight the cells to have the data
visible again. If I don't do a cut and paste, then the data remains visible
until I close the file. I tried to replicate the problem on a new workbook,
but haven't been successful. I've managed to copy data range and paste it on
to a new workbook. Problem resolved. Thanks for your help.

"June7" wrote:

Still trying to puzzle this one out. What do you mean 'contains a large
formatted table'? Are these just worksheet cells with formatting? What format
settings? Double-clicking restores the display until next cut/paste,
otherwise remain visible through close and reopen? Might want to experiment
with same settings in another workbook, see if you can replicate the
condition.

"Bagia" wrote:

No, if I do another cut and paste copied cells, other cell contents will
disappear temporarily.

"June7" wrote:

Does the double-click restore visibility permanently?

"Bagia" wrote:

Hello,
I'm viewing an .xls file in MS excel 2007 that contains a large formatted
table. When I insert a new copied row, my data in other cells disappear. To
view them, I would have to highlight the cell range or double-click on the
whole worksheet. I wanted to move a row to a different area of the table, so
I did the following:

1) Insert a new row.
2) Select the row I want to move and right click, and then choose cut.
3) Go to the row that I inserted in step 1 and right-click, and then choose
insert copied cells.

Some of my data in other row cells disappear (invisible). To reveal them,
I would have to either highlight them or double-click on the entire worksheet.

Any ideas why this is happening?