Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Not able to edit seedlist in Excel

SA-11148

Summary



Unable to edit Seedlist instances using "Edit in Excel" an error message is displayed during loading of Excel file.

Error Messages



Session will not be supported by Excel import manager! Error in method: sUpdateTemplateAll. Object variable or With block variable not set


Steps to Reproduce

  1. Open the Marketing Analyst portal and navigate to Pega->Segmentation ->Seedlist .
  2. Perform an edit of any seedlist instance and click the "Edit in Excel" button to start editing using Excel.

Root Cause



The root cause of this problem is defect/misconfiguration in the operating environment. Approximately 150 additional columns were added to the external class mapping,
this increased the total number of columns to around 272. The Excel macro cannot handle more than 245 columns and throws the error.


Resolution



Reduce the total number of columns to less than 245 by removing unused properties.
 
Suggest Edit

Published July 3, 2015 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us