| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot Change Formula in Spreadsheet
A client as several workbooks with spreadsheets that use the same formula.
On certain sheets, he can change the formula - is using the =LEFT(B6,1), but on others it gives him the error - "Don't Try it". On these cells, we can copy the formula from a sheet that it works on to this cell and then it works fine. There are no macros used in this workbooks. Any ideas of what could be preventing us from editing the formula, but yet allows us to paste a new formula from an existing cell that works? -- Rather be golfing |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot Change Formula in Spreadsheet
did you check data validation?
linda wrote: A client as several workbooks with spreadsheets that use the same formula. On certain sheets, he can change the formula - is using the =LEFT(B6,1), but on others it gives him the error - "Don't Try it". On these cells, we can copy the formula from a sheet that it works on to this cell and then it works fine. There are no macros used in this workbooks. Any ideas of what could be preventing us from editing the formula, but yet allows us to paste a new formula from an existing cell that works? -- Rather be golfing |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cannot Change Formula in Spreadsheet
It Worked! Thanks Cesar.
-- Rather be golfing "Cesar Zapata" wrote: did you check data validation? linda wrote: A client as several workbooks with spreadsheets that use the same formula. On certain sheets, he can change the formula - is using the =LEFT(B6,1), but on others it gives him the error - "Don't Try it". On these cells, we can copy the formula from a sheet that it works on to this cell and then it works fine. There are no macros used in this workbooks. Any ideas of what could be preventing us from editing the formula, but yet allows us to paste a new formula from an existing cell that works? -- Rather be golfing |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have the date in a spreadsheet change automically. | Excel Discussion (Misc queries) | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Formula for Returning values in another spreadsheet | Excel Worksheet Functions | |||
| Change formula for Employee Shift Schedule template | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
