Ugh. This is my week for SMI issues. Have a client with 3 separate templates. We have the report distribution set to File Publish and the 'Convert to Static' checkbox is checked. Each report uses a unique distribution setting because of the file naming. Two of the templates work correctly when distributed - the values in the generated spreadsheet are static. The third publishes with the Report Designer-Addin formulas in it. I've tried recreating the instructions, turning off/on the static checkbox, created a copy of the template, exported it and imported it on my system, verified the workbook wasn't protected and nothing makes it work properly. Besides recreating the report (which I'm trying to avoid because it is pretty involved) does anyone have any other ideas?!? I did check the SMI community and found a post about this same issue but the person didn't get it working and just added macros to the template to switch the formulas to static values. I'd rather not do that. Thanks!