I can't save my xlam add-ins

Hey all,

I have multiple personal add-ins (xlam) that I've created and have regularly updated/saved in the past using Microsoft VBA 7.0. I recently got a new computer and now when I make changes to the add-ins and try to save, nothing happens. I click File>Save MyAddin.xlam, and nothing happens, whereas with my old computer it would save the changes I've made. The add-ins are the same ones I've used in the past and none are Read Only. This happens for any add-in I try to save, so it's not a file-specific thing. I get no errors, but no saving either. I've dug through various Google results for an answer, but so far nothing that works. Any ideas?

Thanks,
Steve

Yes, from the VBE menu. And yes, I've checked and the date stamp doesn't change, and when I restart Excel the changes I've made are gone.

Originally Posted by shg

How about ...

o Set the IsAddIn property to False

o SaveAs MyAddIn.xlam from the Excel UI

o Set the IsAddIn property back to True

o Uninstall the add-in

o Close Excel, open Excel, and install the add-in

Then see if things start behaving.

I tried this and it still didn't work. But after some further testing I found out what program is causing the problem, though I'm not aware of an easy solution to the issue. I have Oracle Hyperion Smart View for Office installed, which is an Office add-in. When I disabled the Smart View add-in I was able to save my personal add-ins without a problem. I use Smart View a lot though, so hopefully this issue gets addressed soon on Oracle's end.

I too was having problems with SmartView messing this up. The sad part was, I was writing an XLAM to work with SmartView so disabling it was not an option. I did find that checking the boxes for 'Reduce Excel File Size' and 'Improve Metadata Storage' seemed to allow my XLAM file to start saving again. Hopefully it's not a fluke, and god only knows what kind of shenanigans they are pulling to keep files from saving. But hopefully this helps.