Working with a 2007 excel file in excel 2013

[Jim rhodes]

I have a file that was created with excel 2007. We have move on now to excel 2013 (office365). This file track our utilization and contains a lot of data that I cant afford to lose. The problem is I can open it in excel 2013. I can make changes and do what I need to do but when I try to close and or save the file i get a error stating that Microsoft excel has stopped working. I really need to figure this out. Thanks in advance on any help you might be able to give me.

 

[SpillerBD]

and they call it a "joy" buzzer.
It is probably corrupt, but there are ways to try and have Excel Repair.
Make a copy of the file.
Use the file Open method where you navigate to the file. In the lower right is an Open button with a selection arrow. Click it and use the "Open and Repair"

 

[Jim rhodes]

and they call it a "joy" buzzer.
It is probably corrupt, but there are ways to try and have Excel Repair.
Make a copy of the file.
Use the file Open method where you navigate to the file. In the lower right is an Open button with a selection arrow. Click it and use the "Open and Repair"

Thanks for your suggestion but I have tried that avenue already. I can still open it and save it with 2007. I can also open and save it with 2010 but not 2013. I even tried opening it in 2010 and saving it and then tried to open and save it is 2013 but no luck. What ever the problem is it was something that was changed in 2013 and not 2010. I can open it in all the different series of software... 2007, 2010 and 2013... but when it comes to closing and saving changes 2013 errors out every time...I approeciate any help

 

[SpillerBD]

Seems like I was disappointed at first too. But I took a method from QuickBooks and ran the Excel Repair multiple times and eventually found some improvement.
It sounds like you could rebuild or export the data to a new workbook. Alternatively the other way to recover the file is to open the tables from the zip file (change the XLSX extension to ZIP and then open/import the tables to a new workbook.)

Are there any macros on the file? Especially any that event related?