Are you automating this as shown in this video? I have note tested this with Excel 2013 but there shouldn’t be any issues.
From: christy.mesenburg_406 [mailto:firstname.lastname@example.org]
Sent: Monday, June 10, 2013 8:48 AM
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 188.8.131.528.
Has anyone seen this issue?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from General notifications altogether.
Toad Data Point - Discussion Forum
this post as spam/abuse.