We recently upgraded to Office 2007.
Prior to the upgrade, we used a Bex query as source data in an Excel file. Other tabs in the same file would link to the data source tab. Each month we would right click on the BI query and refresh the data and it would bring up a listing of variable values.
Now we are in Excel 2007. When we try to refresh the query now, we get the following messge:The workbook does not contain any input ready variables".
BI and the query are working because if I go directly to BI, I can get the query to refresh. If I go through the workbook (which is saved on the local drives and not in BI) it does not.