When I run the following code, the Excel file goes to open and then I get an error that states:

"Problems During Load

Problems came up in the following areas during load:

PivotTable"



-* Following will display repeating values down column
SET BYDISPLAY=ON
-* Creating the Report
TABLE FILE BART01
PRINT
QUANTITY AS 'QUANTITY'
BY FORMTITLE AS 'FORM TITLE'
BY FORM# AS 'FORM#'
BY YEAR AS 'YEAR'
BY MONTH AS 'MONTH'
BY DAY AS 'DAY'
BY NWIEID AS 'NWIEID'
BY SHIPPING_NAME AS 'SHIPPING_NAME'
BY SHIPPING_CITY AS 'SHIPPING_CITY'
BY SHIPPING_STATE AS 'SHIPPING_STATE'
BY SHIPPING_ZIP AS 'SHIPPING_ZIP'
BY DOWNLOAD_ITEM AS 'DOWNLOAD_ITEM'

-* STYLE
-*HEADING
-*"YTD POWERSPORTS/MOTORCYCLE SUMMARY NATIONWIDE "
-*FOOTING
-*""
ON TABLE SET PAGE-NUM OFF
-* ON TABLE NOTOTAL
-*ON TABLE COLUMN-TOTAL
-*ON TABLE SET COMPOUND BYTOC YEAR-MONTH
ON TABLE PCHOLD FORMAT EXL2K PIVOT
PAGEFIELDS CAMPAIGN
-*CACHEFIELDS CAMPAIGN
-*ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF,$
-* Following names the worksheet
TYPE=REPORT, TITLETEXT = PowerSports,$
-*TYPE=HEADING,HEADALIGN=BODY,$
-* Following formats the heading
-*TYPE=HEADING,LINE=1,OBJECT=TEXT,ITEM=1,JUSTIFY=CENTER,STYLE=BOLD,COLSPAN=3,COLOR=BLACK,$
-*TYPE=TITLE, SIZE = 9, STYLE = BOLD,$
ENDSTYLE
END


This message has been edited. Last edited by: neuro,

Resolved my own issues, one was my local computer had encrypted folders I had to tell it to not do. Next I had to use “SET WEBARCHIVE=ON” for my Caster job.