Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Distribute pivot tables (Read 1925 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Distribute pivot tables
01.11.08 at 15:40:42
 
Distribute pivot tables
 
Quote:
If I want to distribute pivot tables of the data in the SQL*XL enabled spreadsheet in aseparate workbook, will it be necessary to have a license for all those that will be viewing the pivot tables?

 
Viewing pivot tables without having SQL*XL installed will work fine. You just cannot refresh the data.  
 
SQL*XL can be used to attach the query results to a pivot table in Excel. You need a database connection to attach the data to the pivot table but after that the pivot table works without the database connection. This means you can save the spreadsheet with the pivot table and work with the data again at a later time without having to reconnect to the database. Even SQL*XL is not necessary anymore so you can use the pivot table on any PC. Just when you want to refresh the data you need to reconnect to the database and use SQL*XL to get the new data.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1