Excel 2013 "Calculation is incomplete. Recalculate before saving?"

Anonymous
2014-01-02T22:52:06+00:00

I have a dual-boot laptop and desktop, each w/Office 2010 on Windows 7 and Office 2013 in Windows 8.1 .

On both computers, in Excel 2013 [win 8.1], when I make any changes to a file dialog box with "Calculation ..." as outlined in the title of this msg appears.

If I click Yes, the box just reappears with every click.

If I click No, nothing happens and the file is not saved.

Nothing else can be done, and I need to exit the file without saving.

This occurs *after* making numerous changes to sophisticated files, so has become a major problem.

The workaround on both computers -- use the same files in Office 2010 in Windows 7, and the issue does not occur. Ever.

Currently Office 2013 is not usable due to this issue.

Please advise as to the problem, and especially the solution.

Thank you,

- Mik

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

43 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2014-09-16T12:56:07+00:00

    Thanks. I cleaned up the function by declaring the return value properly as Double (previously it may return Double or String), but that alone (?) did also not yet work.

    I found another conditional Formatting in my sheet which also referred to a custom function and after changing it to a conditional formatting which depends on a cell, the Bug seems to be gone.

    In Conclusion: Excel2013 does not support own VBA-Functions in conditional formatting anymore :(

    Work around: Use own function to calculate relevant things in cells and refer with the conditional formatting to these cells. Not quite sure whether that always solves the problem, but it solved my problem.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-09-16T18:49:42+00:00

    I'm not convinced Excel 2013 will not support UDF calls in conditional formatting formulas, for that I would like to see a test workbook.

    UDF's are very sensitive to how they are programmed.  A badly written UDF can break the calculation train, even when just called from worksheets cells.

    Hence my question: what does the UDF look like. If you cannot share it, fair enough, but that also means we cannot troubleshoot the problem.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-09-17T21:23:51+00:00

    The UDF is a simple "IsFormula".

    Function IsFormulaZ(c)

     IsFormulaZ = c.HasFormula

     End Function

    I have a column of calculations where sometimes somebody either hard-enters or deletes in one of the cells.

    When that happens, the cell is consequently shaded red via cond. formatting ... 

    =IsFormulaZ(R64)=FALSE

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-09-18T04:19:16+00:00

    That is *exactly* why it fails. Rewrite your UDF to:

    Function IsFormulaZ(c)

     IsFormulaZ = (Left(c.Formula, 1) = "=")

     End Function

    For some odd reason, HasFormula does not work well in UDF's called from cells or Conditional formatting.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2014-09-18T14:09:38+00:00

    Thank you sincerely.

    Will give this a go and advise.

    This *does not* occur *ever* in Excel 2010, *only* in Excel 2013.  So one way or another -- regardless whether this fix works -- it is an Excel 2013 issue that hopefully Microsoft will address going forward.

    But again, thank you for taking the time to look into.

     - Mik

    Was this answer helpful?

    0 comments