ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel automatically inserts a formula in my sheet (https://www.excelbanter.com/excel-worksheet-functions/97851-excel-automatically-inserts-formula-my-sheet.html)

smurrock

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!

davesexcel

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



All times are GMT +1. The time now is 03:05 PM.

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