Testing under Office 07 and getting #DIV/0! and #VALUE!
 

I opened up a worksheet and found all the cells had the following errors


=BWData!AD164 = #VALUE!

=F10 = #DIV/0!

These are just examples. The #DIV/0! and #VALUE! are so basic I dont
understand whats going on? . Can anyone tell me why opening in office 2007
would do this to all the fields

Testing under Office 07 and getting #DIV/0! and #VALUE!
 

What are the formulas?
Did you create the workbook with another verson of Excel?
Is calculation set to manual?
Was there another spreadsheet open before you opened this one?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"TKM" wrote in message
...
I opened up a worksheet and found all the cells had the following errors


=BWData!AD164 = #VALUE!

=F10 = #DIV/0!

These are just examples. The #DIV/0! and #VALUE! are so basic I dont
understand whats going on? . Can anyone tell me why opening in office 2007
would do this to all the fields