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

Excel / Sql Server / Pivot Tables 2
Failed to save table attributes of (null) into (null). 2
Changing ODBC datasource for a Pivot Table 2
how to avoid login prompt for Linked Tables thru DSN entry? 1
How to skip deleted records linking table 2
How to change pivot table source database? 1
DSN auto update? 6
Setting external data location for a pivot table 1

Top