Error encountered, Help~

[nickyclp]

I am using eviews 4.1.

I was trying to create a workfile.
the steps were:

File > news > workfile > select undated > set end of observation > ok
File > import > read text-lotus-excel > set order > set upper-left data cell > set excel 5+ sheet name > name for series in number... > ok

My file is here.

fyp.xls

(1.71 MiB) Downloaded 286 times

however, an error message appear:

" invalid cell type found in excel file"

this problem only start occur today. before this it is fine.
is my excel file corrupted?

Thank you. :D

[EViews Glenn]

What version of Excel was used to create the file?

[nickyclp]

the version of excel i using is excel 2007.

then i convert it to excel 2003. thank.

[EViews Glenn]

I really can't say what the problem might be. Given that you said that it worked until recently, there does appear to be a problem with the file as EViews 7 only reads the first column.

[nickyclp]

so... is it suggested i need to retype all my details in a new excel file?

[EViews Glenn]

Why not export the data from Excel to text, cleanup if necessary, then re-read into Excel and EViews?