software

This has never been a problem for me, but have recently changed jobs,
and now I'm having a problem.

I have 2 sales reps, each with their own 'status spreadsheet' (FileA amp;
FileB); these files remain open most of the day. I also have a 3rd
sheet (Summary) which uses different formulas (COUNTIF, VLOOKUP, etc)
that reference FileA amp; FileB to provide instant feedback on their
progress (of couse, only as of the last save).

When I open my summary sheet, all cells referencing the other 2
spreadsheets show as quot;#N/Aquot;. The values only populate if I open the
other 2 spreadsheets, and then everything's fine. I want to open only
my summary sheet, so I don't lock out my reps from updating theirs
while I review metrics.

All 3 spreadsheets live in the same subdirectory, and I have full
rights to that subdirectory.

Updating the 'Links' does no good, links box shows as quot;OKquot;.

I'm stuck.--
goto_guy
------------------------------------------------------------------------
goto_guy's Profile: www.excelforum.com/member.php...oamp;userid=30557
View this thread: www.excelforum.com/showthread...hreadid=502083There are some functions that don't work with closed workbooks--=sumif(),
=countif(), =indirect() are a few. But =vlookup() should not cause any trouble.

And there are replacements (array formulas =sum(if()) or =sumproduct()) that can
be used in place of the first two.
goto_guy wrote:
gt;
gt; This has never been a problem for me, but have recently changed jobs,
gt; and now I'm having a problem.
gt;
gt; I have 2 sales reps, each with their own 'status spreadsheet' (FileA amp;
gt; FileB); these files remain open most of the day. I also have a 3rd
gt; sheet (Summary) which uses different formulas (COUNTIF, VLOOKUP, etc)
gt; that reference FileA amp; FileB to provide instant feedback on their
gt; progress (of couse, only as of the last save).
gt;
gt; When I open my summary sheet, all cells referencing the other 2
gt; spreadsheets show as quot;#N/Aquot;. The values only populate if I open the
gt; other 2 spreadsheets, and then everything's fine. I want to open only
gt; my summary sheet, so I don't lock out my reps from updating theirs
gt; while I review metrics.
gt;
gt; All 3 spreadsheets live in the same subdirectory, and I have full
gt; rights to that subdirectory.
gt;
gt; Updating the 'Links' does no good, links box shows as quot;OKquot;.
gt;
gt; I'm stuck.
gt;
gt; --
gt; goto_guy
gt; ------------------------------------------------------------------------
gt; goto_guy's Profile: www.excelforum.com/member.php...oamp;userid=30557
gt; View this thread: www.excelforum.com/showthread...hreadid=502083

--

Dave Peterson