| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking in Excel
I have several worksheets that are linked. I have 12 that populate data on
another (main one). When I open the main one, I am getting a #VALUE message. Why would I have to open all 12 other worksheets before the data shows up correctly? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking in Excel
Some formulas do not work with closed spreadsheets... Let us know which
formulas are not working and perhaps we can give you a workaround... -- HTH... Jim Thomlinson "cjohnson" wrote: I have several worksheets that are linked. I have 12 that populate data on another (main one). When I open the main one, I am getting a #VALUE message. Why would I have to open all 12 other worksheets before the data shows up correctly? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking in Excel
'[DAILY RECEIPTS RECORD-08-2008.xls]04'!$D$64+SUMIF('[DAILY RECEIPTS
RECORD-08-2008.xls]04'!$C$5:$C$55,"M",'[DAILY RECEIPTS RECORD-08-2008.xls]04'!$D$5:$D$55) "Jim Thomlinson" wrote: Some formulas do not work with closed spreadsheets... Let us know which formulas are not working and perhaps we can give you a workaround... -- HTH... Jim Thomlinson "cjohnson" wrote: I have several worksheets that are linked. I have 12 that populate data on another (main one). When I open the main one, I am getting a #VALUE message. Why would I have to open all 12 other worksheets before the data shows up correctly? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking in Excel | Excel Discussion (Misc queries) | |||
| Linking in Excel | Excel Discussion (Misc queries) | |||
| linking in excel | Excel Discussion (Misc queries) | |||
| Excel - Linking to other WBs | Excel Worksheet Functions | |||
| excel not linking | Excel Worksheet Functions | |||
Linear Mode
