Hi,

I am having a problem with refreshing a pivot table from a network computer.

I have created a pivot table which uses a DBF table as its data source. I
can update this file and when i run the refresh on my computer it's fine.
However, if someone else tries to refresh the table from a different computer
in the network then it comes up with the following message:

[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

I have added the Active Componants to the computer as i was told that this
was a probably reason for the error.

Can someone please advise me what I'm doing wrong.

Many thanks in advance

Rob

I also would like to know the 'proper' way to do this.

I use the following as a workaround. On the second workstation wher
the pivot table will not refresh, double click on some value to creat
a new worksheet containing the data which makes up that value. Give th
data in this worksheet a named range (sourcedata)

In the pivot table wizard, change the data source to 'microsoft exce
list or database' = 'sourcedata' and set the Option of 'save data wit
table layout' to unticked. (last step may be unnecessary)

Then go back to the wizard and change the data source to 'externa
data' and go through the steps to select the external data source.

Hope this helps.

--
steven100
-----------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...fo&userid=3075
View this thread: http://www.excelforum.com/showthread.php?threadid=51861

Hi Steven,

No I can't seem to get your workaround to work either. Thanks for trying
anyway

Rob

"steven1001" wrote:


I also would like to know the 'proper' way to do this.

I use the following as a workaround. On the second workstation where
the pivot table will not refresh, double click on some value to create
a new worksheet containing the data which makes up that value. Give the
data in this worksheet a named range (sourcedata)

In the pivot table wizard, change the data source to 'microsoft excel
list or database' = 'sourcedata' and set the Option of 'save data with
table layout' to unticked. (last step may be unnecessary)

Then go back to the wizard and change the data source to 'external
data' and go through the steps to select the external data source.

Hope this helps..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=518616