+ Reply to Thread
Results 1 to 10 of 10

Excel Protection

  1. #1
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Excel Protection

    Hello Everyone

    I dont know if its the best place to ask about converting excel to google sheet>

    But i have faced a really problem, when i converted my protected excel sheet (workbook protected, i hide some tabs so none can see it)
    When i converted my excel sheet to google sheet, all the protection was removed, so anyone now can see the hidden sheets !!

    I would highly appreciate your support
    (google sheets doesn't provide something like workbook protection)

    So can i make anything in excel to make the protection still works even the file is converted !
    Last edited by Mahmoudelnemr; 04-15-2020 at 03:40 AM.

  2. #2
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Re: MS Excel sheet protection removed when converted to Google sheets !

    This is really shocking
    Link removed by moderator
    Last edited by AliGW; 04-14-2020 at 12:46 PM.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,445

    Re: MS Excel sheet protection removed when converted to Google sheets !

    I suspect you've answered your own question ...
    google sheets doesn't provide something like workbook protection
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Re: MS Excel sheet protection removed when converted to Google sheets !

    So, is there a way to protect excel from being unprotected by google !

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: MS Excel sheet protection removed when converted to Google sheets !

    We know that protection can be hacked, but we don't promote it, even as a warning, so I've removed the link you provided. Please don't post that link again. Thanks.
    Last edited by AliGW; 04-14-2020 at 12:56 PM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  6. #6
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Re: MS Excel sheet protection removed when converted to Google sheets !

    Ypu are right, i am sorry
    I am only shocked its not indirect way or using software for hacking !
    its just converting it

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: MS Excel sheet protection removed when converted to Google sheets !

    Yes, and in converting it, it's bypassing security, which is hacking.

    Anyway, you must remember that Excel security is only really designed to secure the structure of your workbook. It was never intended to secure your data. You should bear this in mind going forward.

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,445

    Re: MS Excel sheet protection removed when converted to Google sheets !

    You could Google it ... I found this: https://whatagraph.com/blog/articles...t-google-sheet

  9. #9
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Re: MS Excel sheet protection removed when converted to Google sheets !

    Quote Originally Posted by AliGW View Post
    Yes, and in converting it, it's bypassing security, which is hacking.

    Anyway, you must remember that Excel security is only really designed to secure the structure of your workbook. It was never intended to secure your data. You should bear this in mind going forward.
    Do you think i could find an answer in CS forum ?

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: MS Excel sheet protection removed when converted to Google sheets !

    No - this is a Google Sheets limitation. Paying for help isn't going to change that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Sheets (FILTER + ARRAY) Function translated to my EXCEL Sheet
    By dmcmaste in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-31-2020, 01:35 PM
  2. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  3. Google Sheets Query IF column problem Converted to Excel Function?
    By Garthilk in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-24-2015, 10:37 PM
  4. Replies: 1
    Last Post: 04-05-2014, 01:09 AM
  5. Replies: 1
    Last Post: 01-25-2014, 02:10 PM
  6. Inserted Cells are removed from sheet protection range
    By KJaffa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2008, 06:00 PM
  7. Why is protection removed from an emailed spreadsheet?
    By TheatreTreasurer in forum Excel General
    Replies: 2
    Last Post: 04-24-2006, 10:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1