Hi!
Plenty of threads on this one, but I'm still confused. Whenever I protect the worksheet, possibility to refresh a table is disabled (external data connection to IBM DB2). Shouldn't be a problem to overcome with VBA (add Unprotect & Protect the sheet to the code), but instead of pushing a button, I have parametrized the query and it will run automatically as a value changes in cell - I don't want to force users to push a button, but that prohibits me in protecting the worksheet (which doesn't make any **** sense).
Is this really how Excel is supposed to work and there's no way to enable refreshing the data source on a protected sheet? Threads such as this have me confused though:
https://techcommunity.microsoft.com...-a-Protected-Workbook-since-Excel/td-p/179229
There's a comment by Microsoft's rep from Spring 2018 that MS has worked to regress that change and Excel versions 1803 through 1805 had been fixed. We are into 2019 now and I'm running Excel 2016 ver 1812.
Is this how it's supposed to work? Thanks!
Plenty of threads on this one, but I'm still confused. Whenever I protect the worksheet, possibility to refresh a table is disabled (external data connection to IBM DB2). Shouldn't be a problem to overcome with VBA (add Unprotect & Protect the sheet to the code), but instead of pushing a button, I have parametrized the query and it will run automatically as a value changes in cell - I don't want to force users to push a button, but that prohibits me in protecting the worksheet (which doesn't make any **** sense).
Is this really how Excel is supposed to work and there's no way to enable refreshing the data source on a protected sheet? Threads such as this have me confused though:
https://techcommunity.microsoft.com...-a-Protected-Workbook-since-Excel/td-p/179229
There's a comment by Microsoft's rep from Spring 2018 that MS has worked to regress that change and Excel versions 1803 through 1805 had been fixed. We are into 2019 now and I'm running Excel 2016 ver 1812.
Is this how it's supposed to work? Thanks!
