How to share a worksheet with others in Office 365 Excel? PresentationPoint

No video

How to share a worksheet with others in Office 365 Excel? PresentationPoint

Рет қаралды 228,062

Күн бұрын

How to share a worksheet with others in Office 365 Excel? PresentationPoint
Office 365 / Excel 365
Sometimes you want to work with multiple persons on the same Excel worksheet, but you get an error that the file is in use.
See how you can share an Excel workbook and work together with multiple persons on the same Excel document.
When you want to show your Excel data in real-time on your television screens like a message board or KPI dashboard, then you also have to do this trick here because you have 2 users already. You, doing the data input, and our DataPoint plugin to connect your PowerPoint slides to your Excel data. This is already an example of multi-user.
More info at www.presentati...
✅PLEASE SUBSCRIBE AND PRESS THE BELL🔔ICON➡️bit.ly/3gXDuV1
✅VISIT OUR WEBSITE➡️www.presentati...
✅BUSINESS QUERIES➡️info@presentationpoint.com
✅Download Free PowerPoint Digital Signage templates: www.presentati...
✅Access our Free online course: "How to Use PowerPoint for Digital Signage" presentationpo...
🎬CHECK OUT OUR POPULAR VIDEOS:👇
▶️How to work with multiple users on an Excel worksheet?➡️ • How to work with multi...
▶️How to link PowerPoint to Excel for dynamic data updates?➡️ • How to link PowerPoint...
▶️Digital Menu Boards Created Easily using PowerPoint➡️ • Digital Menu Boards Cr...
▶️Mail merging Excel information into PowerPoint presentation➡️ • Mail merging Excel inf...
▶️How to run a live countdown timer in PowerPoint➡️ • How to run a live coun...
🤝STAY CONNECTED WITH US:👇
✅ / presentationpoint
✅ / presentationpnt
✅ / 3500848
✅www.presentati...
#PresentationPoint
#powerpoint
#excel
#word
#presentation
#microsoft
#powerpointpresentation
#office
#ppt
#business
#microsoftexcel
#design
#accounting
#amazingslidepresentation
#slides
#digitalsignage
#powerpointdesign
#slidedesigner
#livepowerpoint
#slidepowerpoint
#marketing
#presentationdesign
#mailmerge
#screen_savers
#Promoting_Online_Courses
#PowerPoint_for_Digital_Signage
#Coronavirus
#Automating_PowerPoint_from_Excel
#Google_Analytics_data
#KPI_dashboards
#PowerPoint_Salesforce_integration
#One_World_Observatory
#Merge_PowerPoint_Presentations
#Mind_blowing_PowerPoint
#Digital_Signage

Пікірлер: 93

@guslasaganibau6786 Жыл бұрын

Great. Now i can share the workbook

@magdaszpos 4 жыл бұрын

OMG that was so easy to follow. I need this at work so much now I know how😃. You are great and I am so happy😁. Thank you 👍 😊

@PresentationPointChannel 4 жыл бұрын

You are so welcome!

@val9238 2 жыл бұрын

BRILLIANT !!! THANK YOU. much better than the default way to share it.

@anitataide7971 2 жыл бұрын

Thank you thank you thank you! Excel makes this harder than it needs to be.

@Gorettification 4 жыл бұрын

Very clear instructions! It worked, thank you so much :)

@normaachon1497 3 жыл бұрын

Thank you so much!!!! I was having so much trouble finding a video to show me this!!! Thank you

@ruemarova 3 жыл бұрын

So easy to follow! Thank you so much!!

@lalaram3192 2 жыл бұрын

Thanks for such a directive way. It is very useful.

@bridalaffection3193 4 жыл бұрын

Thank you very much. Very helpful!

@hamadanady4563 2 жыл бұрын

Thanks so much. This is very helpful 🙂

@dorisdejesus5606 2 жыл бұрын

Thank you! very helpful :)

@PresentationPointChannel 2 жыл бұрын

You're welcome. Subscribe for more tips and tricks.

@crystalsavescash3768 11 ай бұрын

This is so helpful! Thank you! I have been missing this feature so much. The file sharing with Office 365 is not working for me.

@andreaappe4748 2 жыл бұрын

This is perfect! Thank you for clear instructions. One thing, I’ve noticed my pivot tables do not work once shared? Is there something I can do to fix this?

@PresentationPointChannel 2 жыл бұрын

We have heard that before that some features like this pivot tables is removing that sharing functionality. No solution for that however...

@andreaappe4748 2 жыл бұрын

@@PresentationPointChannel thank you for the quick reply!! Appreciate your help.

@phantomphotography7392 2 жыл бұрын

Bravo! Great instructions.

@kate71429 3 жыл бұрын

Thank you so much. This came in handy just right now for work.

@PresentationPointChannel 3 жыл бұрын

Great news Kate!

@CallMeEsteban Жыл бұрын

You are a lifesaver!

@mywork4509 3 жыл бұрын

thanks a lot

@venkatesh652 4 жыл бұрын

Thank you so much for this, At 2:30, I don't see Share workbook (Legacy) option under Data Tab, however it's listed under Review Tab. (Office 365)

@PresentationPointChannel 4 жыл бұрын

Thanks for sharing this info

@marissasuperstar 2 жыл бұрын

Thank you!

@AngeleaBebee 4 жыл бұрын

So helpful! thank you so much!

@PresentationPointChannel 4 жыл бұрын

Glad it was helpful!

@gunshowdeepburn 2 жыл бұрын

Thank you so much.

@kensawh 2 жыл бұрын

Thank you

@valdennismusa8913 3 жыл бұрын

This is very helpful..my problem fix this step 🥰

@PresentationPointChannel 3 жыл бұрын

Thanks for letting me know!

@divyabharathi8918 2 жыл бұрын

This is very helpful .. Thank you

@Gorglin1 4 жыл бұрын

You are simply the best! Thank you very much!

@sid7769 3 жыл бұрын

Thank you.

@howitslimeslimy5652 2 жыл бұрын

Hi, PP…. Question about the data we updated in the file. Will we all staff see the new data once we hit save button on the file?

@PresentationPointChannel 2 жыл бұрын

Good question, When you hit the save button, then all the data is saved within the presentation. So when opened by others, even without the datapoint plugin installed, they will see the latest when saved info. But of course, it will not refresh with the latest data automatically when no plugin is installed.

@howitslimeslimy5652 2 жыл бұрын

Thank you for your clarification…Do you mean the updated data will sync up with the file in the public driver, which is M drive. When we open the file in the morning, should we just go to One Drive directory to open the file. In other words, we don’t pull the file in the M drive anymore?

@PresentationPointChannel 2 жыл бұрын

@@howitslimeslimy5652 When you open the presentation with datapoint installed, it will refresh the data in the presentation. When you save, that data is made available for others (without datapoint). See? But you can also use the enterprise edition for you, and then give your colleagues the free viewer edition. Then it will also update the information at opening time for them all. Free use of the datapoint viewer in that case. All clear?

@cypher404 3 жыл бұрын

Thank you, tried mine ... excellent!

@zeenas6792 3 жыл бұрын

Thank you....

@AravindVLOG388 4 жыл бұрын

Thank you .. it is worthy..

@amolsinghthakur6159 3 жыл бұрын

Thank you very much! 🤘

@amitkaundal07aug 3 жыл бұрын

Nice 👍

@ambika293 4 жыл бұрын

Thank you so much

@series25a Жыл бұрын

Question does this work if your table has formulas or drop down box?

@PresentationPointChannel Жыл бұрын

I guess so, but best is to try it out! Then you know for sure.

@saulsadekylorente8559 4 жыл бұрын

Hello, This function is great, however, I get an error message at the point where I click to share. it mentions I cannot share because my workbook has tables or XML maps, Any suggestions?

@PresentationPointChannel 4 жыл бұрын

Yes, we have seen it before. That does not work when you have tables or XML maps. Only with a 'simple' worksheet. Can you drop the tables or XML maps?

@saulsadekylorente8559 4 жыл бұрын

@@PresentationPointChannel Not really, I will be needing them for sure, it does say to convert the tables to range and the XML maps can be removed but for sure I don't have xml's. Any help?

@SignageTube 4 жыл бұрын

@@saulsadekylorente8559 I don't have your file, but I suggest to work the other way around. Start with a new and shared sheet and copy over stuff one by one that you need and make sure that it can be saved every time.

@annap.967 3 жыл бұрын

Thank you!!!!

@fantouch 4 жыл бұрын

how can I get information from multiple excel files in a dynamic way? Several people will have their own file with the same columns, I need one file with all the data of the several files, It is possible?

@PresentationPointChannel 4 жыл бұрын

Sure possible. See this www.howtogeek.com/howto/2468/create-a-hyperlink-to-another-document-in-an-excel-worksheet/#:~:text=With%20your%20Excel%20document%20open,you%20want%20to%20link%20to.

@loganathansivakumar1025 4 жыл бұрын

Thanks a lot

@BackKeris Жыл бұрын

hopefully someone will help me I followed this video instruction, and it did success However I work using BOX app, and it shows conflicting and always create new file when someone access in the same time Any solution?

@PresentationPointChannel Жыл бұрын

Not sure. I guess that you best check this out with Microsoft or the company of the BOX app?!

@molangcat 4 жыл бұрын

Thank you so much!!!!

@cjlim2197 3 жыл бұрын

how can they access the file? is it like google sheets where we input their email address to share the file with them?

@PresentationPointChannel 3 жыл бұрын

That is only for people on your network, not to be compared with google sheets where you have a spreadsheet in the cloud...

@Bobbeige 4 жыл бұрын

THANK YOU!!!!!!!!!! my colleagues think i'm a genius

@PresentationPointChannel 4 жыл бұрын

I will not tell them:-)

@souhailcharafi 4 жыл бұрын

Is this also possible for excel files with a connected mysql database (odbc)?

@PresentationPointChannel 4 жыл бұрын

No I don't think so with a database connection. There are some restrictions and I think this is one

@shivakumarks88 4 жыл бұрын

Microsoft made it so complex. Just it is a headache...

@baljatejesh 4 жыл бұрын

Supper

@yulose9 4 жыл бұрын

it works but not in online Excel bit still works😅😅 THANK YOU SO MUCH SO SAVED MY THESIS

@PresentationPointChannel 4 жыл бұрын

Good to hear:-)

@gustavorubio7232 4 жыл бұрын

Thanks, very good explanation

@pankajkeith 3 жыл бұрын

Thank you.👍

@eniyavaikooral9712 3 жыл бұрын

sir, thanks for this information, how to do this in ms excel 2007. kindly upload new video , how to do this sharing in ms excel 2007

@PresentationPointChannel 3 жыл бұрын

In 2007 it should be already visible in the menu. See it?

@davidpokora4997 4 жыл бұрын

Works to an extent, but you haven't completed the presentation by showing how others open the origingal document. In other words. I created a file in Computer A and used your presentation for creating the shared workbook. Then when Computer B opens the file he/she sees the orignal file created in Computer A....Yeah! However why can't all users see changes maded to the original document?

@anjalichandrika9932 Жыл бұрын

Exactly the same here

@marshaharkleroad6902 2 жыл бұрын

How do you send it to notify the users of the workbook?

@PresentationPointChannel 2 жыл бұрын

A notification is not sent. They just see the values being updated while they have the worksheet open.

@matiasgomeztoledo 4 жыл бұрын

legend

@cacsnitinmahajan6413 4 жыл бұрын

DEAR,THIS FUNCTION IS INBUILT IN OFFICE 365 IN EXCEL ON DEFAULT PAGE. WHAT'S NEED TO ADD IT SEPERATELY?

@mashakamenskikh 4 жыл бұрын

not actually. in new excel, there is no such function

@bogura 4 жыл бұрын

Any idea why when it works when 2 people have the file open, but the moment a third has it open it locks and does not work?

@PresentationPointChannel 4 жыл бұрын

No sorry, never seen. Are you all on the same version?

@bogura 4 жыл бұрын

PresentationPoint yes we are all using the same one, so the moment a third person opens it, it locks it for me and won’t let me save or even close it until they come back out of the file, yet I can go in and out of the file with them when we work as a pair

@PresentationPointChannel 4 жыл бұрын

@@bogura Make a copy or better, start with a fresh one. Do you have the problem then too? Drop data and sheets from your original and see how it behaves... That is what I would do.

@bogura 4 жыл бұрын

PresentationPoint that could take some time, there are 1200 records to move each one is 4 rows xD I have tried with a blank new sheet and the same thing happens it locks and sometimes disconnects people from it

@PresentationPointChannel 4 жыл бұрын

@@bogura Maybe best to ask this at answers.microsoft.com/en-us. There are some better experts watching.

@roselisjose1424 4 жыл бұрын

i have tried this. but others are not able to save to this file. can you help??

@PresentationPointChannel 4 жыл бұрын

What is the exact error or message they get then?

@rasinahbinteshaiksafiudeen6278 3 жыл бұрын

i tried this but my team couldnt edit. Why?

@PresentationPointChannel 3 жыл бұрын

Hard to say this way. Try with a new fresh excel and try to share that. Is it working? Do you get an error?

@telladoflorencia 3 жыл бұрын

It did not worked

@PresentationPointChannel 3 жыл бұрын

any more detail on your situation?

@ronancarney1385 3 жыл бұрын

this is a useless method and never works properly!

@PresentationPointChannel 3 жыл бұрын

It works for me and our customers on normal/simple Excel worksheets. In some special cases (complex use of Excel and other features) it might not work.