Which is the best solution/setup for synchronizing Excel and Google Sheets, restrict viewing of specific cells and automatic sharing/e-mail notification upon change in cells/columns?

Which is the best solution/setup for synchronizing Excel och Google Sheets, restrict viewing of specific cells and automatic sharing upon change in specific cells/columns/rows (and automatic e-mail notification)?

So far, I've found these possible solutions:

1. For synching (Sync Sheet): http://funbutlearn.com/2013/12/introducing-sync-sheet-sync-ms-excel.html
1. For synching (Sheetgo): https://www.sheetgo.com/import-automatically-data-excel/
1. For synching (G Suite): https://gsuite.google.com/intl/en/
2. For sharing portions of an Excel sheet: http://funbutlearn.com/2017/09/share-portion-sheet-google-spreadsheet.html
3. For automatic sharing and e-mail notification upon change: https://productforums.google.com/forum/#!topic/docs/QyMJDt2ld28

Then there is also Zapier, but I'm not sure where in above it fits in: https://zapier.com/zapbook/google-sheets/

Or would I really not need any other software, just to use MS Excel and Google Sheets?
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.


What does 'och' mean?

Does you mean 'with' or 'and' perhaps?

Sorry if it just a typo, but it looks deliberate as it is in both the title and body of your question, so I am thinking it has some specific meaning in this context?

hermesalphaAuthor Commented:
You are right, it is a typo, Swedish for "and". I was typing in one language but thinking in another. Is there no way I can change this?
No problem - you can't edit it now, but as long as we know, that's fine.

So, when you say you want to synchronise, do you mean that you want to have, say, an Excel file on your hard disk / network drive, and if you make a change to it, the changes automatically synchronise to the Google Spreadsheet, and if you make a change to the Google spreadsheet, it automatically synchronises to the Excel file?

Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

hermesalphaAuthor Commented:
Yes, that was the original idea, but then I saw in Sync Sheet that they use instead the method of clicking a button before synchronizing between local Excel and online Google Sheet. I think this is the best method because then there should be sent an e-mail notification to other persons upon each change in specific fields/rows, and if I am making changes back and forth to test myself, these other persons would get a lot of e-mail notifications for each change I make. The idea with e-mail notifcations is to immediately get the other persons open their synchronized Excel and reply in specific fields/rows whereupon I also get an e-mail notification.

Regarding changing my typo, I tried now to change but it's not possible anymore. Can a moderator help with this?
hermesalphaAuthor Commented:
This VBA seems to be doing about what I had in mind:


(Run macro when you manual change a cell)

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
TracyVBA DeveloperCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: hermesalpha (https:#a42348924)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

Experts-Exchange Cleanup Volunteer
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

From novice to tech pro — start learning today.