Opening an excel 2007 file in excel 2013

Dacker

New Member
Joined
Jan 5, 2005
Messages
46
Trying to open an excel 2007 workbook in excel 2013, I get the error message:
" We found a problem with some content in the file < file name.xlsm>. Do you want us to try to recover as much as we can? If you trust the source of the workbook click Yes. "
[YES] [NO]
After clicking YES , the following message appears :
Repairs to the< file name.xlsm>
"Excel was able to open the file by repairing or removing the unreadable content."
But conditional formatting and other features of the file are lost.
Any help will be much appreciated.
 
Last edited by a moderator:

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Having allowed Excel to "fix" the file and allow you to open it, what is the problem that you want help with ?
 
Upvote 0
you can try opening it in safe mode and extracting any codes or whatever "other features" is being erased, but most likely you just need to recreate the formatting in the new version.
to open in safe mode hold ctrl when opening excel and it will prompt you for safe mode

unfortunately comparability mode is not available for 2007 so this and an online converter is all i could think of.
 
Upvote 0

Forum statistics

Threads
1,214,643
Messages
6,120,702
Members
448,980
Latest member
CarlosWin

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