FR Compatability with Excel 2007

[tolver]

One of our machines has recently been upgraded to Office 2007. When running an FR report, we are seeing odd results - for example, a formula that once read "=sum(G8:G9)" now reads "=sum(R[-2]C:R[-1]C)". Also, all formatting is lost when running the report.

We are running Accpac 5.1.

Does anyone know if there is a fix for this?

Thanks,
Tracey

 

[Jay Converse]

The difference in the formulas is basic Excel setup - you can change the references from letters to column numbers anytime you want. It's been that way for years.

But in any case, Accpac 5.1 is not compatible with Excel '07. Upgrade Accpac, or downgrade Excel.