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:

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,872
Office Version
  1. 365
Platform
  1. Windows
Having allowed Excel to "fix" the file and allow you to open it, what is the problem that you want help with ?
 

DataBlake

Well-known Member
Joined
Jan 26, 2015
Messages
781
Office Version
  1. 2016
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,415
Messages
5,571,973
Members
412,430
Latest member
Huuktkt
Top