| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compatability issue
I have a workbook created in Excel 2003. I have opened this file in 2007. I
have saved it a with a .xlsm extension, A formula in say A1 is =IF(B1="Y",2,1). It always equates to 2 even when B1 is blank. The function argument says B1="Y" is true even thou B1is blank. Now if you create a new worksheet in this same workbook and copy the A1 formula to A1 on the new sheet it equate correctly. If you save the file in 07 to the compatible with 97 -03 the original formula equates correctly I migh |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compatability issue
OldJay,
What is your calculation mode set to? If you are in a manual calculation mode, then press F9 to recalculate the worksheet. Best, Matthew Herbert "oldjay" wrote: I have a workbook created in Excel 2003. I have opened this file in 2007. I have saved it a with a .xlsm extension, A formula in say A1 is =IF(B1="Y",2,1). It always equates to 2 even when B1 is blank. The function argument says B1="Y" is true even thou B1is blank. Now if you create a new worksheet in this same workbook and copy the A1 formula to A1 on the new sheet it equate correctly. If you save the file in 07 to the compatible with 97 -03 the original formula equates correctly I migh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro issue in XL03 "Compatability Mode" | Excel Programming | |||
| Macro issue in XL03 "Compatability Mode" | Excel Programming | |||
| Do I have a compatability issue here,,, | Excel Programming | |||
| Excell 2007 / 2003 Compatability Issue | Excel Worksheet Functions | |||
| Compatability | Excel Programming | |||
Linear Mode
