Tried to open a existing Excel file and Excel destroyed the file

%3CLINGO-SUB%20id%3D%22lingo-sub-1676265%22%20slang%3D%22en-US%22%3ETried%20to%20open%20a%20existing%20Excel%20file%20and%20Excel%20destroyed%20the%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1676265%22%20slang%3D%22en-US%22%3E%3CP%3EI%20tried%20to%20open%20an%20existing%20Excel%20file%20with%20my%20mailing%20contacts%20and%20got%20a%20dialog%20before%20it%20would%20open%20the%20file%20asking%20about%20length%20of%20fields%20and%20did%20I%20want%20comma%20delimited....%20I%20just%20wanted%20to%20open%20the%20file%20to%20work%20on%20it%20but%20had%20to%20answer%20something%20in%20this%20dialog%20or%20I%20could%20not%20move%20forward%2C%20I%20made%20a%20choice%20just%20to%20get%20rid%20of%20it%20and%20when%20I%20saw%20the%20file%20the%20fields%20were%20overwriting%20each%20other%2C%20the%20file%20was%20basically%20ruined%20and%20so%20I%20quit%20Excel%20to%20close%20and%20get%20out.%20Before%20I%20go%20back%20and%20try%20to%20open%20the%20file%20again%2C%20is%20there%20any%20reason%20this%20dialog%20appeared%3F%20I%20am%20doing%20nothing%20fancy%2C%20just%20a%20list%20of%20names%20and%20addresses.%20How%20on%20earth%20can%20I%20restore%20my%20existing%20file%3F%20In%2020%2B%20years%20of%20using%20Excel%20I%20have%20never%20seen%20this%20before.%20Please%20help%20as%20I%20need%20to%20either%20start%20my%20entire%20mailing%20list%20file%20over%20from%20scratch%20and%20need%20to%20know%20how%20to%20prevent%20this%20from%20happening%20again.%20Here%20is%20the%20window%20that%20opened%20up%20that%20I%20saw%20when%20I%20opened%20the%20file.%20Is%20this%20something%20I%20need%20to%20learn%20more%20about%20as%20I%20do%20want%20to%20use%20my%20list%20for%20just%20name%20and%20email%20to%20the%20entire%20list%20eventually.%3CBR%20%2F%3E%3CBR%20%2F%3ETIA%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1676265%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1676766%22%20slang%3D%22de-DE%22%3ESubject%3A%20Tried%20to%20open%20an%20existing%20Excel%20file%20and%20Excel%20destroyed%20the%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1676766%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F775125%22%20target%3D%22_blank%22%3E%40Ken_Nielsen365%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIt%20is%20probably%20a%20text%20file%20that%20you%20tried%20(or%20could%20have%20accidentally%20preset)%20to%20open%20with%20Excel.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EThis%20is%20only%20a%20guess%2C%20without%20a%20file%20it%20is%20difficult%20to%20give%20you%20an%20exact%20or%20reasonable%20answer.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3E%3CSPAN%20class%3D%22%22%3EEven%20if%20it%20is%20said%20that%20a%20picture%20is%20worth%20a%20thousand%20words%2C%20unfortunately%20it%20is%20not%20so%20in%20excel.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EIt%20is%20always%20better%20if%20you%20include%20a%20file%20(without%20sensitive%20data)%20in%20your%20question%2C%20so%20you%20can%20get%20an%20answer%20faster.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I tried to open an existing Excel file with my mailing contacts and got a dialog before it would open the file asking about length of fields and did I want comma delimited.... I just wanted to open the file to work on it but had to answer something in this dialog or I could not move forward, I made a choice just to get rid of it and when I saw the file the fields were overwriting each other, the file was basically ruined and so I quit Excel to close and get out. Before I go back and try to open the file again, is there any reason this dialog appeared? I am doing nothing fancy, just a list of names and addresses. How on earth can I restore my existing file? In 20+ years of using Excel I have never seen this before. Please help as I need to either start my entire mailing list file over from scratch and need to know how to prevent this from happening again. Here is the window that opened up that I saw when I opened the file. Is this something I need to learn more about as I do want to use my list for just name and email to the entire list eventually.

TIA,

 

Ken

1 Reply

@Ken_Nielsen365 

It is probably a text file that you tried (or could have accidentally preset) to open with Excel. This is only a guess, without a file it is difficult to give you an exact or reasonable answer.
 
Even if it is said that a picture is worth a thousand words, unfortunately it is not so in excel.
It is always better if you include a file (without sensitive data) in your question, so you can get an answer faster.
 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.