Working on multiple spreadsheets at the same time

[Adrian]

Hi,

I have created an excel template (without any formulas) and copied it across
multiple spreadsheets. After filling in some numbers on each of the
spreadsheet, now I have to add some formulas. I have tried selecting all the
spreadsheets and work just in one. Supposedly, the formulas I've added on one
spreadsheet should be automatically replicated on the other. However, rather
than having, for example "+M28*12/10, the other spreadsheets read something
like "+FC(-1)*12/10".
Does anybody know what's happening? Why aren't the formulas being copied
correctly? All text and numbers I add are replicated but the formulas aren't!
Any help much appreciated!

 

[galimi]

Adrian,

You are in R1C1 reference style. In Excel 2003, goto Tools, Options,
General tab and deselect R1C1 reference style.

 

[Adrian]

Hi,

This was the first thing i checked out but it wasn't activated. Any other
suggestions?

Thanks!

 

[Shane Devenshire]

Hi,

A side question - what language is your spreadsheet in?

A side point 12/10 = 1.2 so =M21*1.2 is better because 1. it calculates
faster, 2. it avoids some calculation errors due to binary representation.

Another side point +M21*12/10 should be entered as =M21*12/10 forget the +
sign at the beginning that is a Lotus 1-2-3 remnent.

Cheers,
Shane Devenshire

 

[Adrian]

Shane!!

You hit the jackpot!! It was the "+" sign that was causing the error!! Need
to use the "="

THanks a ton!!!