I have 2 excel spreadsheets in one fex. Tabling the same file but one is just an excel spreadshet and the other is an excel spreadsheet with a pivot table of the same data that I'm tabling for the 1st excel spreadsheet. I've used the open option on the first excel speadsheet with sytlesheet and used pivot close for the 2nd spreadsheet with stylesheet. I received an error about do not use a noprint instead use cashefields. I do not have a noprint in the 2nd excel report but do have the cachefields in the 2nd excel spreadsheet.

Is excel the source or the result of you program?

Can you post your code?

TABLE FILE CAR
PRINT
field1 field2 field3 field4
BY field6 NOPRINT
BY HIGHEST field7 NOPRINT
ON TABLE SET STYLE *
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=DATA,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N1,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N2,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N3,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N4,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N5,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N6,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N7,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N8,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N9,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N10,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N11,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N12,
SIZE=8,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N1,
SIZE=8,
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N2,
SIZE=8,
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N3,
SIZE=8,
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N4,
SIZE=8,
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N5,
SIZE=8,
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N6,
SIZE=8,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N7,
SIZE=8,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N8,
SIZE=8,
STYLE=BOLD,
JUSTIFY=CENTER,

$
TYPE=TITLE,
COLUMN=N9,
SIZE=8,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N10,
SIZE=8,
STYLE=BOLD,
JUSTIFY=CENTER,

$
TYPE=TITLE,
COLUMN=N11,
SIZE=8,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N12,
SIZE=8,
STYLE=BOLD,
JUSTIFY=CENTER,

$
TYPE=TITLE,
COLUMN=N13,
SIZE=8,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=REPORT,
COLUMN=N1,
-* WRAP=1.013,
-* WRAP=1.785,

$
TYPE=REPORT,
COLUMN=N2,
-* SQUEEZE=0.50,
SQUEEZE=.75,
RIGHTGAP=0.05,
LEFTGAP=0.05,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=0.75,
-* SQUEEZE=.50,
RIGHTGAP=0.02,
LEFTGAP=0.02,
$
TYPE=REPORT,
COLUMN=N4,
SQUEEZE=.75,
RIGHTGAP=0.02,
LEFTGAP=0.02,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=2.00,
RIGHTGAP=0.02,
LEFTGAP=0.02,
$
TYPE=REPORT,
COLUMN=N6,
SQUEEZE=.80,
RIGHTGAP=0.02,
LEFTGAP=0.02,
$
TYPE=REPORT,
COLUMN=N7,
SQUEEZE=1.35,
RIGHTGAP=0.02,
LEFTGAP=0.02,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=1.30,
RIGHTGAP=0.02,
LEFTGAP=0.02,
$
TYPE=REPORT,
COLUMN=N9,
SQUEEZE=1.35,
RIGHTGAP=0.02,
LEFTGAP=0.02,
$
TYPE=REPORT,
COLUMN=N10,
SQUEEZE=1.35,
RIGHTGAP=0.02,
LEFTGAP=0.02,
$
TYPE=REPORT,
COLUMN=N11,
SQUEEZE=1.30,
RIGHTGAP=0.02,
LEFTGAP=0.02,
$
TYPE=REPORT,
COLUMN=N12,
SQUEEZE=1.35,
RIGHTGAP=0.02,
LEFTGAP=0.02,
$
TYPE=REPORT,
COLUMN=N13,
SQUEEZE=1.35,
RIGHTGAP=0.02,
LEFTGAP=0.02,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
SIZE=8,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=4,
SIZE=8,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=5,
SIZE=8,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=6,
SIZE=8,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=7,
SIZE=8,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
$
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K OPEN
END
-RUN
DEFINE FILE Car
CNTR/I9= 1;
COUNTER/I9= (CNTR +1);
END
TABLE FILE car
PRINT
COUNTER
BY Field2 AS ''
ON TABLE COLUMN-TOTAL AS 'Total'
ON TABLE PCHOLD FORMAT EXL2K CLOSE PIVOT
PAGEFIELDS field2 field3
CACHEFIELDS field 6 field7 field8 field9
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Legal',
LEFTMARGIN=0.055556,
RIGHTMARGIN=0.055556,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.055556,
LEFTGAP=0.055556,
$
TYPE=REPORT,
TITLETEXT='Navigation',
$
TYPE=DATA,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
$
TYPE=TITLE,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
COLOR='BLACK',
BACKCOLOR=RGB(205 238 162),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N1,
JUSTIFY=LEFT,
$
TYPE=SUBHEAD,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=SUBFOOT,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=SUBFOOT,
BY=2,
BACKCOLOR=RGB(242 251 230),
$
TYPE=GRANDTOTAL,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=HEAVY,
BACKCOLOR=RGB(205 238 162),
STYLE=BOLD,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
IMAGE=logonbhfooter.gif,
POSITION=(0.166667 0.166667),
SIZE=(1.416667 0.625000),
$
TYPE=REPORT,
COLUMN=N3,
WRAP=1.250000,
$
TYPE=REPORT,
COLUMN=N4,
SQUEEZE=0.541667,
$
TYPE=REPORT,
COLUMN=N5,
WRAP=0.555556,
$
TYPE=REPORT,
COLUMN=N6,
WRAP=1.430556,
$
TYPE=REPORT,
COLUMN=N11,
WRAP=1.500000,
$
TYPE=REPORT,
COLUMN=N12,
WRAP=0.500000,
$
TYPE=REPORT,
COLUMN=N13,
WRAP=1.791667,
$
TYPE=REPORT,
COLUMN=N14,
SQUEEZE=0.388889,
$
ENDSTYLE
END

I'm not able to test this at this moment.
Maybe someone can.
But if you split this application into two, do they but run without any problem?

If I put them in 2 different fex, they run fine. I need them to run as one.