| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula only works when file is saved.
For some strange reason my formulas do not work until I save the sheet.I am
using 2007 with a file that was in 2003. Never had a problem before. It is in compatibility mode. when I enter the data nothing happens in the cell where the result is suppose to go. If I close and save the result shows up. If I open the file back up and take out the data I put in the result is still there, where it should be a zero. Something is screwed up. Multiple people have access to this file. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula only works when file is saved.
Sorry about the post . I found the problem. Somebody changed calculations
to manual "bob" wrote in message ... For some strange reason my formulas do not work until I save the sheet.I am using 2007 with a file that was in 2003. Never had a problem before. It is in compatibility mode. when I enter the data nothing happens in the cell where the result is suppose to go. If I close and save the result shows up. If I open the file back up and take out the data I put in the result is still there, where it should be a zero. Something is screwed up. Multiple people have access to this file. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
| how to restore link in the formula via file saved from emails | Excel Discussion (Misc queries) | |||
| Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
| How do I convert works file to excel without works software? | Excel Discussion (Misc queries) | |||
| Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) | |||
Linear Mode
