Related to AFO user variant

Hi,

One of our user has created report based on Analysis for Mircosoft office Excel. He has create one user variant. And that report is running successfully fine. But when he tries to schedule that report that saved user variant is not appearing in prompt tab of drop down list. And to fill that prompt he has to do it manually ? He always get error message, that Workbook contains no OLAP connection. Could you please help on it..