EVSND within Book Publication reports?
We are still on OutlookSoft version 4.2 SP2, although we will be upgrading to v7M this summer.
Has anyone had any success using EVSND functions to return values through Book Publication Wizard? For example, if I wanted a Book Publication book to reference an input template, should I be able to get this to work in theory? I've tried and have been unsuccessful. It appears that the Book Publication Wizard opens the report and does a ReCalc but not a Refresh, which is what the EVSND formulas need to populate the spreadsheet with values.
As a workaround, I've attempted to alter the workbook options to "Expand On Workbook Open", but for some reason this does not work when the Book Pub wizard is running. I've also tried executing a refresh on the Workbook_Open event, but this doesn't work either when Book Pub is running. Does Book Pub suppress custom macros and workbook options? How do I work around this?