Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Crashing when a row is inserted
Hi,
I am getting a problem where excel crashes if I insert a row, it seems to be something on the sheet as the file has been tried on several computers with the same problem. We had a crash the other day, suspect bad ram so i think some data must be corrupted. I can load a known good backup but when i cut and paste the data into it the same occurs. If i do a paste special/values a message comes up 'merged cells must be identically sized'. How do i find the merged cells, im pretty sure non should be. Any help appreciated |
#2
|
|||
|
|||
Well I highlighted the entire data area, went to format/alignment and there
was a tick in a grey background in 'merge cells', unticked the box and all seems fine. I just wish the error messages could be a little more intuitive. Rick "R D S" wrote in message ... Hi, I am getting a problem where excel crashes if I insert a row, it seems to be something on the sheet as the file has been tried on several computers with the same problem. We had a crash the other day, suspect bad ram so i think some data must be corrupted. I can load a known good backup but when i cut and paste the data into it the same occurs. If i do a paste special/values a message comes up 'merged cells must be identically sized'. How do i find the merged cells, im pretty sure non should be. Any help appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot open inserted objected in worksheet | Excel Discussion (Misc queries) | |||
Excel crashing on save as | Excel Discussion (Misc queries) | |||
Excel crashing when typing VLOOKUP | Excel Discussion (Misc queries) | |||
How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) | |||
How do I know if another user have inserted a web query on my wshe | Excel Worksheet Functions |