View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carl[_8_] Carl[_8_] is offline
external usenet poster
 
Posts: 5
Default Breaking the External Data Link

I create reports using an SQL to external data. The report then copies
particular data to division tabs and saves as a separate file. The trouble
is when we open the new spreadsheet there is a link to that External data
and if someone tries to refresh the data, they see my datasource and login.
How do I get rid of the Link to the external data source on the copied
pages?

TIA
Candyman