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?

hermesalpha
hermesalpha used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AlanConsultant

Commented:
Hi,

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?

Alan.

Author

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?
AlanConsultant

Commented:
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?


Alan.

Author

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?
This VBA seems to be doing about what I had in mind:

https://www.rondebruin.nl/win/s1/outlook/bmail9.htm

(Run macro when you manual change a cell)
TracyVBA Developer

Commented:
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.

broomee9
Experts-Exchange Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial