Account Schedule > Navigate > Overview > Actions > Excel > Export Excel > Update Existing Document
Up until this past update, we were able to export an Account Schedule to an existing Macro-Enabled Excel file. The reason for this was, so we could run the macro to format the exported report the way management would like to see it. This has not been a problem since we set up these .xlxm "template" files, until a couple days ago it was reported that this was no longer working.
I did some trouble shooting, and we can still run this same process if we "Update Existing Document" and that document is a .xlxs file, but not a .xlxm. The only thing that struck me was that I received an email notifying me of the new BC update pushed a couple days ago and thought, could this be the reason?
When you run this process using our .xlxm file, it seems to work, until you try to open the file at which point your get an error message:"Excel cannot open the file 'name.xlxs' because the file format or file extension is not valid.Verify that the file has not been corrupted and that the file extension matches the format of the file."
