企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 406|回复: 1

Active Form Formula Edit

[复制链接]

86

主题

402

帖子

589

积分

高级会员

Rank: 4

积分
589
QQ
发表于 2014-3-17 06:23:09 | 显示全部楼层 |阅读模式
Has anyone ever seen behavior in an active form where when you go to edit the formula by pressing F2 or by editing the forumla directly excel does not recognize the formula and just displays the DBRW formula as text instead of recalcing the DBRW.

So for example if I had a DBRW in a cell that was displaying $100, I then edit the formula and instead of recalcing it says =DBRW(cube, Dim1, dim2, dim3), then when I press to rebuild the current sheet it changes the formula to something like this =DBRW(cube, RC2000, RC2010, RC2020), so no error just showing the text again.
回复

使用道具 举报

70

主题

353

帖子

524

积分

高级会员

Rank: 4

积分
524
QQ
发表于 2014-3-17 08:21:31 | 显示全部楼层
It is a bit of an annoying one when this happens, you can solve it by:

    [1] Edit format type in the cell to general (from text)
    [2] Click in the formula bar and then press ENTER
    [3] Rebuild the sheet

Also make sure that the formatting rows are set to general up the top.

HTH
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2020-11-28 21:04 , Processed in 0.128894 second(s), 14 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表