Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash

Post bug reports and the status of reported bugs
Post Reply
User avatar
Alan Kirk
Site Admin
Posts: 5806
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia

Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash

Post by Alan Kirk » Fri Aug 03, 2018 10:47 pm

I haven't submitted this at this point because I need to check whether this is just a "my machine" thing or something that applies to everyone.

Environment: Windows 10 professional 64 bit.
TM1 10.2.2 FP 7
Excel 2016 (64 bit) from Office 365. Note particularly the "64 bit" part which is where I suspect this issue is coming from.

If I select "Dimension Open" in Perspectives to update an .xdi, then:
(a) If the data directory specified is empty, then an empty list will be shown as expected; but
(b) If the data directory has even a single file (.xdi) in it, Excel will generate an "Automation Error" warning, then crash.

If the data directory is empty I can create a new dimension and save it correctly. (Although Excel will shove the ever-accursed "Book1" in my face after it creates the new .xdi and I have to manually change to the new .xdi file.) However once the file is saved, I can't re-open it through Dimension Open because... Automation Error, crash.

(Workaround: It can be opened as a regular file, updated and saved as a dimension without any major problem. other than the irritating Extension Hardening warning which of course I immediately turned off.)

I'm not encountering this with PA2 (the bits that actually work, that is; Perspectives and Web but not PAX because, well, Docker), but in the PA2 test environment (on a different machine) I'm using Excel 2016 (Office 365) 32 bit.

It could therefore be specific to my machine or, what I think is more likely, there's an issue with the VBA code that reads the list of files in the data directory when it's run by 64 bit Excel.

Is anyone else experiencing this in a similar environment?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

Post Reply