Pivot Reports conversion to Excel

Laurie Hauer:

I am having problems converting my Pivot Report to Excel.  It basicall doesn't let me.  Can anyone give me advice?  I want to share my results with other staff and this seems to be the only way.  Thanks.

Laurie,

Like Melissa I don't know exactly what problems you're having, but I can tell you what issue I see every time and how I solve it.

Whenever I export a Pivot Report to Excel, it opens in Excel as a blank set of frames with a couple of drop-down arrows.  There's usually a Security Warning at the top of the screen that says Data connections have been disabled.  I click the options button, choose Enable this content, then OK.  Once done, I now click on any of the drop-down arrows in the pivot table, change a selection and change it back again (usually I just uncheck Select All and then recheck it).  When I click OK, my data appears.  This process has worked for me every time.  If you have the same problem, I hope this solves it for you.