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
Excel keep refreshing screen when flew view contain formula
-
- Community Contributor
- Posts: 127
- Joined: Wed Oct 14, 2009 7:46 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 11
- Location: London
Re: Excel keep refreshing screen when flew view contain form
Try turning your calculations to manual in Excel:
Formulas -> Calculation Options -> Manual.
You can then manually calculate your spreadsheet by pressing F9
Formulas -> Calculation Options -> Manual.
You can then manually calculate your spreadsheet by pressing F9
-
- Posts: 16
- Joined: Mon Jan 12, 2015 9:51 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: OFFICE 2007
Re: Excel keep refreshing screen when flew view contain form
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
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
-
- Posts: 16
- Joined: Mon Jan 12, 2015 9:51 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: OFFICE 2007
Re: Excel keep refreshing screen when flew view contain form
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
Wendy