"2 - Have you tried saving as .xls first?"
Use Save As for any open file of any format to save with a different name or
format.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"gford" wrote in message
...
Perhaps I don't know the definitions? Which question did I not answer?
Please specify. MLS only exports in .csv files. Can I convert them? I
thought that I identified what a header was. Sold price vs. sold date.
If
not please specify.
Thank you, Greg
"Jon Peltier" wrote:
Sean asked two questions, but you answered only one.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"gford" wrote in message
...
Hello Sean, Thank you for responding to me! Yes there are headers for
every
column. I am a realtor exporting data out of MLS and it only exports
in
.csv
files. The headers I am trying to graph are sold price vs. sold date.
And
there is a string of numbers below each header. I highlight both
headers
and
then hit the chart icon. The data range field is blank. At this point
I
try
to re-highlight and I still get the same error message. Have any
ideas?
Thank you,
Greg
"Sean Timmons" wrote:
A couple thoughts:
1 - Do you have headers for every column?
2 - Have you tried saving as .xls first?
"gford" wrote:
I am trying to chart two columns from a .csv file. In the Chart
Wizard.
When it gets to the Data Range, the field is blank. So I high lite
the
two
columns again, and try to hit next button. Microsoft excel says, "A
formula
in this worksheet contains one or more invalid references. Verify
that
formulas contain a valid path, workbook, range name, and cell
reference. It
won't chart my data. What should I do? Is it 2003 excel fault?
If I try to chart a .xml file with the same steps and it works.
Also
out of
the high lited columns; Data Range field is already filled in
correctly
with
columns check marked. And then it charts for me! Does excel 2003
chart .csv
files?