09-26-2008 08:53 AM - edited 09-26-2008 08:54 AM
Hi folks, first my apologies if this is a repost but it is driving me nuts. I get the above error when trying to export opportunities to excel. Exporting contacts works fine. This error is not database dependant as it gives the same error on the trial database installed with ACT. I am on v 10.0.3 using Vista and office 2007. I seem to recall it worked recently and I have no idea what I have done to change things. I use a synched database and I tried turning off duplicate checking on the master database which has no effect.
Any advice would make laptop violence less likely over the coming weeks.
Thanks
Stu
03-04-2016 03:25 AM
I've found a resolved defect listed in the update notes for Act v17 that reads:
103715 - Exporting opportunity list to Microsoft Excel without the Weighted Total and Total column fails with error "Value cannot be null. Parameter name: sumColumnFields"
What version of Act are you running?
Do you have the Weighted Total and Total columns in your export?
09-29-2008 11:06 AM
Try running Office Diagnostics.
10-28-2008 08:07 AM
Hi there and thanks for the advice. However this did not solve the problem and I am still getting the same error when I try to export my opportunities list to excel. Any other ideas?
Thanks
11-14-2008 07:46 PM
HI there,
I had the same problem and accidently found an easy fix: Just click 'No" when the warning message asks whether you want to create a Pivot table. Voila!
Anne
04-05-2009 09:42 AM
You are a genius Anne!! I've been racking my brain with this for a couple days. Thanks
Chris
03-03-2016 05:51 PM
I too am having this problem. And the above (choosing NO) is not working. Is anyone still having this problem.
Our ACT is setup on a server and I would have thought all the settings would be the same for everyone on the server but others don't have this issue when exporting. I am authorised to export to excel like others.
HELP would be much appreciated as this is most frustrating!
Thanks in advance,
Brooke
03-04-2016 03:25 AM
I've found a resolved defect listed in the update notes for Act v17 that reads:
103715 - Exporting opportunity list to Microsoft Excel without the Weighted Total and Total column fails with error "Value cannot be null. Parameter name: sumColumnFields"
What version of Act are you running?
Do you have the Weighted Total and Total columns in your export?
03-07-2016 04:19 PM
Thank, Gary W. It looks like we're on version 16. Will have to upgrade I think. It's odd all in the office are using the same version and have no probs exporting. Will check the columns.
03-07-2016 06:45 PM
Adding the columns worked!
Thanks Gary
03-08-2016 01:54 AM