Since updating Office 2003 to 2007 Excel formulas do not work?

[Pheasant Plucker®]

Hi there,

We run a couple of spreadsheet 'templates' to extract data from a database
and generate some reports.

I updated Office Professional 2002XP to Office Professional 2003 last week
to be fully compatible with our Tablet PC's in the field and when we tried
to run the reports this week it would appear that the formulas for the gap &
lapse analysis are completely wrong?

Does this sound like the upgrade could have caused this type of problem?

Are there any compatibility issues between Excel 2002 & 2003?

 

[Niek Otten]

They should run fine. You don't tell us what "completely wrong"means, but do check that automatic calculation is on:
Tools>Options>Calculation tab, cheek Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi there,
|
| We run a couple of spreadsheet 'templates' to extract data from a database
| and generate some reports.
|
| I updated Office Professional 2002XP to Office Professional 2003 last week
| to be fully compatible with our Tablet PC's in the field and when we tried
| to run the reports this week it would appear that the formulas for the gap &
| lapse analysis are completely wrong?
|
| Does this sound like the upgrade could have caused this type of problem?
|
| Are there any compatibility issues between Excel 2002 & 2003?
|
| --
| Thanks & regards,
| -pp-
|
|

 

[Jim Cone]

There is a huge difference between Office 2007 and prior versions of Office.
However, Office 2002 and Office 2003 should be almost fully compatible.
I would expect that the only people in the world that understand the term
"gap & lapse analysis" work for your company.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Pheasant Plucker®"
<[email protected]>
wrote in message
Hi there,

We run a couple of spreadsheet 'templates' to extract data from a database
and generate some reports.

I updated Office Professional 2002XP to Office Professional 2003 last week
to be fully compatible with our Tablet PC's in the field and when we tried
to run the reports this week it would appear that the formulas for the gap &
lapse analysis are completely wrong?

Does this sound like the upgrade could have caused this type of problem?
Are there any compatibility issues between Excel 2002 & 2003?