Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
qp10 formulas returning with 0
- Thread starter Kikalo
- Start date
- Thread starter
- #2
Ok I have some background on the files in question.
After opening a few notebook files with several sheets full of information, sums etc, the user had a crash and received the CARM window - continued through it and continued to work in the program.
The cells containing formulas (some not all) began to say "Not yet, bret". After a search online I found information explaining that the calculation should be re-entered.
Following this, a day after it was solved, some began to show up as "Evaluator Stack Error" Retyping them first solved it but @sums began to calculate as 0. Now every time a @sum is placed into any cell in any notebook, new or existing, they calculate it as 0.
Now also on top of this whenever the user types into a cell with a number and a suffix (eg. 16th) it gives a message "Invalid reference. For formula: block names, cell references, and operators must be correct. For Label: it should start with a label prefix character."
Any Ideas? I know I'm not sure about what it is
hehe
-
Lisa
After opening a few notebook files with several sheets full of information, sums etc, the user had a crash and received the CARM window - continued through it and continued to work in the program.
The cells containing formulas (some not all) began to say "Not yet, bret". After a search online I found information explaining that the calculation should be re-entered.
Following this, a day after it was solved, some began to show up as "Evaluator Stack Error" Retyping them first solved it but @sums began to calculate as 0. Now every time a @sum is placed into any cell in any notebook, new or existing, they calculate it as 0.
Now also on top of this whenever the user types into a cell with a number and a suffix (eg. 16th) it gives a message "Invalid reference. For formula: block names, cell references, and operators must be correct. For Label: it should start with a label prefix character."
Any Ideas? I know I'm not sure about what it is
hehe
-
Lisa
- Status
Similar threads
- Locked
- Question