| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel cells changing to "#VALUE!" whenever another file is opened
I have an excel file and formulae in two of the columns is changing to
"#VALUE!", whenver a new file is opened and cells updated with data in the new file. All other cells are not effected and the only difference is, these two columns have Vookup function(to another sheet in the same file only).Also, pressing F2 in each cell and then pressing enter would calculate again. I have automatic calculation turned on. I could not understand why any change in a separate new file would mess up the formula in this file?Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "File Error: Data May Be Lost" when file saved on Mac is opened inWindows | Excel Discussion (Misc queries) | |||
| Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
| Automatic "data refresh" when XLS file is opened? | Excel Discussion (Misc queries) | |||
| Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Threaded Mode
