Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
References to external XLS files
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 & 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 & 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 "#N/A". 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 "OK". I'm stuck. -- goto_guy ------------------------------------------------------------------------ goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557 View this thread: http://www.excelforum.com/showthread...hreadid=502083 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
References to external XLS files
There 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: 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 & 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 & 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 "#N/A". 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 "OK". I'm stuck. -- goto_guy ------------------------------------------------------------------------ goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557 View this thread: http://www.excelforum.com/showthread...hreadid=502083 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting sheets into existing workbooks w/o external references | Excel Worksheet Functions | |||
Repost:Problems with external references | Excel Discussion (Misc queries) | |||
Excel 2003: Temporarily "turning off" links to external files... | Excel Discussion (Misc queries) | |||
External data references in EXCEL 2002 | Excel Discussion (Misc queries) | |||
External References | Excel Discussion (Misc queries) |