| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Connection String - How to hide it?
Hi
We have several pivot table reports (Excel 97) that we distribute to our users. The reports connect to an SQL Server 2000 database. Some of the reports use trusted connection (windows) and others use non-trusted (SQL login). These reports can easily be opened using VBA or in Excel 2007 to view the connection string (settings). How can we protect or hide these settings? (especially the username and password). Any help would be appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative path in database query connection string | Excel Discussion (Misc queries) | |||
| I want to hide data that's less than 1 in a pivot table | Excel Discussion (Misc queries) | |||
| Hide Pivot Table Filters | Excel Discussion (Misc queries) | |||
| How do I use a connection string? | Excel Discussion (Misc queries) | |||
| Copy pivot table and get rid of connection | Excel Discussion (Misc queries) | |||
Threaded Mode
