Problems with Shared Workbooks

[daveparrinbull]

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?

 

[Audiojoe]

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

 

[daveparrinbull]

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

 

[daveparrinbull]

--------------------------------------------------------------------------------
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

 

[Audiojoe]

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

 

[daveparrinbull]

AudioJoe,

It's so simple!

why didnt I think of it!

All Hail AudioJoe!

 

[daveparrinbull]

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?

 

[Audiojoe]

Have you had any Dr Watsons?

 

[daveparrinbull]

nope...no dr watsons at all

 

[Audiojoe]

How many of you is it happening to?