View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Adrian Adrian is offline
external usenet poster
 
Posts: 57
Default Working on multiple spreadsheets at the same time

Hi,

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

Thanks!

"galimi" wrote:

Adrian,

You are in R1C1 reference style. In Excel 2003, goto Tools, Options,
General tab and deselect R1C1 reference style.
--
http://www.ExcelHelp.us

Call me at
1-888-MY-ETHER ext. 01781474



"Adrian" wrote:

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!