Getctdata error

%3CLINGO-SUB%20id%3D%22lingo-sub-1662673%22%20slang%3D%22zh-CN%22%3EGetctdata%20error.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1662673%22%20slang%3D%22zh-CN%22%3E%3CP%3EGetctdata's%20function%20is%20to%20get%20data%20from%20SAP%20and%20use%20it%20normally%20under%20office2013.But%20after%20upgrading%20to%20O365E3%2C%20it%20can't%20be%20used%2C%20the%20form%20becomes%20%40getctdata%2C%20and%20the%20result%20is%20also%20shown%2C%20it%20becomes%20%22%23Name%3F%22%2C%20see%20the%20screenshot%20of%20the%20attachment.%3C%2FP%3E%3CP%3EI%20don't%20know%20who%20can%20give%20some%20advice%2C%20thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1662673%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Getctdata的功能是从SAP获取数据,在office2013下使用正常。但是在升级到O365E3之后,就不能用了,形式变成了@getctdata, 结果也部显示,变成了"#Name?",请看附件的截图。

不知哪位能给点建议,谢谢。

1 Reply
Highlighted

@Allan0852 

That's implicit intersection operator https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1... which is added for compatibility of Excel versions with and without dynamic arrays, more about that in the post above. In general it could be removed, but perhaps your issue is that GETCTDATA() is not available for Office 365 version. I guess that's SAP-specific function added with some add-in which is not installed for newer version.