+ Reply to Thread
Results 1 to 2 of 2

Excel 2003 is becoming non responsive unless linked file is open.

  1. #1
    Registered User
    Join Date
    10-11-2010
    Location
    US
    MS-Off Ver
    NA
    Posts
    41

    Excel 2003 is becoming non responsive unless linked file is open.

    I am using sumif (internally) with sumproducts and vlookups (externally).

    If I open the linked file first, they the primary file opens without a any problems.

  2. #2
    Valued Forum Contributor ron2k_1's Avatar
    Join Date
    09-30-2009
    Location
    Not the USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    606

    Re: Excel 2003 is becoming non responsive unless linked file is open.

    Quote Originally Posted by ggremel View Post
    I am using sumif (internally) with sumproducts and vlookups (externally).

    If I open the linked file first, they the primary file opens without a any problems.
    Sumif, countif, indirect wouldn't work when linking to closed external links. Use sumproduct only.
    Ron
    Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad

    Kindly

    [1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
    [2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
    [3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated

+ 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