Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
Why does my file go blank when saved as a .dbf
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
In my simple testing in xl2003, my file didn't go blank.
You may want to post more details on what you did--and what version of excel you're using. (and what version of .dbf, too.) lelykg wrote: Why does my file go blank when saved as a .dbf -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
My version of excel is 2002 on xp pro
The files contents always disappear without having to open the dbf with visual foxpro 9.0 I would open the file saved as a .dbf in excel after saving and it would be blank in excel "Dave Peterson" wrote: In my simple testing in xl2003, my file didn't go blank. You may want to post more details on what you did--and what version of excel you're using. (and what version of .dbf, too.) lelykg wrote: Why does my file go blank when saved as a .dbf -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
I don't use .dbf very often...
But excel uses a range named DataBase when it saves to the .dbf file. Make sure your range named DataBase includes everything you want to keep. You may want to delete that name (insert|name|define dialog) and reapply it to your real data. lelykg wrote: My version of excel is 2002 on xp pro The files contents always disappear without having to open the dbf with visual foxpro 9.0 I would open the file saved as a .dbf in excel after saving and it would be blank in excel "Dave Peterson" wrote: In my simple testing in xl2003, my file didn't go blank. You may want to post more details on what you did--and what version of excel you're using. (and what version of .dbf, too.) lelykg wrote: Why does my file go blank when saved as a .dbf -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
Thanks that Solved the problem
"Dave Peterson" wrote: I don't use .dbf very often... But excel uses a range named DataBase when it saves to the .dbf file. Make sure your range named DataBase includes everything you want to keep. You may want to delete that name (insert|name|define dialog) and reapply it to your real data. lelykg wrote: My version of excel is 2002 on xp pro The files contents always disappear without having to open the dbf with visual foxpro 9.0 I would open the file saved as a .dbf in excel after saving and it would be blank in excel "Dave Peterson" wrote: In my simple testing in xl2003, my file didn't go blank. You may want to post more details on what you did--and what version of excel you're using. (and what version of .dbf, too.) lelykg wrote: Why does my file go blank when saved as a .dbf -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |