When pivot table is selected as
target for the fetched results the data will be attached to a pivot table in
Excel. SQL*XL will create a new pivot table and attach the resultset. When a
pivot table already exists (query refresh) SQL*XL will keep the pivot table with all the settings you may have set and just replaces the query results.
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.