Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
Problem with Interop.Excel after uninstalling Office 2007 and installing Office 2003 | Excel Programming | |||
Anyone Beta Testing Office 2007 | Excel Discussion (Misc queries) | |||
Office 2000/Office 2003 Excel not printing landscape vise versa | Setting up and Configuration of Excel | |||
Problem sharing spreadsheet between Office10 (Office XP) and Office 11 (Office 2003) | Excel Programming |