Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula's not working
any suggestions as to why no formulas are working on my pc when the same
exact spreadsheet works on all other pc's? tools, options, view tab, window option, the formula box is NOT checked. -- Dave |
#2
|
|||
|
|||
Somehow it might be seen as text, assuming you have the text of the formula
instead or the result. Makes sure the format is not text and select the whole sheet, do editreplace, find what = replace with =, thus replace equal sign with equal sign sometimes trigger calculation Regards, Peo Sjoblom "Dave" wrote: any suggestions as to why no formulas are working on my pc when the same exact spreadsheet works on all other pc's? tools, options, view tab, window option, the formula box is NOT checked. -- Dave |
#3
|
|||
|
|||
No, the cell with the formula is a number not text.
Solved the problem. Under tools, options, the Calculations tab was set to manual. Thanks dave "Peo Sjoblom" wrote: Somehow it might be seen as text, assuming you have the text of the formula instead or the result. Makes sure the format is not text and select the whole sheet, do editreplace, find what = replace with =, thus replace equal sign with equal sign sometimes trigger calculation Regards, Peo Sjoblom "Dave" wrote: any suggestions as to why no formulas are working on my pc when the same exact spreadsheet works on all other pc's? tools, options, view tab, window option, the formula box is NOT checked. -- Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Major tick to none on charts is not working, is it a bug? | Charts and Charting in Excel | |||
Formulas | Excel Discussion (Misc queries) | |||
when displaying formulas, how to start a new line in the same cel. | Excel Discussion (Misc queries) | |||
How to cut and paste with locked formulas | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |