Microsoft FAQ » Applications » Microsoft Office » Excel » How do I remove a query from a workbook?

How do I remove a query from a workbook?
I have a copy of a workbook that contains a query which automatically refreshes every minute based on a .csv file that is stored on another PC.  When I open the workbook, I am prompted whether I want to enable or disable the automatic refresh.  I cannot enable the refresh because the external data source is on another PC.  Is there a way to remove the query from the workbook so I do not get the refresh prompt every time I open the workbook?  

Solution: How do I remove a query from a workbook?

You can delete the data in the workbook that the query populates. This will also delete the query from the workbook.

If you require the data then you can do a copy and pastespecial(value only) of the data to another sheet. Then delete the main data which the delete the query also and then again copy back the data copied.

Let me know.
Bookmark and Share
Problem: Exchange Migration from SBS 2003 to Exchange 2007   Problem: On Timer Stoppage & Macro Error Handling  
outlook 2000 "TCP/IP connection was unexpectedly terminated by your mail server.  If this problem persists, contact your LAN   Windows Server 2003 Scheduled Tasks Not Running in Background  
email notification when disk space is running low   Active Directory failed to construct a mutual authentication service principal name (SPN) for the domain controller.  
AccessVB:Set Focus on currently selected record   Problem: What's the best design of DNS in AD-Intergrated zone?  
How to insert automatic, sequential numbering on an excel template   Making a chart see a #DIV/0! error as an empty cell  
How can I stop MS Excel from calculating cells.   Pass Through Query Repeatedly Prompting for ODBC Connection information  
Maintenance overlap for database   Problem: Exporting report to .pdf format  
Problem: How can I have a macro execute automatically when data is scanned into a cell?   Problem: Set default line weight, font, etc. in Microsoft PowerPoint 2007  
Modify find/replace dialog box settings   What is the Best Way to Setup Microsoft Access Record Navigation?  
stsadm   Outer join in access