Excel file as data source

[charlie]

Hi all,
What should the format of an excel file if i want to make it a data source in cognos. Currently the file i am working with gets me this message after import.

Completed the import process.
No objects were created.

Any suggestions on how FM will recognise items in a excel file?
Thanks

[MFGF]

Hi,

You need to define at least one Named Region in your worksheet.  Each one you define then appears as a "table" when you point to it from C8.

Regards,

MF.

[charlie]

Thanks MF it worked :)