Selecting data from another sheet

[Firemaster]

This is quite possibly a Office issue rather than excel but here goes anyway;

Opening 2 spreadsheets in Excel 2010 in seperate excel sessions (shift and excel icon opens new excel session)

Adding in a function like sum, vlookup etc where you want to select a range of cells from a different worksheet in the other open session, does not populate in the function field what you select

In table 2 i use =sum
Then goto table 1 worksheet and select A1 to A13 it should populate as per below
i.e. [table1.xlsx]Sheet1!$A$1:$A$13

But when we do this in a seperate excel session it populates nothing.

Just so you know, that if i open both sheets up in the same session, then everything works fine.

this is only using seperate excel processess

Google came up with nowt. I will test this on my office install when i get home, but its a global issue in our work office enviroment

Any ideas?

[martindwilson]

thats correct behaviour they don't communicate like that between 2 sessions

[Firemaster]

it was never the case with office\2000\xp\2003\2007 just 2010? thats rubish if it is the case, good old microsoft improve things for the worse

[martindwilson]

i'm on xp using 97 for testing that and it doesnt work
i'm just going to try on office enterprise 2007 win 8
nope doesnt work there either