(Updated, please see new info in replies) I export reports to Excel (built in feature of my accounting program). Until today I have not had an issue using macros store in my personal macro workbook. After an hour of tinkering, I've discovered that if I export the file to Excel (thus opening Excel), the macros are not available. Clicking on Macros only shows this.
But if I open Excel first, and open a blank document, then export the report, the macros show up. This has not happened in the past. Any thoughts?
Update to add:
Even though the macro doesn't appear as an option in the Macros dialog box, I tried using the shortcut I had made for it from the ribbon. Then I got this message, and choosing "Enable" then allowed me to run the macro.
But for the life of me, I can't find what it is actually changing when I do this. The options here under Advanced look the same before and after. I tried every suggestion I could find on Google to enable automatic update of links, but nothing worked, apart from using the dialogue box above.
What I find curious is, if I export to Excel directly from my program, this is what happens. But if export as an excel doc to save to my computer (or as an email attachment), and then open it, the macro works fine. I have this work around now, but it drives me crazy not knowing why.