| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working on multiple spreadsheets at the same time
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Working on multiple spreadsheets at the same time
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Working on multiple spreadsheets at the same time
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" 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Working on multiple spreadsheets at the same time
Shane!!
You hit the jackpot!! It was the "+" sign that was causing the error!! Need to use the "=" THanks a ton!!! "Shane Devenshire" wrote: 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" 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I close all excel spreadsheets at one time? | Excel Discussion (Misc queries) | |||
| HOW CAN YOU ADD 3 SPREADSHEETS AT THE SAME TIME? | Excel Worksheet Functions | |||
| copy & paste formula between spreadsheets - not working | Excel Worksheet Functions | |||
| How to update multiple links in multiple spreadsheets followin mo. | Excel Worksheet Functions | |||
Linear Mode
