asked on 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?
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?
SpreadsheetsMicrosoft ExcelFile Sharing SoftwareMicrosoft Office
Last Comment
Tracy
ASKER
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?
Alan.
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.
ASKER
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?
Regarding changing my typo, I tried now to change but it's not possible anymore. Can a moderator help with this?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
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
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.