Hi,
I am using XP and Excel 2007.
I have no problem in refreshing data and editing queries in Microsoft Query in the past. Results came back in seconds. Recently I installed Essbase on mine, I could still refresh data in seconds but when I edited query, it took forever. From network connection, I could see that only 2 packets returned every second whereas in the past, it used to be 1M or 2M packets returned per second. I tried editing same query using other machines with no Essbase add-in, they had no problem. Any suggestions?
Thanks,
PKL
I am using XP and Excel 2007.
I have no problem in refreshing data and editing queries in Microsoft Query in the past. Results came back in seconds. Recently I installed Essbase on mine, I could still refresh data in seconds but when I edited query, it took forever. From network connection, I could see that only 2 packets returned every second whereas in the past, it used to be 1M or 2M packets returned per second. I tried editing same query using other machines with no Essbase add-in, they had no problem. Any suggestions?
Thanks,
PKL
