Question:
Hi,
We have been using a macro that automates the excution of queries by calling the SAPBEXsetFilterValue method in sapbex.xla. Most of our users are on Excel 97 and the macro works fine. However, it doesn't seem to work on a machine that has been upgraded to Office 2003. The call to SAPBEXsetFilterValue is executed but the filter doesn't seem to be applied. Has anyone else experinced this problem?
Thanks,
_________________
CF
Answer:
I didn't have this specifc problem, but we did haveother issues whit the upgrade of Office to 2003. So :
- log an OSS note if there is nothing on there concerning your prob. (beware : this will take some time. They will ask to delvier some trace files first...)
- try to get to one of the highest front-end patches for BW (we're on 12)