Closed Thread
Results 1 to 3 of 3

Excel is auto-opening iqy file on open

  1. #1
    Registered User
    Join Date
    11-27-2017
    Location
    Utah
    MS-Off Ver
    2013
    Posts
    8

    Excel is auto-opening iqy file on open

    As the title says, every time I open Excel, whether to open a blank workbook or an existing workbook, excel also opens a blank workbook and prompts to enable data connections. If I enable data connections, Excel opens a connection file that I created to a sharepoint site. I've created connection files like this before and never had this problem. It's not really a work stopper, but it is annoying.
    I've tried everything I can find online, which isn't much. Pretty much everything I've found is about how to stop or start opening specific workbooks when Excel opens, but I've checked all those settings and they're all cleared.
    Any ideas?
    Thanks

  2. #2
    Registered User
    Join Date
    11-09-2019
    Location
    Las Vegas, NV
    MS-Off Ver
    Windows 10
    Posts
    1

    Re: Excel is auto-opening iqy file on open

    Did anyone get back to you about this or did you figure it out? I'm using iqy's to link to SharePoint for Quality Assurance and analysis. Worked great since 2019. Made a new one and now every time I open Excel in any way I get 3 iqy's asking to be enabled. I use some scripts to refresh some Excel
    conversion workbooks, and this is mucking up the works hard.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Excel is auto-opening iqy file on open

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] two windows opening whenever I open an excel file
    By Stebobibo in forum Excel General
    Replies: 4
    Last Post: 02-23-2015, 05:49 PM
  2. Replies: 3
    Last Post: 01-14-2014, 10:57 AM
  3. [SOLVED] how to auto open file when opening another file
    By k1dr0ck in forum Excel General
    Replies: 2
    Last Post: 05-07-2012, 02:51 AM
  4. open workbooks when opening an excel file
    By jprogrammer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2006, 05:25 PM
  5. [SOLVED] when opening an excel file, two files open
    By Brian in forum Excel General
    Replies: 1
    Last Post: 12-13-2005, 03:30 PM
  6. [SOLVED] when opening an excel file, 2 files open (one is book1)?
    By Brian in forum Excel General
    Replies: 1
    Last Post: 12-09-2005, 07:55 PM
  7. Excel opening but file does not open with Application
    By eWisdom in forum Excel General
    Replies: 1
    Last Post: 03-10-2005, 02:06 PM

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