+ Reply to Thread
Results 1 to 10 of 10

open the excel program in read only mode

  1. #1
    Registered User
    Join Date
    11-05-2008
    Location
    USA
    Posts
    7

    open the excel program in read only mode

    whe i click the excel icon i get the read only message, i know it can happen when you open i file that's read only but this is the excel program what can be wrong
    thanks
    paco

  2. #2
    Registered User
    Join Date
    11-05-2008
    Location
    USA
    Posts
    7

    here's a print screen

    of the error this happens when i open excel program not a file also, i think it's affecting me on my formulas couse all the liks to formulas have been broken.

  3. #3
    Registered User
    Join Date
    11-05-2008
    Location
    USA
    Posts
    7
    picture of error
    Attached Images Attached Images

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582
    The file "Personal.xls" is a hidden workbook for macro storage (not specific to one workbook). The hidden workbook opens on your first instance of opening up Excel. If you attempt to open another Excel application (e.g. outside the current Excel window), you'll get the message you describe. It is only the hidden Personal.xls file that is being opened as read only and should not affect your normal workbook. Does this help?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  5. #5
    Registered User
    Join Date
    11-05-2008
    Location
    USA
    Posts
    7

    Smile

    Thanks for the answer so do you think that this read only error is not messing arround with formulas on my worksheets, because that is happening now all my formulas are failing on me.
    thanks

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    It won't affect your formulas at all.
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Registered User
    Join Date
    11-05-2008
    Location
    USA
    Posts
    7
    BTW this only happens on two computers that uses the files, but in the third one the files are ok and the formulas work as they should.
    Please Help me.
    thanks

  8. #8
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582
    Are the formulas linked to external workbooks (and the other two computers cannot access those workbooks)?

  9. #9
    Registered User
    Join Date
    11-05-2008
    Location
    USA
    Posts
    7
    Not necesary, some are in the sane workbook

  10. #10
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582
    Can't really tell you what is wrong with out seeing an example of the workbook. You can modify confidential info if necessary as long as the formulas remain the same.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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