09-17-2010 11:39 PM
I've been using the opportunty export feature and noticed some changes in ACT 2011, that I can't figure out, so I'm hoping someone can point me in the right direction on how to resolve the problems that I'm having.
If it helps, I'm using the demo database, word and excel 2010
In ACT 2010 when opportunities were exported to Excel, on the pivot table tab in the Excel workbook, the Data field has a drop-down list in Excel, now this field does not have a drop down list.
On the pivot chart tab, there was a Sum of Weighted total field, which was a calculation. Now, this field is not there.
I'm wondering why this functionality was removed from the export process and if there is a way to put it back?
11-09-2010 08:38 AM
I'm debating whether to upgrade to 2011 based partially on the response to this question. Since Act! doesn't have a commission report function, I have to export Opportunities, when "won," to create a commission report in Excel.
Right now, because of the ridiculous oversight of not making Act! 2010 compatible with Office 2010, my Office upgrade broke the exporting to Excel function (as well as others). It appears that my only choice now is to upgrade Act! or switch to another CRM.
Can someone chime in here to address whether the Opportunity export function will do what we are asking?
11-09-2010 09:21 AM
It should be possible to create a commission report with the ACT! reports. It doesn't sounld like a very complex report.