We have a sales reporting system set up with ~30 Destination Workbooks that pull all of their data directly from a single Source Workbook - using vlookup formulas (with full path name references to the Source Workbook).

When we open two or more of these Destination Workbooks at a time without opening the Source Workbook or enabling data connections or links all of the vlookup data disappears from all but the most recently opened Destination Workbooks.

The only work-around we have found for this is to open the Destination Workbooks in separate instances of Excel. This method is not practical for our analytical needs.

Is there any different way to have data visible in more than one Destination Workbook in a single instance of Excel that are vlookup-ing from a single Source besides re-structuring the entire setup?

• Moved by Lanlan HuangMicrosoft contingent staff Monday, March 23, 2015 2:02 AM

Hi,

I tested with a simple source Workbook closed from my side, I was able to perform Vlookup from more than 3 destination Workbook without any issues.

To better assisting you on this, I will need some more information:

1.  What is your Excel version, 2013/2010 or others?
2.  How do your Vlookup be used, do you mind sharing me a sample through mail to: ibsofc@microsoft.com
3.  Does this working before? If so, what has been changed?
4.  How do users get access to that source file?
5.  Is there firewall settings on the share location of the source file?

Please update me with above information, so I can check further, thank you.