• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 135
  • Last Modified:

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?
  • 3
  • 2
1 Solution

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?

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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)
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now