Hi -
In your worksheet - go to the Edit Menu - then select 'Links' way at the
bottom and go from there.

"Dinesh" wrote:

Hi,

Please guide me how to remove an external data source link in pivot as i
need to make a new link (I am using excel 2007)

Thanks
Dinesh