Excel reports with Macros in Books
I have several excel reports that use macros for sorting the data rows. The macros work when I am in excel and run after I refresh OneStream, however, when running the report in a book and generating...
Forum Discussion
From my experience, the speed with which Books are created indicate that the output is created directly and not actually rendered. By that I mean the output (PDF or Excel) is written directly to the file using the relevant API without loading the viewing software. And that means that Excel is not loaded to execute the sorting macros. I can't think of a way around that. And I might be wrong.