I recently upgraded from office 2k to xp. I have an xls file with links to another xls file. If the cell in the source file is empty the cell in the linked file is showing a 0 (or zero value) rather than a blank cell. This was not happening in 2k.
Does anyone know why this is happening and how to prevent it? I'm trying to avoid going through all the formulas on several worksheets and adding an if statement to fix this.