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.

Not the answer you were hoping for, but you can choose not to display zeroes with Tools, Options, View, Zero Values.

Thanks

That seems to do the trick. Now if only word had that option, I'm having the same problem with a mail merge doc. Gotta love theese 'upgrades'.