excel 2007 crashes when saving a specific file

**dvb_24** · 07-01-2009, 07:34 PM

Hi all, I've reinstalled office 2007 because excel 2007 was crashing very often when inserting new rows or when saving the file. I tried with other files and apparently work fine. The specific file can be opened but I don't know if is corrupted, I tried repairing it with open and repair from the file open menu but didn't work (it is still happening the same). I've been working on the file during few days and wouldn't like to start from scrath again, can anyone help me with this?

**martindwilson** · 07-01-2009, 08:20 PM

try copying each sheet into a new work book
1st try(quickway)
open a new workbook ,save it as something leaving it open
right click any tab of old workbook
select all sheets
right click again
select move/copy
click create copy
from dropdown select other workbook name click ok
2nd try
copy each sheet individually.

**dvb_24** · 07-02-2009, 04:32 AM

Thanks Martin, but didn't work, apparently the file is ok but I cannot insert or save, any other alternatives?

**martindwilson** · 07-02-2009, 05:18 AM

did the newone crash as well ?
is it xlsx or xlsm

**dvb_24** · 07-27-2009, 12:59 PM

It is xlsm, you are right, the new one crashes as well. I found that if you delete few rows before inserting a new one it works but it is anoying... it seems like excel counts that the maximum number or rows has been exceeded and hanges??? there is also a cell that if I modify its value excel hanges as well have you heard about something similar?

**nih** · 07-27-2009, 01:21 PM

Have you tried opening file on other machine?

also it will help if you updload your file here...

**dvb_24** · 07-29-2009, 07:45 AM

Yes I tried in other laptop with similar results. The file contains sentitive data a cannot post it here. Have you heard about any bug related to the maximum number of rows allowed in an excel sheet? I think the problem has partially to do with that.

**martindwilson** · 07-29-2009, 08:03 AM

since its xlsm ,any code in workbook?

**dvb_24** · 08-04-2009, 07:53 AM

I solved it! I copied everything again in a different sheet and remove the names on it and now is performing well, anyway I don't understand how the names were causing this...