Home

Excel file loosing controls if saved in 2010 and opened in 2003 or 2007.

%3CLINGO-SUB%20id%3D%22lingo-sub-276362%22%20slang%3D%22en-US%22%3EExcel%20file%20loosing%20controls%20if%20saved%20in%202010%20and%20opened%20in%202003%20or%202007.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276362%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20spreadsheet%20that%20created%20with%20Excel%202003%20some%20time%20ago%20and%20has%20worked%20for%20quite%20a%20while.%3C%2FP%3E%3CP%3EHowever%20sometime%20recently%20it%20has%20become%20corrupt%20and%20if%20I%20open%20it%20in%20an%20older%20version%20of%20excel%20such%20as%202003%20or%202007%20I%20get%20a%20loss%20of%20data%20error%20and%20it%20comes%20up%20without%20any%20controls.%3C%2FP%3E%3CP%3EAttached%20I%20have%20a%20copy%20of%20this%20file%2C%20but%20everything%20else%20but%20the%20controls%20removed.%20The%20controls%20work%20fine%20in%202010%20or%20later%20but%20with%20not%20load%20in%202003%20or%202007.%3C%2FP%3E%3CP%3EThis%20does%20not%20happen%20to%20all%20sheets%2C%20but%20more%20and%20more%20cannot%20be%20used%20in%20old%20versions%26nbsp%3Bwithout%20me%20making%20any%20major%20changes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUpdate%3A%20I%20tried%20the%20file%20in%20Excel%202016%20and%20it%20could%20open%20the%20file%20fine%2C%20but%20the%20newly%20saved%20file%20still%20cannot%20be%20read%20properly%20in%20older%20versions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUpdate%202%3A%20I%20created%20a%20basic%20file%20in%202003%20with%20the%20same%20forms%20and%20they%20way%20they%20are%20supposed%20to%20look.%20The%20biggest%20difference%20is%20that%20the%20clean%20file%20is%20only%2016%20KB%20while%20the%20corrupt%20one%20is%20602%20KB.%20What%20is%20adding%20the%20extra%20size%20and%20how%20can%20I%20clean%20it%20up.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-276362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-276856%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20file%20loosing%20controls%20if%20saved%20in%202010%20and%20opened%20in%202003%20or%202007.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276856%22%20slang%3D%22en-US%22%3E%3CP%3EI%20seem%20to%20have%20found%20a%20workaround.%20I%20converted%20the%20file%26nbsp%3Bto%20xlsx%20and%20then%20saved%20again%20as%20xls.%20Both%20files%20then%20worked%20in%202003%20and%202007%20and%20the%20xls%20became%20450%20KB.%20Still%20much%20bigger%20than%20the%20clean%202003%20version%20but%20smaller%20than%20the%20corrupt%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20still%20like%20to%20know%20the%20actual%20cause%20of%20the%20corruption%20and%20hopefully%20prevent%20it%20in%20the%20future.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Mchael E
New Contributor

I have spreadsheet that created with Excel 2003 some time ago and has worked for quite a while.

However sometime recently it has become corrupt and if I open it in an older version of excel such as 2003 or 2007 I get a loss of data error and it comes up without any controls.

Attached I have a copy of this file, but everything else but the controls removed. The controls work fine in 2010 or later but with not load in 2003 or 2007.

This does not happen to all sheets, but more and more cannot be used in old versions without me making any major changes.

 

Update: I tried the file in Excel 2016 and it could open the file fine, but the newly saved file still cannot be read properly in older versions.

 

Update 2: I created a basic file in 2003 with the same forms and they way they are supposed to look. The biggest difference is that the clean file is only 16 KB while the corrupt one is 602 KB. What is adding the extra size and how can I clean it up.

1 Reply

I seem to have found a workaround. I converted the file to xlsx and then saved again as xls. Both files then worked in 2003 and 2007 and the xls became 450 KB. Still much bigger than the clean 2003 version but smaller than the corrupt version.

 

I would still like to know the actual cause of the corruption and hopefully prevent it in the future.