ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't edit cell (https://www.excelbanter.com/excel-discussion-misc-queries/124879-cant-edit-cell.html)

DRLski

Can't edit cell
 
I'm trying to just add a simple formula to a cell in Excel
"=sum(A1,I1)" but unfortunately it seems to keep coming back with an
error:

"Cell contains a Formula. Cannot Modify. Must Select Cancel."

I tried searching for this error but I came up empty. Anyone have any
ideas on what I am doing wrong?

Thank you,
Dave


Teethless mama

Can't edit cell
 
=A1+I1

"DRLski" wrote:

I'm trying to just add a simple formula to a cell in Excel
"=sum(A1,I1)" but unfortunately it seems to keep coming back with an
error:

"Cell contains a Formula. Cannot Modify. Must Select Cancel."

I tried searching for this error but I came up empty. Anyone have any
ideas on what I am doing wrong?

Thank you,
Dave



Sean Timmons

Can't edit cell
 
That sounds like there's a validation
Try going to Data-Validation while you are in the cell.
Should show Any Value in the top box.


"DRLski" wrote:

I'm trying to just add a simple formula to a cell in Excel
"=sum(A1,I1)" but unfortunately it seems to keep coming back with an
error:

"Cell contains a Formula. Cannot Modify. Must Select Cancel."

I tried searching for this error but I came up empty. Anyone have any
ideas on what I am doing wrong?

Thank you,
Dave



Sean Timmons

Can't edit cell
 
I haven;t mastered the art of reading yet. Thank you for giving the right
answer... :-/

"Teethless mama" wrote:

=A1+I1

"DRLski" wrote:

I'm trying to just add a simple formula to a cell in Excel
"=sum(A1,I1)" but unfortunately it seems to keep coming back with an
error:

"Cell contains a Formula. Cannot Modify. Must Select Cancel."

I tried searching for this error but I came up empty. Anyone have any
ideas on what I am doing wrong?

Thank you,
Dave




All times are GMT +1. The time now is 08:04 AM.

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