TM1 Forum

Hi,
When I insert some formulas in flexview in Excel, if I click the Refresh button in CAFE pane, the excel screen will keep refreshing and flashing.
The more formulas I add in excel, the more Refresh time it needs. In one of my worksheets which cotain 1200 formulas, it takes more than 5mins in Refreshing, the screen keeps flashing,and I only can press the ESC key to stop refreshing, then an error occur as following:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Microsoft VisualBasic

Run-time error '1004'
Method 'ScreenUpdating' of objet '_Application' failed.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Is this a bug of CAFE？how can I solve this problem?

Thanks.
Wendy

Try turning your calculations to manual in Excel:

Formulas -> Calculation Options -> Manual.

You can then manually calculate your spreadsheet by pressing F9

Hi Dan,
I have set the calculations to manual, but it doesn't work.
The F9 only can refresh the cells which has excel functions. Only the Refresh button in Cafe can retrive/refresh value from server.

Thanks
Wendy

It seems Cafe 10.2.2FP2 has repaired this bug, I have done some tests,and the excel screen didn't flash so many times as before.

Wendy