I have 2 .xlsm files on Sharepoint. The first (Load Sheet) opens the second (Dist Background), pastes information, save and close.
When running the macro, I get the error: 1004 Method 'LockServerFile' of object '_Workbook' failed and the 'Dist Background' is open. I assume it opens but the 'LockServerFile' line doesn't work which leaves it in Read Only instead of Edit mode and throws the error. I have about 6 people running these sheets- A month and a half ago it was working for everyone. Now- one by one they are getting this error, but it does still work for some users. How is this happening? Any ideas how to fix it?
When running the macro, I get the error: 1004 Method 'LockServerFile' of object '_Workbook' failed and the 'Dist Background' is open. I assume it opens but the 'LockServerFile' line doesn't work which leaves it in Read Only instead of Edit mode and throws the error. I have about 6 people running these sheets- A month and a half ago it was working for everyone. Now- one by one they are getting this error, but it does still work for some users. How is this happening? Any ideas how to fix it?
