none
VBA Excel Formula Issues after install Office 365 ProPlus RRS feed

  • Question

  • During Copy Tab in Excel I add Formula on same cell

    Exp: Range("D3").Value = "=IF('Sales Order Form " & sheetcount + 2 & "'!D6:F6 = """","""",'Sales Order Form " & sheetcount + 2 & "'!D6:F6 )"

    Before update Microsoft Office Professional Plus 2013 and 2016:

    Sheet lock D3 = 25 (same value)

    Unlock sheet: Formula in D3 cell - =IF('Sales Order Form 3'!D6:F6 = "","",'Sales Order Form 3'!D6:F6)

    After update to Office 365 ProPlus: Sheet Lock Formula Cell D3 I can see #SPILL!

    Unlock Sheet: Formula Cell D3  {=IF('Sales Order Form 3'!D6:F6 = "","",'Sales Order Form 3'!D6:F6)}Additional Curve Brockets . How I can fix this issue. Please help!!!

    Wednesday, July 17, 2019 8:59 PM

All replies