I used to save linked workbooks onto a remote server. One could be opened and it would display the last values it had. Now, the linked formulas show #VALUE error until the linked sources are opened. I'd really like to be able to open just one workbook at a time. Is there some setting in Excel 2007 to change this behavior?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!