ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   help. Excel shows formulas, not answers (https://www.excelbanter.com/excel-worksheet-functions/93588-help-excel-shows-formulas-not-answers.html)

Klodney

help. Excel shows formulas, not answers
 
I have copied a spreadsheet. One spreadsheet works the way I want. The
copied spreadsheet (modified to fit another account) show formulas and not
answers,

Paul Mathews

help. Excel shows formulas, not answers
 
Check to see if you have your formula view on: Click ToolsOptions, select
the View tab and uncheck the "Formulas" check box if it's checked.

"Klodney" wrote:

I have copied a spreadsheet. One spreadsheet works the way I want. The
copied spreadsheet (modified to fit another account) show formulas and not
answers,


Klodney

help. Excel shows formulas, not answers
 
You were exactly correct. Formulas was checked under ToolsOptions. When I
unchecked it, things seem to work as I had intended. Thank you ever-so-much.

"Paul Mathews" wrote:

Check to see if you have your formula view on: Click ToolsOptions, select
the View tab and uncheck the "Formulas" check box if it's checked.

"Klodney" wrote:

I have copied a spreadsheet. One spreadsheet works the way I want. The
copied spreadsheet (modified to fit another account) show formulas and not
answers,



All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com