I have a workbook we use for auditing/proposing projects that was created in Excel 2003 and when I opened and converted it to 2010 my DSUM functions are working properly. I am not the person who built it originally and I am not by any means an Excel expert so I am a little lost and need some help. I have upgraded to 2010 and need to get it to work properly in 2010.
My first question - Is there something I can do when coverting the 2003 version to 2010 to maintain the functions...did I possibly do something that would screw up the integrity of the formulas? When I open the 2003 in 2010 I get the following error "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features".
Secondly - Here's the data from the first workbook:
Audit Sheet:
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col></colgroup>
Here's the 2nd worksheet with DSUM Function - This is supposed to find all Fixt # that match and total them. Here;s the formula being used and then a copy of the data in the 2nd worksheet
Current Formula - =DSUM('Input Form'!$A$5:$L$681,4+1,$A7:$A8)
2nd worksheet Data:
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>
Here's the 2nd page of the 2010 workbook after converting:
DSUM formula: =DSUM('Input Form'!$A$5:$M$681,7+1,$A37:$A38)
Here's how the data is being returned:
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>
Any help is appreciated!! Or is anyone interested in helping me build a new one from scratch for $$?
My first question - Is there something I can do when coverting the 2003 version to 2010 to maintain the functions...did I possibly do something that would screw up the integrity of the formulas? When I open the 2003 in 2010 I get the following error "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features".
Secondly - Here's the data from the first workbook:
Audit Sheet:
| Floor | Room Description | Fixt # | Qty | INOPS | Total | Comp | Incomp | |
| 3rd | Reception | 3 | 2 | 2 | 2 | |||
| 3rd | Reception | 5 | 2 | 2 | 2 | |||
| 3rd | Reception | 28 | 2 | 2 | 2 | |||
| 3rd | Open Cubicle Area | 3 | 24 | 24 | 24 | |||
| 3rd | Open Cubicle Area | 8 | 2 | 2 | 2 | |||
| 3rd | Office #1 | 3 | 1 | 1 | 1 | |||
| 3rd | Office #2 | 2 | 4 | 4 | 4 | |||
| 3rd | Open Cubicle Area | 3 | 24 | 24 | 24 | |||
| 3rd | Open Cubicle Area | 8 | 2 | 2 | 2 |
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col></colgroup>
Here's the 2nd worksheet with DSUM Function - This is supposed to find all Fixt # that match and total them. Here;s the formula being used and then a copy of the data in the 2nd worksheet
Current Formula - =DSUM('Input Form'!$A$5:$L$681,4+1,$A7:$A8)
2nd worksheet Data:
| Fixt # | Qty | Adj | Total |
| 1 | 10 | 0 | 10 |
| 2 | 26 | 0 | 26 |
| 3 | 225 | 0 | 225 |
| 5 | 8 | 0 | 8 |
| 8 | 18 | 0 | 18 |
| 16 | 2 | 0 | 2 |
| 17 | 4 | 0 | 4 |
| 20 | 1 | 0 | 1 |
| 21 | 1 | 0 | 1 |
| 28 | 2 | 0 | 2 |
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>
Here's the 2nd page of the 2010 workbook after converting:
DSUM formula: =DSUM('Input Form'!$A$5:$M$681,7+1,$A37:$A38)
Here's how the data is being returned:
| Fixt # | Qty | Adj | Total | Comp | Incomp |
| 1 | 10 | 0 | 0 | 0 | |
| 2 | 133 | 10 | 0 | 0 | 0 |
| 3 | 133 | 10 | 0 | 0 | 0 |
| 4 | 133 | 10 | 0 | 0 | 0 |
| 5 | 133 | 10 | 0 | 0 | 0 |
| 6 | 133 | 10 | 0 | 0 | 0 |
| 7 | 133 | 10 | 0 | 0 | 0 |
| 8 | 133 | 10 | 0 | 0 | 0 |
| 9 | 133 | 10 | 0 | 0 | 0 |
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>
Any help is appreciated!! Or is anyone interested in helping me build a new one from scratch for $$?
