How does pivot table still work after deleting DSN?

A

adolf garlic

How is excel storing connection information?

If it is using an external DSN, how is it I can send the xls to someone who
doesn't have the DSN and it works.

If it is not using a DSN, why is it that the wizard prompts you to choose or
create one?
 
J

Jim Thomlinson

In order to refresh the data you would need the DSN in order to get new info
from the Data Source. But The pivot table will have info in the pivot cache
which the user can manipulate.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Programmatically set UID & PWD in existing ODBC DSN connection string. 1
Excel / Sql Server / Pivot Tables 2
Office 365 Email Encryption One time Passcode 0
Programmatically setting pivot sourcedata 0
Connection files and pivot tables 0
Failed to save table attributes of (null) into (null). 2
Excel and DSNs 0
FileMaker Pro Excel 2004 or 2008 0

Top