| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recalcualte formulas linked to other sheets (Excel 2003)
Hi,
I've got a consoldiated worksheet which gets it's data from 2 other worksheets. Only when I'm in a cell and do the F2 - Enter thing, I get a re-calculation. So F9 doesn't help. How can I get the re-calculations done (too many cells for the F2 + Enter thing). Theo |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Recalcualte formulas linked to other sheets (Excel 2003)
two things:
Tools Options Calculation and check Automatic and then CNTRL-ALT-F9 -- Gary''s Student - gsnu200765 "Theo" wrote: Hi, I've got a consoldiated worksheet which gets it's data from 2 other worksheets. Only when I'm in a cell and do the F2 - Enter thing, I get a re-calculation. So F9 doesn't help. How can I get the re-calculations done (too many cells for the F2 + Enter thing). Theo |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Recalcualte formulas linked to other sheets (Excel 2003)
Sorry, doesn't do the thing!
"Gary''s Student" wrote: two things: Tools Options Calculation and check Automatic and then CNTRL-ALT-F9 -- Gary''s Student - gsnu200765 "Theo" wrote: Hi, I've got a consoldiated worksheet which gets it's data from 2 other worksheets. Only when I'm in a cell and do the F2 - Enter thing, I get a re-calculation. So F9 doesn't help. How can I get the re-calculations done (too many cells for the F2 + Enter thing). Theo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I data sort multiple sheets in Excel that are linked with i | Excel Worksheet Functions | |||
| Linked Spreadsheets in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 form linked with another workbook | Links and Linking in Excel | |||
| Excel 2003 losing Linked Cells | Links and Linking in Excel | |||
| Excel 2003 - Linked Items | Excel Discussion (Misc queries) | |||
Linear Mode
