EViews.com

When i try to have eviews read data in excel 2007, i am getting no error message but the series comes back (mostly) empty and with the name "pk"
If i save the same excel spreadsheet as excel 97-2003, eviews reads the data fine
This is an "upgrade" that i made to excel 2007 that has cause me no end of grief
Can eviews 7 read data from excel 2007? or do i need to save all of my worksheets as excel 97-2003?
Thanks

EViews 7 can read Excel data using the Open or Import methods (not the Read method).

If you think there is something going wrong, could you post the relevant Excel 2007 file?

Ok, I understand. Here is how i operate (I have been using EViews for a decade, so you may find that i am a bit "old skool" -- let me know if there is a better way to operate):
- i build data matrices in excel
- i use excel for data visualization and manipulation
- when i am read to use eviews, i wrote a program using "read" to pull in specific columns of data from excel
- the data will be found in different sheets, different tabs, and different locations -- it isnt contiguous

What is not clear in the "import" command is if i can specify a specific row/column to anchor the import -- e.g.

read(b4, s=Data_Dailyt) "L:\Temp.xls" 1

what would be the "import" analogue to the above?

Thanks

Try: (Note this will read data from B4 to C100 - you might want to change the ending point to something else).