Microsoft
Policy
Questions and answers to issues related to Microsoft: Windows, Applications, Development, Hardware, Server, Internet Protocols, Database, Exchange .
»
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?
internet advertising
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.
Popular Tags
Tags:
2000
2003
2007
cell
cells
chart
convert
copy
excel
Excel 2003
Excel 2007
Excel VBA
file
formula
macro
Microsoft
Microsoft Excel
Microsoft Excel 2003
Microsoft Excel 2007
ms Excel
Office
pivot
range
sheet
vb
vba
vlookup
workbook
worksheet
Browse All Tags