Suppose you created an Excel file with external data, where you connected to your database, entered all the database access information like user, password, database location and son on.

Everything is working great with your real time connected Excel sheet to your database.

 

And now you want to deploy this Excel file to co-workers so they can always access the most recent data by just clicking the Excel built in “Refresh Data” button .

 

But here is one problem: Excel displays all database connection properties when the user clicks on “DATA” > “Connections” and selects the connection definition.

 

You don’t want to show them all your data connection information; do you?

 

SNAGHTML4565424

 

Here is where XLReport kicks in.

One of the great features of XLReport is that it totally encrypts the data connection properties.

SNAGHTML459e067

No you can securely distribute Excel files with Live Real Time data connections created with XLReport.