After SP2, issues with excel

G

Gopi

Hi

After applying the Office SP2, Excel is displaying zero cells as #N/A. In
SP1 display was fine.

Any idea how to fix this?

Thanks
Gopi
 
D

Dave Peterson

Are there formulas in those cells or just 0's?

If you select the cell, what do you see in the formula bar?

And you don't have some sort of custom format for those cells, do you?
 
G

Gopi

Hi Dave

Are there formulas in those cells or just 0's? - There are formulas in the
cells

If you select the cell, what do you see in the formula bar? - Formulas

And you don't have some sort of custom format for those cells, do you? - No

Thanks
Gopi
 
D

Dave Peterson

What makes you think that the formula shouldn't return #n/a?

Maybe the formula points at other cells that include #n/a, so it returns #N/A.

What's the formula.

And what is in the cells that the formula points to?
 
Top