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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies