| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel automatically inserts a formula in my sheet
HI! I am trying to update data in a sheet someone else set up and they are
not here to help. The sheet it set up to automatically calculate formulas in cells without using =, so when I try to change the date it is read as a formula. How can I get rid of this?? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel automatically inserts a formula in my sheet
Try going to tools,options,transition, in sheet options the items should not be checked -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=558897 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I stop an Excel sheet from automatically hiding rows when . | Excel Worksheet Functions | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Linear Mode
