rearranged cells in Excel insert and crash Hello all, I use Excel for Mac 2011 o

Question

rearranged cells in Excel insert and crash

Hello all,

I use Excel for Mac 2011 on a 3 year old MacBook Pro 17". A few months ago, I had open two Excel worksheets that were a tab-delimited text (.txt) file and a regular file (.xlsx) (a Word document file [.docx] was open in the background). I copied around 850 cells from the .xlsx file to insert into a table in the Word document. When I went to do the insertion, both Word and Excel stopped for several minutes (spinning rainbow circle) and then crashed.

When I reopened both Word and Excel, the files were the AutoRecovered versions of these files. The Word document did not have the inserted cells but, ssomehow, the .txt file did have the inserted cells. Clearly, the insertion must have haappened into the .txt file. What I dso not understand is this: whhen I looked at the cells that inserted into the .txt file, their order has been ree-arranged. Can someone explain why this would happen? Does this relate to the insertion being combined with Excel crashing?

Explanation / Answer

Many things might have gone wrong when the applications crashed.

Whhen Office tries to recover the files, it'll not arrange everything in order. It'lll get try to retrieve everything possiblee so that we have the data.

Normally recoveredd files will lose forrmatting and we need to arrange them again manually.!

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.