Excel 2016 screen updating
STATUS: FIXED This issue is fixed in Monthly Channel Version 1712 (Build 8827. To get the latest update immediately, open Excel and choose File Last updated: December 13, 2017 ISSUE If you use a button in a worksheet to start a macro and later close this workbook, subsequent attempts to calculate user-defined functions provided by an XLL add-in might crash.
This issue impacts Excel 2016 in Version 1608 (Build 7301.xxxx).
The next time you start Excel, you'll be prompted for the password again if you open the workbook that contains the query and then attempt a refresh operation.
Sub Test() Dim w1 As Workbook Dim w2 As Workbook Application.
XXXX) and Version 1801 (Build 9001.2138) in the following Office edit languages: Chinese, Japanese, or Korean.
Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Note: Excel prompts you for the password only the first time that the external data range is refreshed in each Excel session.You can keep the data in your workbook up to date by "refreshing" the link to its source.Each time you refresh the connection, you see the most recent data, including anything that's new or has been deleted.To get the latest update immediately, open Excel and choose File Create from file and then click the Browse button, Excel 2016 may crash.It seems this issue impacts these builds: Monthly Channel Version 1709 (8528.****) or Semi-Annual Channel Version 1708 (8431.****).