Windows 10: Starting multi excel instance runs into problems whenever there is any add-in is enabled.

I have a domain user needs to use multi excel instance every day. Recently when he tries to start a new excel instance, as long as there is any excel addin currently enabled, then the startup of 2nd instance will take long loading, eventually prompts error saying, "Excel is running into problems with 'c:\program files\microsoft office\root\office16\library\analysis\analys32.xll'. Disable this add-in and check for available updates. Do you want to disable it now?" I looked around checking what the issue was and had no luck. Below are some items i tested. 1. The error is not limited to the p

:)

 

Excel 2016(Macro enabled) crashes on closing for the first instance?

Hi,

To better assist you, kindly provide us the following information:

• What is the current build of your Windows 10? To know the build of your Windows 10, do the following:
  • Simultaneously press the Windows key and the letter R on your keyboard.
  • On Run, type winver, and then click
    OK.
  • On About Windows, you'll see the OS build under Microsoft Windows.
• When did the issue start?
• Any changes prior to the concern?
• Is the issue only happens on all macro-enabled Excel files or only on a specific Excel file?
• Is the issue also happens when opening an Excel file without using the C++ code?

Hope to hear from you soon.

 

Export All Administrative Events to Excel

To analyze events, from the Windows Event Viewer, there is a simple way to export all Administrative Events to Excel, with PowerShell.

Exporting all Administrative Events to Excel is a simple two Step process, as described here:

Step 1 - Create the Administrative Events View .xml file

1. Open Eventviewer (%windir%\system32\eventvwr.msc)
2. Navigate to: Event Viewer (Local) > Custom Views > Administrative Events
3. In the “Actions” pane select “Filter Current Custom View”.
4. Select the the XML tab.
5. Press Ctrl+A to select all the XML code of the Custom View.
6. Open a notepad, paste the selected code and save the file to your Desktop as AdmEvtView.xml

Step 2 - Create the csv file with the events

1. Download the ExportEvtCSV.zip file, which contains the script ExportEvtCSV.ps1 and unzip it, on your Desktop.
   It's not a fancy script, just basic PowerShell commands to create a csv file on the Desktop.
2. In Windows Search, type “ISE” (without the quotes) to open “Windows PowerShell ISE” and Run as administrator
   
3. To allow running the script, change the ExecutionPolicy, for this session. To do that, in the Console pane type:
   Code:
4. In the Windows PowerShell ISE, open and run the script: ExportEvtCSV.ps1
   The script will create a csv file with a name YYYYMMDD.HHMM.csv on the Desktop
5. When done, open the newly created .csv file, format the columns as needed and optionally save it as .xlsx, if you wish.

That’s it! You now have all the Administrative Events in Excel for filtering and further analysis.

Now to the more technical hard stuff... *Confused

There is a reason for running the script from within PowerShell ISE!

It would be great if everything was also working perfectly, when running the script from an elevated PowerShell too.

We can run it from an elevated PowerShell, which means that you just follow the Step 1, as above but for the Step 2 instead of the ISE you run the script from an elevated PowerShell.

The problem is that it will work only for anybody who has en-US format for the dates. Everyone else, who has another format (i.e. en-GB, fr-FR, el-GR etc.), the dates are not translated properly by Excel (although the script uses the –UseCulture switch) and remain as text in the en-US format.

I'm not sure if this a bug of the "export-csv" cmdlet, but although it runs the way it supposed to from within the ISE, from PowerShell there is a problem with the dates format.
As I haven’t found a way to overcome this obstacle, any suggestion from the PowerShell gurus of the forum (like my good friend Shawn @Brink, for instance), is welcome.

 

Excel 2016(Macro enabled) crashes on closing for the first instance?

Hi,

I am trying to launch an excel which have macros enabled. Below are the steps to show where I am facing this issue.

Using c++ code I am launching excel, Once the excel is opened, got a pop up "to enable macro's or disable macro's". I clicked on Enable macro and then a child excel window is opened where I could see my data been written. Now I closed child excel, as per
my understanding the parent also should get closed,but it is not getting closed and now if I click on [X] button of the excel it asks for "Save" "Don't Save" & "Cancel". If click on "Don't save" it is simply crashing and restarting the excel and after restart
of the excel if I close then it is not crashing.

When I see the event log I found this error:

Faulting application name: EXCEL.EXE, version: 16.0.4480.1000, time stamp: 0x5847b92e

Faulting module name: ntdll.dll, version: 10.0.10240.17184, time stamp: 0x580ee54f

Exception code: 0xc0000374

Fault offset: 0x000d62ac

Faulting process id: 0x2064

Could anyone please help me in resolving this issue.

Regards

***Post moved by the moderator to the appropriate forum category.***