How To Share & Sync Your Excel Workbooks Using This FREE ADD-IN
āļāļąāļ
- āđāļāļĒāđāļāļĢāđāđāļĄāļ·āđāļ 15 āļ.āļ. 2024
- ð SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION âš rebrand.ly/7thAnniv_YTDesc
ðĨ GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE âš rebrand.ly/350Wkbks_YTDesc
ð GET A DISCOUNTED DEVELOPERS LIBRARY HERE âš rebrand.ly/UDVL_YTDesc
ðĪBRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN âš rebrand.ly/AIToolpack_YTDesc
ðCREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM âš rebrand.ly/MentorshipProgram_...
âķïļ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
ðĻâðžBECOME AN EXPERT AT DASHBOARDS âš rebrand.ly/ExcelDashboard_YTDesc
ðĢSTART LEARNING VBA HERE âš rebrand.ly/VBAEFFDan_YTDesc
ðBECOME A SUCCESSFUL FREELANCER âš rebrand.ly/FreelancersAcademy...
âïļJOIN TH-cam MEMBERS FOR UNRELEASED TRAININGS âš rebrand.ly/YTMembership_YTDesc
In this video & download, I share with you a brand-new Excel add-in that I have just built that allows you to share and sync your Excel workbook with anyone, without having to write a single line of code. This incredible add-in allows you to share and sync unlimited workbooks, with unlimited users around the world using ANY version of Excel.
âŽDOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
www.excelforfreelancers.com/S...
ðĪ START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM ð rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
âšFREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
âšMENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
âšDASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
âšBEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
âšWEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
âšTurbocharge Your App Development: rebrand.ly/UDVL_YTDesc
âšGet 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
âšGet ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
âšThe Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
âšGet Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
âš1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
ð§Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
0:00 - Introduction
1:12 - Overview
31:20 - Ribbon Loaded Set Ribbon
32:55 - Visible Login
34:29 - Set Shared Folder
46:49 - Open Workbook
47:09 - Start App Event
48:04 - Sheet Change App
1:05:38 - Check and Sync Workbook
1:16:21 - Timer Sync
1:17:47 - User Login
1:21:45 - Shared Folder Check
1:23:20 - User Logout
JOIN OUR COMMUNITY:
âšFacebook Group: rebrand.ly/EFF_Group
âšFacebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
ðĪĐTikTok: / excel4freelancers
ðĶTwitter: / excel4freelance
ðWebsite: www.ExcelForFreelancers.com
ðLinkedIn: / excelforfreelancers
ðĪFacebook: / excelforfreelancers
ðļ Instagram: / excelforfreelancers
ðĨRumble: rumble.com/c/ExcelForFreelancers
âTelegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
ð / excelforfreelancers
New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#FreeExcelAdd-in #Share&SyncExcel #ExcelShare&Sync #ShareWorkbooks
![[Full Episode] MasterChef Junior Thailand āļĄāļēāļŠāđāļāļāļĢāđāđāļāļ āļāļđāđāļāļĩāļĒāļĢāđ āļāļĢāļ°āđāļāļĻāđāļāļĒ Season 3 Episode 6](http://i.ytimg.com/vi/CVUx09Rx0-M/mqdefault.jpg)
ð 7th Anniversary Sale: Save Big This July 2024! âš rebrand.ly/7thAnniv_YTPinnedCom
Thank you so much Randy for this amazing video. This was much needed. You always come up with brilliant solutions to our problems. God bless you.
Thank you so very much, I really appreciate that. I was not even sure if this was possible when I started programming it. It took a lot for me to be able to figure out how to do it. I have so much more planned for the Patreon update.
Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, truly amazing, there is just no stopping the amount of ideas and creativity that you have never mind your skill set. Truly appreciated.
Thank you so very much, I really appreciate that. You have been here from the beginning and it means everything to me.
Thanks, Randy - I am in the process of creating share and synch code; as a time saver, I will transition the code to try your technique. Perfect timing. Thanks. I hope to get this to work OneDrive. Again THANKS!!!
For sure, you are very welcome and I am happy to help and share. It should work on OneDrive however my preferred application is always Dropbox due to its speed and ease of use. Please let me know how it goes with OneDrive. I hope this helps and thanks so much.
that's amazing Randy, thank you so much
Thank you so very much, I really appreciate that
Good job! Good luck with the rest âšïļ
Thank you so very much, I really appreciate that
Really genius, Randy! Congratulations on this :) With a few mods, this seems like a useful way to track / approve / undo changes, too.
Question: will your clever change event be triggered with changes made by macros, if those macros follow the change-one-cell-at-a-time rule? Or could we expect issues due to speed differences between writing data to cells and saving files to disk? If that were the case, perhaps listing changes on a helper sheet, or in an array, would allow for catch-up writing to disk.
Curious to know if youâve tried anything like this with automated cell changes :)
Hi and thanks so much. The only changes that will be triggered by a macro is if that macro makes changes within the range that has been set to track changes as long as its a single cell at a time. Writing text files to the drive happens extremely fast and hundreds can be done within a second or two.
I hope this helps and thanks so much.
Amazing Randy, I can't believe this is possible with Excel. Wich version do you use?
Hi and thanks so much. I am using Excel 365, however I have made sure not to use any formulas or functions from any new version, which means this will work with any WIndows desktop Excel version. I hope this helps and thanks so much.
Dear Randy,
I have followed all the necessary steps and attempted to log in to the file. However, I encountered an error message stating âwrong number of argument or invalid property assignmentâ.
Additionally, Iâm experiencing another issue. When I synchronize the workbook, it doesnât update all at once. Instead, I have to manually click on âSync Shared Workbookâ for each cell that needs updating. For instance, if four cells need to be updated, I have to click four times.
Could you please guide me on how to resolve these issues?
Best regards.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi Randy, this is again a fantastic training. But I have a question: let's assume that the invoice list is synched. When 2 users create an invoice on their workbook then the invoice number will be the same, but the invoice data will probably be different and will be on the same invoice list row. What will happen after synching? Will there be 2 invoices with the same invoice numer? How can we avoid this?
Hi Benoit, thanks very much for your comment. You can increase the frequency of the syncs and also before any save event you can check for any changes by other users so that it is certain that no new other records have been updated by other users. This can be done by running the Check & Sync macro before any changes are made. I hope this helps and thanks so much.
Hi,please prepare excel jarvis which gives data from database on voice command
Hi and thanks so much. I will do my best to get this done in the near future
Hi Randy.
I know this isn't related to the video.
Yesterday when I opened Excel the theme color was changed to white it used to be green.
I tried to change it back but it doesn't work.
I tried all the options in the dropdown list, Dark Gray, Black, White, Use system settings and Colorful.
Although they change the theme but not back to the way it was before.
Plus I noticed the background isn't working either. Like Calligraphy, Circles and Stripes
I tried the page layout theme options but that only changes the colors for the pages.
Is this something that Microsoft did.
Hi Dan. Extremely frustrating. I really dislike that as well and it happened to me also after an Office update. To change your theme back to the green go to the Excel Options > General Tab then look for 'Office Theme' and change it to 'Colorful'
Above that, in Office Background, I have mine set to 'Calligraphy'
I hope this helps and thanks so much.
@@ExcelForFreelancers
I tried that already it only changes the top part green and I can see the calligraphy but when I click back to the worksheet I can't see it.
Before the top was white and I could see the calligraphy and start up was Green.
Anyway thanks.
i can not sync help pls
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Noticed that most of your user email addresses are hyperlinks but one is not. Is there a reason for this differentiation?
Hi Malcolm, thanks for your comment. There is no specific reason for that, if i were to edit then exit the cell, it would turn into a hyperlink. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, this was the solution to my sharing problems and was working for me with my excel workbooks just to see if the ribbon would open and such, no problems. However when I went to start using it setting up members it has come up with a Microsoft Excel form that says "Ribbon is not initialized" when I try to login to a new file as admin. The workbook that was open will also not logout. I have not done anything to the admin password, just added the workbook to the admin account (prior to this error showing up). Any ideas ?
Hi and thanks you can comment that line of code out. it is not needed. Then just restart Excel and it will be fine. Also restarting Excel should fix this as well. I hope this helps and thanks so much.
@@ExcelForFreelancers Tried commenting out the code, but it didn't work, neither did rebooting. I've found and renamed all the addin-files and re-downloaded the xlma file from you again, but still having the same issue. Cannot log in, or if logged in, cannot log out, and the error message about not initialized comes up twice.
The problem seems to be with the Ribbon Refresh, when selecting admin login it asks for and seems to go through the login macro, but then the error msg shows and the ribbon doesn't refresh, stays on login. However if I disable the re enable the addin, it then shows the admin ribbon. Same when login out, msg about not initialized, ribbon stays in the admin view, but if I again turn addin off/on, when selecting Workbook Sharing, the ribbon is in the log out state.
I have not encountered these issues, howeever have made a lot of updates on this addin and released it on our Patreon platform here: www.patreon.com/posts/share-sync-add-105920858
I hope this helps and thanks so much.
Iâm just truly curious. Why not just use online sharing excel where you can see multiple people working on the same document real time?
Hi Grace, thanks so much for your comment. Its a great question. The reason is that the online version of Excel does not allow macros. Macros are extremely powerful in what you can do such as Worksheet Change events, selection change events and a ton more. All of my templates use macros to automate almost everything.
I hope this helps and thanks so much.
Creating add ins is just like HTML.
Thank you for your Likes, Shares & Comments. It really helps.