file format not valid

Kay · May 23rd, 2002, 03:16 PM

Can anyone help me out, I have just a normal data base with addresses and phone numbers in excel....suddenly I can't open it, as it states, file format not valid...what happened, how do I retrieve this file

_________________
Appreciate your help.

[ This Message was edited by: Kay on 2002-05-23 14:17 ]

PaddyD · May 23rd, 2002, 03:29 PM

Kay,

If it's really knackered you could try opening it in a text editor (eg notepad), saving the file as a text file (mydatabase.txt) then open the text file in excel. NB - if you do this, none of you original formatting will be preserved, so you'll have to go & re0format everything.

Hope this helps,
Paddy

Kay · May 23rd, 2002, 04:40 PM

Thank you...hope this does it

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 03:16 PM	#1
Kay New Member Join Date: May 2002 Posts: 2	Can anyone help me out, I have just a normal data base with addresses and phone numbers in excel....suddenly I can't open it, as it states, file format not valid...what happened, how do I retrieve this file _________________ Appreciate your help. [ This Message was edited by: Kay on 2002-05-23 14:17 ]

May 23rd, 2002, 03:29 PM	#2
PaddyD MrExcel MVP Join Date: May 2002 Posts: 13,278	Kay, If it's really knackered you could try opening it in a text editor (eg notepad), saving the file as a text file (mydatabase.txt) then open the text file in excel. NB - if you do this, none of you original formatting will be preserved, so you'll have to go & re0format everything. Hope this helps, Paddy

May 23rd, 2002, 04:40 PM	#3
Kay New Member Join Date: May 2002 Posts: 2	Thank you...hope this does it