rearranged cells in Excel insert and crash

mskumar1512

New Member
Joined
Jul 29, 2014
Messages
3
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, somehow, the .txt file did have the inserted cells. Clearly, the insertion must have happened into the .txt file. What I do not understand is this: when I looked at the cells that inserted into the .txt file, their order has been re-arranged. Can someone explain why this would happen? Does this relate to the insertion being combined with Excel crashing?

Madhu
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top