Toad World® Forums

Excel 2010 pivot grid resetting field to SUM when updating worksheet with automation script in Toad for Data Analysts


#1

I have an automation script updating an excel 2013 worksheet that is used by the other worksheets for pivot grids. All pivot tables with fields set to ‘count’ are changing to ‘sum’ when data is updated. The fields are text fields so if anything they should be automatically being set to count with Excel functionality…but something is occuring when the automation script writes to the workbook. I have even tried using a macro to clear the worksheet I am writing to only and not overwriting in the script in attemp to save the format of the rest of the pivot worksheets - but that doesn’t resolve the issue.

I am using Toad for Data Analysts 3.1.0.638.

Has anyone seen this issue?