Export opportunities to excel error - Value cannot be null Parameter name: sumColumnFields [ Edited ]

[stravers]

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

Message Edited by stravers on 09-26-2008 08:54 AM

[Gary W · Accepted solution]

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?

[dlunceford]

Try running Office Diagnostics.

Office 2007:
1. Exit all running applications and launch Outlook.
2. Click the Help menu, and then click Office Diagnostics. The Microsoft Office Diagnostics dialog box appears:
   Note: Your screen may differ from the screenshot below.
   
   
3. If you have completed a diagnostics previously, then select Run Diagnostics Again, otherwise select Continue. The Start Diagnostics dialog box appears:
   
   
4. Click Run Diagnostics to begin the diagnostics process. Once the diagnostics has completed, you will be presented with a summary dialog box appears:
   Note: Your screen may differ from the screenshot below.
   
   
5. Complete the Microsoft Office Diagnostics wizard as instructed.

[stravers]

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

[virginiarose]

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

[mdiPartners]

You are a genius Anne!! I've been racking my brain with this for a couple days. Thanks

Chris

[bdalton]

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

[Gary W · Accepted solution]

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?

[bdalton]

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.

[bdalton]

Adding the columns worked!

Thanks Gary

[Gary W]

No problem!
Glad to hear this workaround worked for you.