Publish To Reports Library not available for Excel Report Publishing

If you are getting the message that - the "Reports Library" is no longer an option, only "SharePoint" and "File when publishing a new Excel Builder Reports, you may want to watch this video. Pat explains how to solve this issue and why it happens. There shouldn't be any differences in this functionality between versions of SmartList Builder and this option isn't a "Setup Option" in Excel Report Builder - instead, the options come from a GP Setup window. If you'd like to read the help article that goes with this video, click here.