Toad World® Forums

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


#1

I did a quick test using Excel 2010 and TDP 3.3 have ho problems.

Debbie

From: christy.mesenburg_406 [mailto:bounce-christymesenburg_406@toadworld.com]

Sent: Monday, June 10, 2013 8:48 AM

To: toaddatapoint@toadworld.com

Subject: [Toad Data Point - Discussion Forum] Excel 2013 pivot grid resetting field to SUM when updating worksheet with automation script in Toad for Data Analysts

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?


To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from General
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.