企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 203|回复: 3

Perspectives error when refreshing workbook with Cha ...

[复制链接]

82

主题

368

帖子

548

积分

中级会员

Rank: 3Rank: 3

积分
548
QQ
发表于 2014-3-19 08:20:24 | 显示全部楼层 |阅读模式
Quite puzzled with the error, encountered it on 9.5.2 FP2, FP3, CX10.1 and still testing. Thought I'd ask here while waiting for IBM support update.

Looks like that having a Chart sheet in workbook is unsupported, refreshing Excel book with any Chart sheet (without any TM1 formulas in it, for example) leads to Runtime Error 13: Type Mismatch VBA Error and subsequent "Item with specified name not found" message. Menu icon names become crippled, so I'd guess that happens while loading it.

I'm attaching a small workbook with simple chart and data list, error is easily reproduced by opening it and then connecting to any TM1 server.

Anyone seen this before or am I so lucky? Any known workarounds (except for obvious ??don't use it??)?
回复

使用道具 举报

73

主题

375

帖子

517

积分

中级会员

Rank: 3Rank: 3

积分
517
QQ
发表于 2014-3-19 09:31:05 | 显示全部楼层
I've encountered this sporadically too.  I think the only way to work around it is to not have a chart sheet.  Instead have the graph embedded in a normal worksheet.

I would guess it's got something to do with the auto-calculate macro not finding something in a chart sheet that exists in a worksheet.

Martin
回复 支持 反对

使用道具 举报

76

主题

396

帖子

574

积分

中级会员

Rank: 3Rank: 3

积分
574
QQ
发表于 2014-3-19 09:44:41 | 显示全部楼层
Thank you, Martin.

Let's see what IBM comes back with, I can't see a ??Excel Chart sheets are not supported?? line anywhere in the documentation. And I got a chart-loving customer )
回复 支持 反对

使用道具 举报

80

主题

399

帖子

565

积分

中级会员

Rank: 3Rank: 3

积分
565
QQ
发表于 2014-3-19 11:02:47 | 显示全部楼层
Just in case, it's confirmed as an APAR (don't have number yet).
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2018-4-27 14:48 , Processed in 0.199106 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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