Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 22

Thread: Problems with Shared Workbooks

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi All,

    I've got 8 shared workbooks and about 18 staff who use them all, on each worksheet is a button which saves the workbook and the re-opens it (kinda like a refresh button), now i'm having people save the workbooks but the saves are not there when the workbook is re-opened? BUT there are temporary files appearing with their saved changed in the same directory as the workbooks?.

    Basically how can I stop this from happeneing?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What code is in the button? If you change it so that all it does is Save, it should show the changes made, as long as the other people using it are saving inbetween changes. It does on our shared workbooks

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi AudioJoe,

    The code for the update button is:

    Application.DisplayAlerts = False 'Turn off before saving
    ActiveWorkbook.SaveAs Filename:= _
    "H:default Directoryplanner.xls", FileFormat:= _
    xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
    , CreateBackup:=False

    Workbooks.Open Filename:="H:default Directoryplanner.xls"

    Is all the code after the saveas filename command needed?

    Regards

    Dave PB

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    --------------------------------------------------------------------------------
    Hi AudioJoe,

    Please ignore the previous typos & the message!

    The code for the update button is:

    Application.DisplayAlerts = False 'Turn off before saving
    ActiveWorkbook.SaveAs Filename:= _
    "H:default Directoryplanner.xls", FileFormat:= _
    xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
    , CreateBackup:=False

    Workbooks.Open Filename:="H:default Directoryplanner.xls"

    Is all the code after the saveas filename command needed?

    Regards

    Dave PB

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dave,

    We use a lot of shared workbooks here, and there are as many as up to 30 or 40 people using them at a time. All we do is have people click Save after every time they make a change. This updates the whole spreadsheet with all other changes saved since the last time the user clicked Save. Try it, you'll see all the most recent saved changes highlighted in different colours around the spreadsheet.

    What you could do is tell them all to just click Save, or if they're used to the button thing now, change the code to:

    ActiveWorkbook.Save

    Audiojoe
    I'm just a jealous guy

  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    AudioJoe,

    It's so simple!

    why didnt I think of it!

    All Hail AudioJoe!

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    King AudioJoe,

    Sometimes we get a message letting us know we can only access a shared file as a read-only file? dont s'pose you know why?

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you had any Dr Watsons?

  9. #9
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    nope...no dr watsons at all

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How many of you is it happening to?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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