| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking formulas from seperate workbook
I am using Microsoft Office Excel 2003. Im not sure whether this is possible
at all, but is there a way to make a formula where you extract data from seperate workbooks? I know you can do this using seperate worksheets, but unsure in regards to workbooks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking formulas from seperate workbook
Yes, but you can get into difficulties if the other workbooks aren't open
when you try to update values. -- David Biddulph "Andy@cmk" wrote in message ... I am using Microsoft Office Excel 2003. Im not sure whether this is possible at all, but is there a way to make a formula where you extract data from seperate workbooks? I know you can do this using seperate worksheets, but unsure in regards to workbooks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas within workbook but seperate sheets. | Excel Worksheet Functions | |||
| Linking Cells from seperate spreadsheets | Excel Worksheet Functions | |||
| Merging seperate workbooks into one workbook | Excel Discussion (Misc queries) | |||
| How do I sum rounded values from two seperate formulas in Excel? | Excel Worksheet Functions | |||
| Can Excel open each workbook in a seperate window | Setting up and Configuration of Excel | |||
Linear Mode
