Share via

Is it Possible to Stop Excel from Calculating???

Anonymous
2021-08-16T21:59:10+00:00

Hello,

I use Excel spreadsheets to track, sort, and maintain information - none of my data needs to be calculated. I have two issues:

#1 Information I enter into a cell disappears.

#2 If I re-enter the word and hit Save, a message appears saying, "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated."

My question is this: Is there any way to stop Excel from "calculating" my data?

I have searched for a button or option (but I'm am so not a techie) and do not see any such thing.

Any assistance anyone can provide will be greatly appreciated!!!

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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2021-08-16T22:03:46+00:00

    If you don't need calculations, why do you have formulas?

    You can turn off calculation by activating the Formulas tab of the ribbon, and selecting Calculation Options > Manual in the Calculation group.

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-08-16T22:40:37+00:00

    Thank you for replying.

    I had already done what you suggested and I also did it again just now. I still got the same annoying message. :(

    1 person found this answer helpful.
    0 comments
  3. HansV 462.4K Reputation points MVP Volunteer Moderator
    2021-08-17T10:32:44+00:00

    I'm afraid I can't help without seeing the workbook.

    1 person found this answer helpful.
    0 comments