Google spreadsheet cell reference between seperate spreadsheets

I have 2 Google Docs Spreadsheets which I tried to "connect". In the documentation and Helpfiles I cann't find anything. In Excel it is possible in the way  ='[otherfile]worksheet'!A4 . A simple question ;-) so I hope that so many people has an answer  :-)
Ernst_JVAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MagaduCommented:
'[FileName.xlsx]SheetName'!$A$1

You can do this same way as when you pull data from different sheets, but instead switching between files.
0
MagaduCommented:
Please Ignore my commnet ... I need my coffe.
Sorry :(
0
Ernst_JVAuthor Commented:
Thanks for your reaction, but :-( it isn't the answer. In Excel it works that way but in Google not. Did you have a nice cup of coffee. :-) I hope.
0
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

MagaduCommented:
May be this will compensate for Not-So-Smart comment i did this morning.

It's not perfect but worked (some what) for me.

http://docs.google.com/support/bin/answer.py?answer=98757 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ernst_JVAuthor Commented:
OK not yet tested but YOU find the right article. Why you and not me ;-) Thanks very much. I'll let you know if this is THE way, but I think it is. Bye bye and thank you again.
0
Ernst_JVAuthor Commented:
Easy reading and quick responce.
0
MagaduCommented:
I was feeling so guilty about posting that idiotic comment that I included my other team member in this search and spend lot so time looking for it or maybe I was just lucky.
0
Ernst_JVAuthor Commented:
AND here is THE result from the test : thanks to you and you other team member. IT WORKS !!! :-) :-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Spreadsheets

From novice to tech pro — start learning today.