stop auto-switching to another desktop

hi,

i have desktop 1 and desktop 2
i have 2 excel files in desktop 1 and 1 excel file in desktop 2
i open another excel file in desktop 1 so there would now be 2 excel file open in desktop 1
then when i close 1 excel file in desktop 1
it will automatically switch to an excel file which is in desktop 2
i understand it switches to another desktop when there are no more excel files open in the current desktop
but i still have 1 excel file open in desktop 1
how can i stop windows from auto switching?
its really getting annoying

i figured it out
make sure to open first the very first excel file(excel app currently closed) in desktop 1
so it wont auto switch to desktop 2 after closing the 2nd file in desktop 1

also found out that every excel file you double click to open will stay in desktop 1
it previously opens at desktop 2 (doesnt matter where you double clicked the file)

im guessing this applies to other file types (doc, txt, etc.)