Hi all - I’ve done some searching and cannot seem to find anyone w/ the same issue.
Here is what I am trying to do…
I have a very basic query set to export a block of data into the ‘DATA’ tab of my excel file. The file has a second worksheet called ‘REPORT’ which contains PivotTables and Charts that automatically refresh based on the contents of the ‘DATA’ tab.
The problem is that when the charts are present, I can no longer run the script to export to the data tab of my sheet. I instead get this error:
File_1 - Value cannot be less -90 and greater than 90
Parameter name: value
The curious thing is that if i delete the charts, but leave the pivottables, i am able to export successfully. Anyone else have this issue? Is it not possible to have these PivotCharts update automatically based on the underlying data?