Excel Online how to reference a cell from another worksheet

Question

Can you reference another cell on another worksheet? I click the equals sign in a cell then go down to the bottom and choose another tab and click on the cell I want and hit enter but it doesn't work. If I want to reference another cell in the same worksheet than that works fine. Anyway besides typing the formula all out?

Answer 1

I coud see many people are in hurry to provide the Answer without reading the actual problem. 

so first of all i would like to repeat the quetion in layman language 

1- I have two separate office 365 online excel 2016 work book.  just reconfirming 2 seprate online workbook.

2- now i want refer excel Cell from workbook 1  (i.e. Sheet1:B3) in Workbook 2 sheet in any cell.

so here is the question what is the command or example which basically read office excel Oline : URL + sheet + Cell, and if i made any change in cell it should update accordingly.

Answer 2

Akehn posted this question that u can see on top of this thread, it clearly says "another sheet", not "another sheet in another workbook", may be u had some other thread. Anyway your question is a step forward in the same problem of linking one cell with the other, which definitely needs more work.

Answer 3

It does work, just do not prefix sheet name with '#' character.

Answer 4

THANKS SO MUCH

Answer 5

I have been having this issue also, but I found somewhat of a solution when working with Excel Online.

Here is exactly what I used to pull data from another worksheet:

Working in Sheet 2

=Sheet1!A1

So it needs the sheet name you want the data from, followed by an exclamation mark, followed by the cell you want the data from.

Now, what I haven't figured out yet is how to sum multiple cells at the same time.

Hope this helps.

*Update - Figured it out

=SUM(Sheet1!M1, Sheet1!M10, Sheet1!M20, Sheet1!M27)