Opening two excel files lauches the excel application twice and hence VLOOKUP does not wor

[AntonRajiv]

When I open multiple excel files, every file opens by launching the excel application fresh and hence I have multiple excel applicaitons open and when i try to use vloopup, it does not recognize cells from another excel file.

[dilipandey]

Hi Rajiv,

welcome to the forum.
I had encountered these type of issues in Excel 2003.
I believe there is an option to include all excel windows in one single window, some thing like "windows in taskbar " or something.
Also, try giving vlookup syntax references using key combination ctrl + Tab or alt + Tab.


Regards,
DILIPandey
<click on below * if this helps>

[martindwilson]

try
In Options, Advanced, the General section, is "Ignore other applications that use Dynamic Data Exchange (DDE)" checked? If so, uncheck it.

[AntonRajiv]

Thanks for the reply, The option "Ignore other applications that use . . . . ." is uncheked already. anything else that I can try?

[AntonRajiv]

Thanks for the response, I am using excel 2007, could you tell me where I can find the option "Windows in Taskbar" to enable it?

[martindwilson]

see here
for some scripts there is a remove open in new instance file in the zip folder
http://www.online-tech-tips.com/ms-o...007-workbooks/

[elayaz]

Hi,

Can you able to see all the opened excel files list in view-->switch windows?

[Sun13Banjo]

Go to the Office Button, Excel Options and Advanced. Scroll down slightly to the Display section and tick/untick 'Show all windows in the Taskbar' as appropriate.

Sun

[AntonRajiv]

I have 3 workbooks open and it does not show all the 3 sheets under view switch windows

[AntonRajiv]

I have 3 excel sheets opened but it does not show all in view, switch windows

[dilipandey]

Hi Rajiv,

all of them xlsx or any xls window is there ?
I observed Excel 2003 file opens separately on my pc having excel 2013



Regards,
DILIPandey
<click on below * if this helps>

[AntonRajiv]

Tried the Excel Options and Advanced. Scroll down slightly to the Display section and tick/untick 'Show all windows in the Taskbar' as appropriate.

It still opens all the excel files as different instanses

[AntonRajiv]

All of them are xlsx files

[martindwilson]

Have you tried the link I gave you?

[AntonRajiv]

I downloaded the zip file and have the txt file "Remove Open In New Excel Instance" but I cannot change the extension to .reg.

Any suggessions on how to do that?

[martindwilson]

just right click the extracted text file and rename