+ Reply to Thread
Results 1 to 2 of 2

Damn excel dialog box keeps popping up?

  1. #1
    Forum Contributor
    Join Date
    04-26-2013
    Location
    Orlando
    MS-Off Ver
    Excel 2016
    Posts
    191

    Damn excel dialog box keeps popping up?

    I have no external data sources and yet any time i try to change the sheet reference it pops up the open file dialog box, how can i resolve this? Below is one of the formulas i am trying to edit, all i want to do is remove the word cost from the reference and it wont let me.

    =SUMIFS('In House Cost data MA Snapshot'!$I:$I,'In House Data MA Snapshot 2'!$F:$F,"007 Driver Imp D&R",'In House Data MA Snapshot 2'!$A:$A,">="&$C$9,'In House Data MA Snapshot 2'!$A:$A,"<="&$D$9)*1.15

    Already checked the data tab edit links but its grayed out so no external links...

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Damn excel dialog box keeps popping up?

    That typically happens when Excel can't find the sheet name.

    You said you're wanting to remove the word "cost" from the sheet name. After you do that and if the newly referenced sheet doesn't exist then you get the popup.

    Try renaming the sheet first (rename the sheet tab, not the formula). The formula should automatically adjust to the new sheet name.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Custom *and* Original SaveAs Dialog Box Popping Up
    By sioneld in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2014, 02:19 AM
  2. [SOLVED] How do I stop a warning dialog box from popping up, using VBA
    By woodbridge1965 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-27-2013, 12:41 PM
  3. Replies: 2
    Last Post: 11-19-2012, 05:59 AM
  4. Replies: 0
    Last Post: 02-18-2009, 11:37 PM
  5. Replies: 2
    Last Post: 08-03-2006, 09:02 AM
  6. Replies: 1
    Last Post: 09-15-2005, 02:05 AM
  7. Procedure too large" error ...DAMN
    By -[::::Shamran::::]- in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-05-2005, 06: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