Can't do Refresh All on worksheet that is connected to SQL databases

[khalilAsslan]

I have a worksheet that is connected to many SQL2008 databases, it pull information from DB's to the excel worksheet, I do (Refresh All) every day, After I press RefreshAll , the worksheet ask for password. So far this works fine on 4 computers who have full access to the worksheet, on 2 other computers it use to work fine, lately it stop working on those 2 computers and i get the error (The workbook is protected and can not be changed) this happen before the worksheet asks for the password.
I can't find the problem, why it works on some computers and on others it does not, all PC's use Excel 2010\2013\2016 all works fine with many other complicated worksheets, my problem is only with this one

 

[mole999]

Re: Can't do Reresh All on worksheet that is connected to SQL databases

the working copy, can that be tested on the others?, are the vba references the same, has it been recompiled by someone on a different machine

 

[khalilAsslan]

Re: Can't do Reresh All on worksheet that is connected to SQL databases

Thanks
All machines open and use same copy, about 5 computers. It use to work fine on all of them, Now only 3 computers can do refresh to the worksheet, the other 2 got same error (The workbook is protected and can not be changed)
So the person on the faulty computer ask the person on the good computer to do a (refresh all) and he continue to work on the sheet
I must say, all of them can work on the worksheet to add delete or change data cells, The only problem is when we need to refresh the data from the SQL databases

 

[mole999]

Re: Can't do Reresh All on worksheet that is connected to SQL databases

and on the machines with issues, have the users fully shut down and restarted (reset the references). what other programmes do they have open at the same time

 

[khalilAsslan]

Re: Can't do Reresh All on worksheet that is connected to SQL databases

sure I have restarted the computers, I thought maybe some OS update caused this problem, so I restored the computers registry to an earlier date prior to the problem, but no change same problem, I even restored earlier version of the Worksheet without change - same problem. all computers are Lenovo laptops with Windows 10 and Office 2016 installed, The computers are shot down every day after work.
The Programs run on the the computers mainly Office applications, Word, Excel, Outlook. and a SAP application that uses SQL2008 client, The SQL and DATAbases are on on server(Server 2008 R2 + SQL 2008 R2)

 

[khalilAsslan]

Re: Can't do Reresh All on worksheet that is connected to SQL databases

Is it possible because the worksheet is opened with different versions of excel ? It is opened with excel 2016 / 2013 /2010 on different computers.

 

[mole999]

Re: Can't do Reresh All on worksheet that is connected to SQL databases

Is it possible because the worksheet is opened with different versions of excel ? It is opened with excel 2016 / 2013 /2010 on different computers.

Different excels have changes in the reference libraries, potential that a recompiled version fails to work on an earlier version, so 2010 wouldn't know about 2016 libraries, but could work the other way round. Just something to chase down and ensure it isn't that sort of issue

 

[khalilAsslan]

Re: Can't do Reresh All on worksheet that is connected to SQL databases

Its working on PC WIndows 7\excel 2016 and windows 7 \ excel 2010 and windows 7\excel 2013
it stop working on 2 pC with windows 10\excel 2016
maybe it is something has to do with windows 10 ?

 

[mole999]

Re: Can't do Reresh All on worksheet that is connected to SQL databases

useful isolation to one OS and one version, each OS tries to improve security so might be the issue, but I don't know and can't offer anymore reasoning

 

[khalilAsslan]

Re: Can't do Reresh All on worksheet that is connected to SQL databases

ok thanks for trying