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

T

TKM

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
 
N

Niek Otten

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?
 

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

Can't save my Office documents (after computer rebuild and reauthorization) 0
Macro to get rid of #DIV/0! 2
IE Automation - checkbox 7
#DIV/0! Question 6
Help with the old #DIV/0! chesnut 3
Not wanting to plot #div/0 1
not wanting #div/0 to chart as zero 2
Visio 2019 crashes when attempting to open drawing. 0

Top