Automatic update of a workfile based on Excel files

[CecileBF]

Hi,

I created a program to import some series from an Excel file.
Basically, the import code is built that way:
import(link) \\intra\partages\FOLDER\PMI_ALL_manuf.xlsx range="Monthly PMIs" colhead=8 namepos=custom colheadnames=(,"Name","Geography","Major Sector","Sector","Last Updated","Index","Description") na="#N/A" @freq M @id @date(earliest_top) @destid @date @smpl @all
It works but when I open the workfile and refresh the series (automatic update), I get this error message: "EARLIEST_TOP is not defined in "IMPORT(MODE=UO)"
How can I solve this issue ?

Regards

[EViews Gareth]

Could you provide the file?

[CecileBF]

The file is based on data from IHS Markit (for information).
Regards,
Cecile

[EViews Gareth]

Appears to work ok for me. Is there something else you're doing?

[CecileBF]

Thank you! I tried and it works for me that way as well too.
But I create a workfile before this step and the problem re-appears now:
wfcreate(wf=TRANSITION\dbpmi, page=m) m 1992 2040