User Guide

231
Working with Ou
tput
pivot tables in RTF format, which pastes the pivot table as a table. For spreadsheet
applications, Paste will paste pivot tables in BIFF format. Charts are pasted as
metafiles.
Paste Special. Results are copied to the clipboard in multiple formats. Paste Special
allows you to select the format that you want from the list of formats available to
the target a
pplication.
Embedding a Table i n Another Application
You can embed pivot tables and interactive charts in other applications in ActiveX
format. An
embedded object can be activated in place by double-clicking and can
then be edited and pivoted as if in the Viewer.
If you have applications that support ActiveX objects:
E Run the file objs-on.bat, located in the directory in which SPSS is installed.
(Double-click the file to run it.)
This turn
s on ActiveX embedding for pivot tables. The file objs-off.bat turns ActiveX
embedding off.
To embed a pivot table or interactive chart in another application:
E In the Viewer, copy the table.
E From the menus in the target application, choose:
Edit
Paste Special...
E
From the list select SPSS Pivot Table Object or SPSS Graphics Control Object.
The targe
t application must support ActiveX objects. See the application’s
documentation for information on ActiveX support. Some applications that do not
support ActiveX may initially accept ActiveX pivot tables but may then exhibit
unstabl
e behavior. Do not rely on embedded objects until you have tested the
application’s stability with embedded ActiveX objects.