Let Multiple Users Work on Same Excel File At The Same Time

No video

Let Multiple Users Work on Same Excel File At The Same Time

Рет қаралды 407,465

6 жыл бұрын

Let Multiple Work on Same Excel File At The Same Time in excel with the help of google drive .
To watch more videos and download the files visit www.myelesson.org
To Buy The Full Excel Course visit . www.myelesson.o... or call 9752003788
Connect with us on Facebook - / excelmadeasy
Connect with us on Twitter - / excelmadeasy 10 Most Used Formulas MS Excel
• 10 Most Used Formulas ...
Learn Basic Excel Skills For Beginners || Part 1
• Learn Basic Excel Skil...
10 Most Used Excel Formula
• 10 Most Used Excel For...
*Most Imporant Excel Formuls Tutorials*
Learn Vlookup Formula For Beginners in Excel
• Learn Vlookup Formula ...
5 Excel Questions Asked in Job Interviews
• 5 Excel Questions Aske...
Create Speedometer Chart In Excel
• Create Speedometer Cha...
Learn the Basic of Excel for Beginners || Part 2
• Learn the Basic of Exc...
Create Pareto Chart In Excel
• Create Pareto Chart In...
How to Create Dashboard in Excel
• How to Create Dashboar...
Excel Interview Questions & Answers
• Excel Interview Questi...

Пікірлер: 97

@dbybanez 5 жыл бұрын

MS Excel is different from Google Sheets. Title is totally misleading. You’re basically editing a MS Excel file through Google Sheets, converting it into a Google Sheets file.

@eivinj 3 жыл бұрын

Indian people...

@ekeretteekanem 2 жыл бұрын

YEAH And that does the job. MS EXCEL is not wired to work actively online. Google sheets have the specs

@tommj4365 2 жыл бұрын

Excel has an online version too, that allows multiple people to edit at the same time. Maybe it didn't exist 3 years ago, not sure...

@dbybanez 2 жыл бұрын

@@tommj4365 Yep! MS Excel collaboration 3 years ago was a mess! Users need to download the file first, edit, save, and then upload to sharepoint/one drive. But now, it has the online feature which I think is good but needs more improvements. But to use the online version, you'll have to buy the Office 360.

@ubersilverx2 3 жыл бұрын

After failing to find a way to do the same in OFFICE excel I found this the best next thing Thank you!

@mayanktripathi4072 2 жыл бұрын

Thank you

@GuruJii 2 жыл бұрын

Thank you. To see our latest videos please visit www.myelesson.org/

@0MaXimusMiNimus0 4 жыл бұрын

..."by using google drive/sheets" should be added to the title.

@sunilbishnoi7887 2 жыл бұрын

Thanks

@GuruJii 2 жыл бұрын

Thank you. To see our latest videos please visit www.myelesson.org/

@sammieuyere211 3 жыл бұрын

This was all I needed. Very helpful and concise. Subscribed and shared with my network

@adrextreme 5 жыл бұрын

I was expecting a video about excel instead of google sheets

@Rickety3263 3 жыл бұрын

We should get you fixed up with VMware to spin up some virtual machines so you can capture your screen without anything personal on it... just a clean install of windows/office. THANK you for your content! Us architects can't survive without you artists!

@SaadullahMir Жыл бұрын

great idea, strongly recommended.......................

@dikshita8213 Жыл бұрын

Thankyou

@nicoled4282 3 жыл бұрын

Can someone tell me how to do this using excel only because it really needs to be in excel and not google drive

@nurserytoys Жыл бұрын

_there is also alternative method for sharing with microsoft excel._

@guruprasadbm1987 5 жыл бұрын

Hi, Thank you so much for uploading videos & sharing knowledge. I have one doubt. Can we protect the sheet, like other persons (Users), can edit only once but they can not modify any data once edited

@loansloans6675 2 жыл бұрын

SUPER

@moesadr3342 Жыл бұрын

What about VBA enabled workbook? My workbook has VBA codes. Could you please tell me how this file can be shared to be updated and synced with other users in Office 365?

@saumyaverma7429 4 жыл бұрын

Can we restrict cells user wise ? like Cell no. 1 to 10 by jay and 11-25 by heena

@nsp2506 3 жыл бұрын

Very useful for me

@ghazihaider1275 2 жыл бұрын

Please tell me about Macro sheets work on Google sheet

@raymondgarcia5535 2 жыл бұрын

Can this work while working on different tabs

@GuruJii 2 жыл бұрын

Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources

@majidbilharish551 4 жыл бұрын

Thank u solo much sir, It was very helpful

@mahmoudhabliza1844 6 жыл бұрын

I'm your follower from Egypt Thank you & go on

@BhanuPrakashTadkal 9 күн бұрын

Looking Yummy

@ramnaslai2980 2 жыл бұрын

Google sheets are different...lots of ms excel features are not available in that...good for small work.

@GuruJii 2 жыл бұрын

Thanks. To watch more video please visit www.myelesson.org/

@srikanthkasala7850 4 жыл бұрын

excellent

@daviddarby3738 5 жыл бұрын

Since my workbook is loaded with macros it must stay on the local machine. How do I share only the data worksheet? (sheet has no macros, however, changes & reference are made through macros)

@najarsameera2499 4 жыл бұрын

Osm and brilliant

@guruprasadbm1987 6 жыл бұрын

Hi Excel Guru, Can we know who edited or deleted text or content whatever..? can we do VLOOKUP from Google sheet to Excel sheet.?

@GuruJii 6 жыл бұрын

Yes, we know who edited or deleted text or content in Google Drive. No, we cant do a vlookup from google sheet to Excel sheet

@guruprasadbm1987 6 жыл бұрын

Thank You Guru :-) How can we know that who edited or deleted.?

@mohammadkhaer7859 5 жыл бұрын

Hello My E-Lesson, It is a google sheet, not MS Excel. MS Excel is an application with way higher capability. You can't do everything on Google sheet. You can use formulas on the Google sheet. You can't add a macro file in there either. So it is a little misleading. If you doing basic calculation stuff, then it is fine. However, you still have to create your formula first, then upload in your google drive.

@ASMRAHAT-xw2uu 3 жыл бұрын

I don't get advance option in share with others interface. Can you pls help me?

@randirsinghbeegun909 3 жыл бұрын

Can a macros enable file uploaded from excel to Google Drive please help

@milagrosgoleta4093 2 жыл бұрын

I did it, but there are some anonymous editors like "anonymous narwal". It shared Public on the web and anyone with the link. Can it be possible to be private on the web and shared with anyone with the link?

@ishratjahananika4762 4 жыл бұрын

Thank U So Much. Its so helpful ❤

@keerthivasan1162 6 жыл бұрын

Hi sir thanks a lot for your videos I have question how to use Google drive in client network its very tough to open drive in clients network pls suggest any other way to access the file

@atuldubey9598 Жыл бұрын

sir kya mai apne excel ko dusre laptop pr open kr skta hu login kr skta hu

@khalidalisubhanallah2947 6 жыл бұрын

Bundle of Thanks Sir Nice Video

@GuruJii 6 жыл бұрын

Thanks Khalid Bhai

@sujith615 4 жыл бұрын

But some formulas not working that sheets after upload on google sheet.

@rajpanchal1280 2 жыл бұрын

Are you from Navapur?

@yogita14 Жыл бұрын

Please share the alternative number for the reference

@nomannaseer7145 3 жыл бұрын

Hi, I have shared excel sheet with 25 user on local network. When someone open the sheet they get all the record available in sheet. I want to set a security when any user open a sheet he will get only his projects not any other user data and one admin user who will see all the projects and update if needed. Suppose there are X, Y, Z ... users. If X user opened sheet he will get only his projects not of Y or any other.

@TushaarShah Жыл бұрын

Did you find an answer to this? I am struggling with this same issue!!! Please advise me.

@ajufohanthony2482 9 ай бұрын

@@TushaarShah I have similar issue, any help?

@zakirabanu5316 6 жыл бұрын

Thanks...

@JinaneKarhani Жыл бұрын

Thad..is doesn't work for files with macros !! too b

@rohidkhan001 6 жыл бұрын

Awesome Video Sir Its Working And Thank You For Making This Tutorial

@GuruJii 6 жыл бұрын

Thanks dear

@KaleemKhan-yv9lz 6 жыл бұрын

thank you sir ji.

@gunindradas8042 4 жыл бұрын

But sir one problem is that macro enable worksheet it not working. Simple file is working. Any solution sir?

@bantikumarsir3095 6 жыл бұрын

thanks

@GuruJii 6 жыл бұрын

Welcome Banti ji

@shaliniagrawal9554 4 жыл бұрын

can we share this file to whatup and work on it .

@beagracefernandez7365 4 жыл бұрын

This was so helpful, thank you!

@ghazihaider1275 2 жыл бұрын

I uploaded Marco sheet

@travel_kick 2 жыл бұрын

I edited by mistake whole file wrong way, how to undo this all?

@egvNY 4 жыл бұрын

Excel is miles away from Google Sheets, GS is just a simple lite version for clerical online stuff. Heavy work requires Excel.

@jobaermahmud7224 5 жыл бұрын

that's grate

@priyanka8064 4 жыл бұрын

Please mention its coz of google sheets... people will think its in ms office / outlook 365

@CreativeTour-ideas 6 жыл бұрын

Hi my e-lesson Sir, plz kaise linking sheet ko another employees ke saath link kare aur unki excel sheet mein pura status show ho jaaye plz its urgent

@anitabhardwaj3642 4 жыл бұрын

how can i allow multiple users to work on single excel with a logic like " nobody can edited the old data entered by another user except admin".

@meghnathijayshreeb1555 4 жыл бұрын

How to Use office network?

@fayagami4926 4 жыл бұрын

Is it mr.Gagan Voice?

@AamirBosan66 4 жыл бұрын

How can 1 file only .xlsm ?

@CreativeTour-ideas 6 жыл бұрын

aur jo bhi task sheet mein kuch bhi data enter kare empoyees ki sheet mein show ho jaaye aur woh sab employee task par kaam kare. aur meri linksheet par bhi show ho jaay ki kaam complete or pending status show ho jaaye plz sir its urgent how to work on it. Thanks sir

@Kakrot_bhai 5 жыл бұрын

We can't do this in excel?

@FunMakers 4 жыл бұрын

Bro Google Sheet is something else and Excel is something else. Main bhi kahu Excel Bahubali kahan se aa gya jo within 5 minutes sharing sikha raha 🤷🏻‍♂️

@meghnathijayshreeb1555 4 жыл бұрын

How to use without internet?

@skasadul6518 3 жыл бұрын

But google drive working too slow

@pradeep8316 6 жыл бұрын

Nice dude

@GuruJii 6 жыл бұрын

Thanks Step One !

@ghazihaider1275 2 жыл бұрын

But not working

@ajayjaiswal9780 3 жыл бұрын

Munni Sheela

@daudhossain7804 6 жыл бұрын

Excel sheet can see.....??? Online any computer to do work save my man

@glitterworldcreation 4 жыл бұрын

Lost case

@mosis9276 3 жыл бұрын

if i wanted to use google sheets I would have made a google sheets smh

@vineetdhiman79 6 жыл бұрын

I asked you question about timer. Do you remember. I think tum se na ho payega

@GuruJii 6 жыл бұрын

Hi Vinit, Sorry i missed your question, could you post question here again ? I loved the " tum se na ho payega" part though ;-)

@carnivoremike 2 жыл бұрын

not true - video misleading. Google Sheets is NOT Microsoft Excel.

@GuTTs1975 3 жыл бұрын

is this a scam???

@GameMaster_84_ 4 жыл бұрын

This is NOT Excel as being mentioned. Thumb down.

@koen8193 3 жыл бұрын

Yea thanks so this is exactly what doesn't work lol. Sheets cannot copy Excel's functions and will destroy the entire formats. So if you are trying to use excel for its intended purpose, this will not work.