Data in cells disappear temporarily

B

Bagia

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

Bagia

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

June7

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

Bagia

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

Steve Dubrava

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I insert rows BELOW, in Excel 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to avoid "insert copied cells"? 6
Insert rows and keep merged cells in the inserted row 1
Inserting a Copied Row inside a table 6
Creating a formula to highlight a row of cells 3
updating linked cells 1
Copy data from unlocked cells 3

Top