Cannot generate BOM

Have you got Microsoft Office (32-bit) installed on the new computer? Is it possible you had it on your old computer but not on the new one?

Yes, I have office365 32-bit installed on the new computer. I had the same version on the old computer.

Perhaps it can be related to excel?

If CS was installed before Office then I would suggest uninstalling and then reinstalling CS. If Office was installed first then might be worth trying to run the repair function.

1. Open up the Control Panel on your PC (and show All Control Panel items, if necessary) and click on Programs, then Programs and Features.
2. Find Microsoft Office 2016 in the list and highlight it.(Selection also say Microsoft Office 365)
3. Click Change.
4. Select Quick Repair and Repair then follow the prompts.

Thanks for the suggestion.

I have tried uninstalling CS several times. I also tried installing CS1.5 but I have not yet received the license key so i could not try to create the BOM.

I changed back to CS 1.4 but the problem remains.

I just tried to repair the office installation but it did not solve the problem.

Is it definitely the 32-bit version of Office?

Hi Peter,

Yes, I just double checked word and excel. It is the 32-bit version.

I have now installed CS1.5.1 and created a trial account. Still have the same problem

Not sure what else to suggest for now. As a quick workaround you can try generating the BOM in a different format (csv?) and not using a template - hopefully this should avoid needing Excel.

Hi Peter,

problem is I cannot export to any format. I get the error message shown in the first post immediately when i press the configure button.

I also get the same message when i press generate.

This is becoming a big problem as I have now spent several days trying to fix this issue and I have several boards where i need to send out the BOM.

Any idea on how to get in touch with altium directly to solve this?

Hi Mats. I will ask someone from Altium to make contact. It may help if you could update your post because what I presume would be a picture of the error message is not included or does not show. Knowing more details of the error would be helpful.

Thank you,

you cannot see the screenshot in the original post?

What about now?

Thank you,

you cannot see the screenshot in the original post?

What about now?

Thanks for the screenshot.

Over the weekend I got chance to try CS on a brand new installation of Win 10 Pro 64-bit (an ISO for October update from memory) that did not have MS Office installed (no office suite of any type). I was able to export a CSV BOM, in my testing I actually did this from the BOM Configure and then Export option.

Hi Peter,

I have now tried uninstalling office365 and this "solves" the problem. I do no longer get the error message and is able to export the BOM in .CSV or .TXT

When i reinstall office365 32-bit or 64-bit the problem comes back.

So this is not a fix since i need to have office and CS installed all the time but at least I know CS seems to have a problem with Office for some reason.

Any ideas on what could fix it?

Very interesting finding regarding office365. I will try and reproduce tonight on the clean Win 10 install I have. Is anyone out there successfully running offiec365 with CircuitStudio?

I hope you are able to re-create this problem and find a solution.

All my colleagues are running CS on win7 x64 so i cannot test it on any other machine here. Thanks

Finished testing and I'm sorry to say it seems to work perfectly. Generated an Excel BOM using BOM Simple.XLT template from example project PCI Express 4 Port Serial Interface. Installation order was CS followed by Office.

• CircuitStudio 1.5.1 (Build 13)
• Windows 10 Pro 64-bit, Version 1809, OS build 17763.107
• Excel for Office 365 MSO (16.0.11231.20164) 32-bit

A couple of suggestions:

• Delete (or move to another folder) your own OutJob file and then try configuring and generating BOM again
• Try using the example project as I did above

After investigating further I started uninstalling one program at a time until I got it working.

It turns out it was kutools addon for excel that was the cause of this problem (at least i think so)

Now Bom generation works again. Thanks for the time invested in this case.