Excel 2007 format problems

[jwfrederick]

Tom,

I am having trouble reading Excel 2007 format files.

I am using the following code at the start of the file:

end(reset)

cal(m) 1977
all 0 2020:1

open data "StateSMAIGDP.xlsx"
DATA(FORMAT=XLSX,ORG=COLUMNS,SHEET="RATS") /
close data

When I use the SAME CODE, but substitute XLS for XLSX (same file, just saved as older format), it reads fine. Is this a known bug in 7.3? Or is there something additional I need to do with XLSX format? I attach the XLSX format file for your reference.

Regards,

Jason Frederick

[moderator]

Jason:

When you get a chance, email us at

support@estima.com

I think we have a fix for you.

Thanks,
Tom Maycock
Estima