Opening of Excel Files in one Excel Application

[maeyks]

Hello,

I recently had a difficulty in creating links of formulas from one excel file to another. For example vlookup. When I use the started using the formula it does not connect the second file.

After searching online, I should have opened the excel files using the CTRL+O and not just browsing to the file explorer and opening the second excel file.

This is rather new to me. Is there a way to fix this? That the excel file I open, whether via file explorer or CTRL+O function will enable me to use formulas and/or links right away?

Advance thank you to those who will answer.


Michael

 

[JLGWhiz]

Probably an understanding of how Excel operates would help. No matter how you open the first file, once it is open, if you are going to manually open more files, then use the 'File' tab on the ribbon to bring up the menu options and select 'Open' from that menu then use the options displayed to get to your files. That way, you stay in the same instance of Excel.