| Info | ||||
|---|---|---|---|---|
If you are reading this page, then most likely you have run into a problem opening Projector reports with Microsoft Excel. Reports may just not work, you may not be able to make any edits, or you may just be really annoyed that you need to click through a bunch of security warnings every_single_time_you_open_a_report. This page will show you how to get your reports working with Excel and get rid of these annoyances. This page is specifically written to cover Excel 2013. If you are using a different version of Excel, then look in your left hand navigation area and find the appropriate help page. Most Projector reports require Excel to run macros in order to format the data. However, Excel does not run macros by default. As such, your reports either won't show data, or you'll need to click on an Enable Content button every time you open a Projector report. You can add Projector as a Trusted Publisher so that all reports delivered from us will run Macros automatically. This page shows you how to do just that. In addition, Excel blocks external data connections by default. The best way to manage this is to add Projector's default report save locations as trusted locations on your computer.
|
Trusted Publishers
The first step out of Excel security message mayhem is to add Projector as a trusted publisher. To do so, open up any Projector report. You should see a message reading - Some active content has been disabled. Click for more details. Enable Content.
...