| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas in excel 2007
I was recently upgraded to 2007 version and my formulas are not deisplyaing
from old documents. I have the automatic calculation on and their is no protection on the worksheet. The cell only has the result and no formula. Thank you Donna |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas in excel 2007
Is the worksheet protected with those cells locked (and hidden checked)?
Are you sure that the formulas haven't been replaced by their values? donna wrote: I was recently upgraded to 2007 version and my formulas are not deisplyaing from old documents. I have the automatic calculation on and their is no protection on the worksheet. The cell only has the result and no formula. Thank you Donna -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas in excel 2007
No the cells are not locked. Formulas replaced by their values how does that
happen? "Dave Peterson" wrote: Is the worksheet protected with those cells locked (and hidden checked)? Are you sure that the formulas haven't been replaced by their values? donna wrote: I was recently upgraded to 2007 version and my formulas are not deisplyaing from old documents. I have the automatic calculation on and their is no protection on the worksheet. The cell only has the result and no formula. Thank you Donna -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas in excel 2007
Someone could have selected the range and then used:
edit|copy followed by edit|paste special|values The equivalent could have been done in a macro. donna wrote: No the cells are not locked. Formulas replaced by their values how does that happen? "Dave Peterson" wrote: Is the worksheet protected with those cells locked (and hidden checked)? Are you sure that the formulas haven't been replaced by their values? donna wrote: I was recently upgraded to 2007 version and my formulas are not deisplyaing from old documents. I have the automatic calculation on and their is no protection on the worksheet. The cell only has the result and no formula. Thank you Donna -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas in excel 2007
That is probably what happened. Thank so much for your help, Dave
Donna "Dave Peterson" wrote: Someone could have selected the range and then used: edit|copy followed by edit|paste special|values The equivalent could have been done in a macro. donna wrote: No the cells are not locked. Formulas replaced by their values how does that happen? "Dave Peterson" wrote: Is the worksheet protected with those cells locked (and hidden checked)? Are you sure that the formulas haven't been replaced by their values? donna wrote: I was recently upgraded to 2007 version and my formulas are not deisplyaing from old documents. I have the automatic calculation on and their is no protection on the worksheet. The cell only has the result and no formula. Thank you Donna -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 - Where is the Accept Labels in Formulas Option? | Excel Discussion (Misc queries) | |||
| excel 2007 formulas | Excel Worksheet Functions | |||
| Excel 2007 conversion - this file contains labels in formulas | Excel Discussion (Misc queries) | |||
| Using formulas from Quattro Pro in Excel 2007 | Excel Worksheet Functions | |||
Linear Mode
