After SP2, issues with excel

  • Thread starter Thread starter Gopi
  • Start date Start date
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
 
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?
 
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
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

After SP2, excel having issues 2
Display zero in the cells with Excel 2013 5
Weird Excel behavior 5
Weird Error with Arrays 1
Excell 2021 0
Workbook loads but does not display 2
PC often crashes, at the beginning or after pixels appear 3
Unable to remove the e-mail toolbar 1

Back
Top