Opening XRU file crashes Excel

[bunchukokoy]

Hello guys,

Can anyone tell how opening an XRU file crashes the Excel instance? Here are the ff conditions when it happens in my end.

- Crashing happens when I am currently logged-in in the TM1 instance then I open the XRU file
- No corresponding corrupt/ hidden file to the XRU file in the dir where the file resides
- The file (including comments) contains 1509 lines of rules and feeders
- It has four back-up tabs with about the same number of lines. I already deleted 10 back-up tabs.
- No hidden sheet in the XRU file
- No broken link/ formula in the file
- No texts in columns "B" and onwards. All are in column A
- Turned Auto-Calculation off, nothing happened
- Unticked integrated log-in option
- I tried opening the XRU file without prior log-in to the TM1 instance, it does not crash even when I log-in and save the file. But the other way around, it does not work.

Thanks very much!

[gtonkin]

From time to time I have similar issues with Activeforms-you open a saved version, Excel dies if TM1 add-in is active and logged in.
Try this:

• Open up the VBA environment
• Create a new Sub e.g.

  Code: Select all

  Sub deathtest()
  Debug.Print "Avoid add-ins killing Excel"
  End Sub
  

• Step into the function using F8
  Now you are in step mode and other VBA executions should not take place.
• Switch back and open your XRU file-probably won't work from Server Explorer, you would need to open file directly.

An alternative may be to set Application.EnableEvents=False

Not sure if either will help as I have not used an XRU for ages-good luck.

[Solanna]

Instead of trying to figure out why the XRU is corrupt, why don't you just recreate the file

Open the XRU when not logged into TM1
Copy the "live" worksheet into another workbook
Save the workbook as an XLSX file
Rename the original XRU... for example file.XRUOLD
Change the extension on the new workbook to the original name of the XRU.. file.XRU
Open the new XRU while logged into TM1
If it doesn't crash then compile and save the new XRU

If it does crash then you will know it's the code in the file and not the file itself