| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data
sheet that is being refreshed. 5878 is the correct number of rows and 5824 is not. I can find and replace in my formulas to correct the problem, but it does it each time the data is refreshed. Any suggestions as to why? =(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense! $C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Exp ense!$M$2:$M$5878))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refreshing data from a linked *.dbf database file without opening it. | Links and Linking in Excel | |||
| Changing linked worksheet and range of cells | Excel Discussion (Misc queries) | |||
| Refreshing Excel worksheet with data linked from Access | Excel Discussion (Misc queries) | |||
| How can I stop charts from refreshing when changing source data? | Charts and Charting in Excel | |||
| how do i record changing cell data (cell is dde linked) | Excel Discussion (Misc queries) | |||
Threaded Mode
