ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Since updating Office 2003 to 2007 Excel formulas do not work? (https://www.excelbanter.com/excel-discussion-misc-queries/174509-since-updating-office-2003-2007-excel-formulas-do-not-work.html)

Pheasant PluckerŪ

Since updating Office 2003 to 2007 Excel formulas do not work?
 
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-



Niek Otten

Since updating Office 2003 to 2007 Excel formulas do not work?
 
They should run fine. You don't tell us what "completely wrong"means, but do check that automatic calculation is on:
ToolsOptionsCalculation tab, cheek Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Pheasant PluckerŪ" 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?
|
| --
| Thanks & regards,
| -pp-
|
|



Jim Cone

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

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Ū"

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?
--
Thanks & regards,
-pp-




All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com