+ Reply to Thread
Results 1 to 2 of 2

Data Query

  1. #1
    Gary B
    Guest

    Data Query

    Hi there,

    I have an excel file with multiple sheets. When I open the file, a prompt
    is displayed asking whether to enable or disable refresh of query. As there
    should be no queries in this workbook, I would like to locate the query, and
    delete it. Any ideas ?

    I know I could simply re-create the workbook, but i dont want to do this.

  2. #2
    Forum Contributor
    Join Date
    12-02-2004
    Location
    London
    Posts
    255
    Look for a named range in each of the spreadsheet pages which begins Query....

    If you delete this named range, this should disable the refresh data message

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1