+ Reply to Thread
Results 1 to 10 of 10

Both existing and new files have becomer or begin with a READ ONLY status

Hybrid View

Jim Varner Both existing and new files... 08-30-2024, 09:55 PM
AliGW Re: Both existing and new... 08-31-2024, 01:01 AM
Jim Varner Re: Both existing and new... 08-31-2024, 07:31 AM
AliGW Re: Both existing and new... 08-31-2024, 08:16 AM
josephteh Re: Both existing and new... 08-31-2024, 10:06 AM
Jim Varner Re: Both existing and new... 08-31-2024, 06:44 PM
jackshield Re: Both existing and new... 08-31-2024, 07:15 PM
Jim Varner Re: Both existing and new... 09-05-2024, 10:39 PM
TMS Re: Both existing and new... 08-31-2024, 07:15 PM
AliGW Re: Both existing and new... 09-06-2024, 12:55 AM
  1. #1
    Registered User
    Join Date
    01-10-2021
    Location
    Jacksonville, NC
    MS-Off Ver
    2019
    Posts
    19

    Both existing and new files have becomer or begin with a READ ONLY status

    Hello,

    Files I've had for years and have opened hundreds of times are now loading as READ ONLY which of course requires me to rename them before I close them.

    New files I set up are created READ ONLY.

    Both are undesirable results. Something unknown to me has changed and my research has been unhelpful.

    Who can tell me what's going on all of a sudden?

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,015

    Re: Both existing and new files have becomer or begin with a READ ONLY status

    The sample file is NOT opening as read only for me. Are you still using Excel 2019?
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    01-10-2021
    Location
    Jacksonville, NC
    MS-Off Ver
    2019
    Posts
    19

    Re: Both existing and new files have becomer or begin with a READ ONLY status

    Attachment 878125

    Thank you for your reply. Yes, my Excel is part of Office 2019.

    It opens as READ ONLY on my system. I'm confused.

    Thanks, JV
    Attached Images Attached Images

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,015

    Re: Both existing and new files have becomer or begin with a READ ONLY status

    I believe you. I just can't replicate the behaviour, sorry.

  5. #5
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    4,542

    Re: Both existing and new files have becomer or begin with a READ ONLY status

    I am also using Excel 2019. No such issue with me. Can you try to open the file in Excel?

  6. #6
    Registered User
    Join Date
    01-10-2021
    Location
    Jacksonville, NC
    MS-Off Ver
    2019
    Posts
    19

    Re: Both existing and new files have becomer or begin with a READ ONLY status

    Well I guess my post is simply asking, "On MY machine, can anyone tell me how I can keep my files from both changing to READ ONLY on their own and how I can create NEW files that are NOT Read Only as they have always been in the past?".

    I've used Excel for 20+ years and never encountered an issue like this.

    Thank you,

    JV

  7. #7
    Registered User
    Join Date
    11-07-2012
    Location
    oklahoma city, oklahoma
    MS-Off Ver
    365 VERSION 2309?
    Posts
    79

    Re: Both existing and new files have becomer or begin with a READ ONLY status

    Look at security settings, my trusted locations reset and my files werent updating from tem[pltes until i reestablished path, just a guess

  8. #8
    Registered User
    Join Date
    01-10-2021
    Location
    Jacksonville, NC
    MS-Off Ver
    2019
    Posts
    19

    Re: Both existing and new files have becomer or begin with a READ ONLY status

    This has been solved. When I open(ed) and excel file I was getting a drop down that the program could not find XXXXX. I had an add on called ASAP Utilities which I had recently deleted. My Read only issue apparent began when I had deleted that add on. Fortunately it was still in my recycle bin. I restored it and my Read Only problem went away.

    Thank you to all who replied to try to help.

    JV

  9. #9
    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
    48,470

    Re: Both existing and new files have becomer or begin with a READ ONLY status

    Maybe this will help: https://support.microsoft.com/en-us/...8-14c64e1f1d15

    Clearly, it is a problem with your environment rather than the files themselves. I can open the sample file on my iPad and, obviously, others have opened the file with no issues on PCs.

    I was wondering if temporary file lock files had not been automatically deleted. But I would have thought that would only affect existing files, not newly created ones.

    Can you create a new file and edit it? Then, after you save and close it, it is set to Read Only when you try to re-open the file?
    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


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

    Re: Both existing and new files have becomer or begin with a READ ONLY status

    Glad it's resolved - thanks for letting us know. Please mark the thread as solved.

+ 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. Formula to Read Values and Insert Status
    By Mizzou.2018 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-07-2019, 12:48 PM
  2. Replies: 1
    Last Post: 07-10-2016, 02:27 PM
  3. Text Filter-begin With... (multiple Begin Withs?)
    By hariexcel1987 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2013, 02:12 PM
  4. [SOLVED] Open all excel files in a folder that do not begin with ~$ or ._
    By roblawl in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-03-2012, 01:16 PM
  5. Checking and opening excel files that begin with specific string in a directory
    By ranuse in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2010, 03:42 PM
  6. Text Filter-Begin with... (multiple begin withs?)
    By flyflipper in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-16-2010, 06:29 PM
  7. Replies: 0
    Last Post: 10-18-2005, 02:05 PM

Tags for this Thread

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