anyone had problems w/vlookup & network files?
Posted by Daniel P. on November 16, 2001 10:15 AM
I've setup a vlookup formula in a network file (named "master") that references another network file (named "values"). When "master" is opened and I select to update, excel freezes every time. It does not freeze however if I have "values" open.
I think I've ruled out it being a problem within the "master" spreadsheet. I saved "master" to my hard-drive and had the same problem. If both files are on my hard-drive and formulas changed, the "master" file WILL update whether the "value" file is open or not.
Any ideas on what's going on? Can I lookup information from a file on a network without opening it first?