Results 1 to 11 of 11
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Hi
    Sometime ago I requested a module for deduping data.
    Hans replied with with a very good module that he suggested I save as a "personal" file and locate it in the Excel startup folder. This works great for me. However, I have a user that is required to have multiple instances of Excel running but whenever he runs more than one he gets a Dialogue box that informs him that the Persoal file is being used by someone else and can only be opened as read only. This caused him to lose a lot of data as he had to shut down in a hurry and overlooked the message to save his file before exiting. I know, doh! but it happens to us all at times.

    Can anyone suggest how we can overcome this problem? I am running MSO 2003 & xppro the other user MSO2007 & xppro

    cheers
    cheers

    Phil Carter

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='bonriki' post='769589' date='07-Apr-2009 21:43']I have a user that is required to have multiple instances of Excel running[/quote]
    Why is that? Excel is able to open many workbooks within a single instance. Running multiple instances is a waste of resources.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Hi Hans

    He is the IT Manager and that is the way he likes to work
    cheers

    Phil Carter

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    He'll either have to change his ways or learn to live with the read-only limitation.

    Personal.xls is meant as a macro container only anyway, one shouldn't store any data in it.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Hans

    That is right. However, because of where it is stored it opens everytime Excel is run.

    I have tried saving it as an Excel template, but this doesn't seem to work.
    cheers

    Phil Carter

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Personal.xls should be hidden. If it is visible:
    - Activate Personal.xls.
    - Select Window | Hide.
    - Quit Excel.
    - Answer Yes to the prompt to save changes to the Personal Macro Workbook.

    Next time Excel is started, Personal.xls will be opened invisibly. The macros it contains will be available.
    Starting a second instance of Excel will still cause the dialog about opening Personal.xls read-only, whether it's hidden or not.

  7. #7
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Hans thanks for that

    I get the error message stating that a document with the same is already open you cannot open 2 documents with the sane name.
    Attached Images Attached Images
    cheers

    Phil Carter

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    When do you get that error?

  9. #9
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Hans

    When Excel started/opened.
    cheers

    Phil Carter

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Have you somehow ended up with two copies of Personal.xls in different startup folders, for example in the XLStart folder and in the folder specified in the General tab of Tools | Options...?

  11. #11
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Hans

    You are right on the button once again. Don't understand how acopy of personal.xls got into that folder!

    Thanks again

    Phil Carter
    cheers

    Phil Carter

Posting Permissions

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